[Sqlalchemy-users] Question about backrefs and query options

2006-07-04 Thread Steve Zatz
It seems that if you define a mapper relationship through a backref, that relationship does not appear to be 'visible' when setting options on a query. For example: mapper(Item, item_table, properties = {'reminder': relation(Reminder, backref='item')}) mapper(Reminder, reminder_table) If you th

Re: [Sqlalchemy-users] firebirdsql.py: global name 'sql' is not defined

2006-07-04 Thread Lele Gaifax
Uwe Grauer wrote: > i saw another issue with func.now(). > But i do not know how to deal with it. > In FB you can't use something like 'select now from rdb$database'. > I think the usage of such things is database specific. The FB idiom for that is either SELECT cast('now' as timestamp) FROM r

Re: [Sqlalchemy-users] firebirdsql.py: global name 'sql' is not defined

2006-07-04 Thread Uwe Grauer
Michael Bayer wrote: > sure, is that all it needs ? > > Thanks, i saw another issue with func.now(). But i do not know how to deal with it. In FB you can't use something like 'select now from rdb$database'. I think the usage of such things is database specific. I will get back if i find out mo