[sqlalchemy] Re: relation, primaryjoin, uselist=False How to LIMIT to 1?

2008-10-17 Thread Michael Bayer
On Oct 17, 2008, at 3:32 PM, g00fy wrote: hi, on Mapper() i have relation() i use primaryjoin, and uselist=False, but i also want to have LIMIT=1 on my join it would be much faster!! SA should add the limit itself when uselist=False uselist=False is intended for a one-to-one relation

[sqlalchemy] Re: relation, primaryjoin, uselist=False How to LIMIT to 1?

2008-10-17 Thread g00fy
I can't make this work with my relation: mapper(Warehouse, warehouse_table,properties = { 'translation': relation( WarehouseTranslation, lazy = False, uselist = False,

[sqlalchemy] Re: relation, primaryjoin, uselist=False How to LIMIT to 1?

2008-10-17 Thread Michael Bayer
On Oct 17, 2008, at 4:22 PM, g00fy wrote: I can't make this work with my relation: mapper(Warehouse, warehouse_table,properties = { 'translation': relation( WarehouseTranslation, lazy = False,