On Thu, Apr 26, 2018 at 3:16 PM, Jeremy Flowers <[email protected]> wrote: > Since the SQL injects parameters into the string, this doesn't seem to work. > eg: > A value is required for bind parameter 'param_1'
What Jonathan said was, "If you want to see what it compiles to,", meaning, using compile() is a way for you to quickly see for yourself what SQL query would be generated for a particular statement. To actually run it, you normally want to stick with the existing methods, e.g. query.all(), session.execute(), etc. That's where the parameter values are correctly bound before passing along to the database. > > WITH j1(jobmst_id, jobmst_name, jobmst_prntid, jobmst_type, lvl) AS > (SELECT jobmst.jobmst_id AS jobmst_id, jobmst.jobmst_name AS jobmst_name, > jobmst.jobmst_prntid AS jobmst_prntid, jobmst.jobmst_type AS jobmst_type, > :param_1 AS lvl > FROM jobmst > WHERE jobmst.jobmst_prntid IS NULL UNION ALL SELECT j2.jobmst_id AS > j2_jobmst_id, j2.jobmst_name AS j2_jobmst_name, j2.jobmst_prntid AS > j2_jobmst_prntid, j2.jobmst_type AS j2_jobmst_type, j1.lvl + :lvl_1 AS > anon_1 > FROM jobmst j2 JOIN j1 ON j2.jobmst_prntid = j1.jobmst_id > WHERE j2.jobmst_prntid IS NOT NULL) > SELECT jobmst_id, jobmst_name, jobmst_prntid, jobmst_type, lvl > FROM (SELECT jobmst_id, jobmst_name, jobmst_prntid, jobmst_type, lvl, ROWNUM > AS ora_rn > FROM (SELECT SEARCH DEPTH FIRST BY JOBMST_NAME SET DISP_SEQ j1.jobmst_id AS > jobmst_id, j1.jobmst_name AS jobmst_name, j1.jobmst_prntid AS jobmst_prntid, > j1.jobmst_type > AS jobmst_type, j1.lvl AS lvl > FROM j1 ORDER BY DISP_SEQ) > > On Thu, Apr 26, 2018 at 7:24 PM, Jonathan Vanasco <[email protected]> > wrote: >> >> >> 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 oracle >> print 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 a topic in the >> Google Groups "sqlalchemy" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/sqlalchemy/aWJT1VdY3LU/unsubscribe. >> To unsubscribe from this group and all its topics, 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. > > > -- > 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. -- 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.
