Is it possible to read multiple result sets using a ResultProxy object in sqlalchemy?

Question

I'm trying to call a stored procedure that returns multiple result sets using SQLAlchemy. If it matters, underneath I'm using PyODBC and FreeTDS. I call the execute() method using a raw query with "exec" calling my stored procedure on a session object and get a ResultProxy object back.

With a raw pyodbc cursor, I can call the nextset() function to advance to the next result set. I see no way to do the same using the ResultProxy I get back from SQLAlchemy. Indeed, the docs say:

The DBAPI cursor will be closed by the ResultProxy when all of its result rows (if any) are exhausted.

Is there a way to read multiple result sets with SQLAlchemy, or will I have to perform this query with the raw DBAPI?

I worked around it by using a different stored procedure that only had one result set. — Anton I. Sipos
– Anton I. Sipos, Commented Jun 19, 2021 at 20:21

zzzeek · Accepted Answer · 2012-04-28 04:55:29Z

11

support for nextset() is ticket 1635. It's two years old. It contains a partial patch which needs updating, in particular to work along with an execution option that passes along a hint that the statement will be returning multiple result sets, so that the resultproxy's existing autoclose behavior can remain the default. the feature would also need a lot of tests.

There's no major technical hurdle to this feature but there's generally very little interest in this use case. So at the moment you need to stick with the raw cursor, until people express enough interest in this feature to put momentum behind it again.

answered Apr 28, 2012 at 4:55

zzzeek

75.8k24 gold badges204 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Merickel · Accepted Answer · 2012-04-28 02:17:05Z

0

Have you read http://docs.sqlalchemy.org/en/rel_0_7/core/connections.html?highlight=resultproxy#basic-usage ? You can iterate over ResultProxy objects, close them, etc.

answered Apr 28, 2012 at 2:17

Michael Merickel

23.4k3 gold badges57 silver badges71 bronze badges

Collectives™ on Stack Overflow

Is it possible to read multiple result sets using a ResultProxy object in sqlalchemy?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related