http://sqlalche.me/e/cd3x
On Thu, Apr 26, 2018 at 8: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' > > 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#sqlalche >> my.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 a topic in the >> Google Groups "sqlalchemy" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/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.
