Hi.
How can I use "...WHERE sth NOT IN (1, 4 ,5)" queries when using ORM
quering? There is '_in' only and I don't see how can I pass negation
to it. I tried to use general 'op' but I get these errors:
>>> Session.query(Region).filter(Region.id.op('NOT IN')( [1,2,3] )).all()
ProgrammingError: (ProgrammingError) syntax error at or near "ARRAY"
LINE 3: WHERE "Region".id NOT IN ARRAY[1, 2, 3] ORDER BY "Region".id
^
'SELECT "Region".id AS "Region_id", "Region".name AS "Region_name"
\nFROM "Region" \nWHERE "Region".id NOT IN %(id_1)s ORDER BY
"Region".id' {'id_1': [1, 2, 3]}
(using tuple instead of a list)
>>> Session.query(Region).filter(Region.id.op('NOT IN')( (1,2,3) )).all()
(ProgrammingError) can't adapt 'SELECT "Region".id AS "Region_id",
"Region".name AS "Region_name" \nFROM "Region" \nWHERE "Region".id NOT
IN %(id_1)s ORDER BY "Region".id' {'id_1': (1, 2, 3)}
(using string instead of a tuple)
>>> Session.query(Region).filter(Region.id.op('NOT IN')( '(1,2,3)' )).all()
ProgrammingError: (ProgrammingError) syntax error at or near
"E'(1,2,3)'"
LINE 3: WHERE "Region".id NOT IN E'(1,2,3)' ORDER BY "Region".id
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
