gmane.comp.python.sqlalchemy.user

sbhatt | 15 May 21:50

SA with ORACLE connect


Hi All,

I want to write a query in SA which uses ORACLE 'connect' along with
joins on other table.
The query will be:-
SELECT grouprelation.grouprelationid AS grouprelation_grouprelationid,
grouprelation.parentgroupid AS grouprelation_parentgroupid,
grouprelation.childgroupid AS grouprelation_childgroupid FROM
grouprelation, grouptable CONNECT BY childgroupid = PRIOR
parentgroupid START WITH childgroupid = 91 AND
grouprelation.parentgroupid = grouptable.groupid AND
grouptable.wfstatus != 'I'

I tried writing it in SA as following:-

connectstring = "connect by childgroupid = prior parentgroupid start
with childgroupid = 91"

query =
session.query(GroupRelation).filter(sql.and_(GroupRelation.c.parentgroupid
== GroupTable.c.groupid, GroupTable.c.wfstatus != 'I', connectstring))

compiles to

SELECT grouprelation.grouprelationid AS grouprelation_grouprelationid,
grouprelation.parentgroupid AS grouprelation_parentgroupid,
grouprelation.childgroupid AS grouprelation_childgroupid FROM
grouprelation, grouptable WHERE grouprelation.parentgroupid =
grouptable.groupid AND grouptable.wfstatus != 'I' AND connect by

(Continue reading)

headers

Michael Bayer | 15 May 22:17

Re: SA with ORACLE connect


On May 15, 2008, at 3:53 PM, sbhatt wrote:

>
> Does anyone know how to write it using SA ?
>

CONNECT BY goes where things like ORDER BY and GROUP BY go, so is not  
going to work within the WHERE clause.  It is as of yet unsupported by  
the select() construct so you'd have to go with from_statement() for  
now.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy <at> googlegroups.com
To unsubscribe from this group, send email to sqlalchemy-unsubscribe <at> googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---