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# > 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 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.
