> > I think it must have been down to the imports.. > By changing code for imports to this, it seemed to fix it. import sqlalchemy from tidal import Jobmst from sqlalchemy import create_engine, literal, text from sqlalchemy.dialects import oracle from sqlalchemy.orm import Session, aliased, sessionmaker
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) Despite my best efforts I can't seem to convert stmt (type : sqlalchemy.orm.query.Query). Maybe it's something to do with the way I've defined the session... A lot of the examples I've seen are using connection. I can't seem to execute() it, since I think execute takes a string perhaps? -- 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.
