On Thursday, April 26, 2018 at 1:59:02 PM UTC-4, Jeremy Flowers wrote:
>
>
>> But I now have a stmt variable at the end..
> How do I iterate over that in the form:
> for row in results:
> print(row)
>
results = query.all()
for row in results:
print row
http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.all
If you want to see what it compiles to,
this will give you a general idea, but the SQL won't be compiled to the
active database...
print stmt
you can compile the query's statement with a specific dialect for your
database like this:
from sqlalchemy.dialects import oracleprint
str(stmt.statement.compile(dialect=oracle.dialect()))
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
