[sqlalchemy] NOT IN in orm queries

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:

[sqlalchemy] Re: NOT IN in orm queries

from sqlalchemy import not_ session.query(Region).filter(not_(Region.id.in_( (1,2,3) ))) alternately, session.query(Region).filter(~ Region.id.in_( (1,2,3) )) On Tue, Sep 2, 2008 at 6:59 AM, Artur Siekielski [EMAIL PROTECTED] wrote: Hi. How can I use ...WHERE sth NOT IN (1, 4 ,5) queries

[sqlalchemy] Re: NOT IN in orm queries

Oh thanks... I thought that negation works for sql-expression queries only. Maybe some info should be added to ORM documentation? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this

[sqlalchemy] Re: specifying schema in declarative mappers

it is available via __table_args__, i.e.: class MyClass(...): __table_args__ = {'schema':'myschema'} On Sep 2, 2008, at 6:35 AM, Diez B. Roggisch wrote: Hi, I'm trying to enhance sqlalchemy-migrate to have schema-support. In the latest SVN-Versions, it supports declarative

[sqlalchemy] Re: getting schema list

On Sep 1, 2008, at 2:17 PM, Diez B. Roggisch wrote: Hm. I think it belongs to SA, because that should be an agnostic function migrate (and other tools/libs) just can use. I don't mind writing it for the DB I've got access to (postgres) - however, if you don't see any chance for

[sqlalchemy] Re: issue with delete(obj) and ManyToOne relations

On Sep 2, 2008, at 12:06 PM, Remi Jolin - SysGroup wrote: Hello, Here is a small example of my issue (it's Elixir syntax, but I think it's not an Elixir specific issue) : class Rec(Entity): collection = ManyToOne('Coll') class Coll(Entity): recs = OneToMany('Rec') r1 = Rec()

[sqlalchemy] onupdate Column attribute with joined table inheritance question

Hi, I'm using joined table inheritance much like the example given here: http://www.sqlalchemy.org/docs/05/mappers.html#advdatamapping_mapper_inheritance_joined Additionally, in the employees table, I would like an update_timestamp column of type DateTime: Column('update_timestamp', DateTime,

[sqlalchemy] Re: onupdate Column attribute with joined table inheritance question

On Sep 2, 2008, at 3:06 PM, Sam Magister wrote: Hi, I'm using joined table inheritance much like the example given here: http://www.sqlalchemy.org/docs/05/mappers.html#advdatamapping_mapper_inheritance_joined Additionally, in the employees table, I would like an update_timestamp column

[sqlalchemy] Re: onupdate Column attribute with joined table inheritance question

On Tuesday 02 September 2008 22:50:09 Michael Bayer wrote: On Sep 2, 2008, at 3:06 PM, Sam Magister wrote: Hi, I'm using joined table inheritance much like the example given here: http://www.sqlalchemy.org/docs/05/mappers.html#advdatamapping_map per_inheritance_joined

[sqlalchemy] Re: issue with delete(obj) and ManyToOne relations

le 02.09.2008 18:33 Michael Bayer a écrit: On Sep 2, 2008, at 12:06 PM, Remi Jolin - SysGroup wrote: Hello, Here is a small example of my issue (it's Elixir syntax, but I think it's not an Elixir specific issue) : class Rec(Entity): collection = ManyToOne('Coll') class

[sqlalchemy] Re: SA and Filemaker Pro

On Sep 1, 10:01 pm, KMCB [EMAIL PROTECTED] wrote: Hello, Being new to SA, I have read some more information and maybe I can be more specific.  I think I need a dialect file for filemaker through pyodbc.  I have gotten the pyodbc to FMP working. -kmcb one does not exist at the moment but