[sqlalchemy] Re: SqlSoup joins broken in 0.5.3

2009-04-01 Thread Stu.Axon
Cheers, both of these worked. On Mar 31, 5:19 pm, Michael Bayer mike...@zzzcomputing.com wrote: oh, you could send that as a tuple to join, i.e. db.devmap_device.join((db.devmap_manufacturer,   db.devmap_device.manufacturer_id == db.devmap_manufacturer.id)).first() this because join()

[sqlalchemy] Re: SqlSoup joins broken in 0.5.3

2009-03-31 Thread Jonathan Ellis
You can't just throw filter expressions into the join call in modern sqla. Try db.devmap_device.join(db.devmap_manufacturer).filter(db.devmap_device.manufacturer_id == db.devmap_manufacturer.id).first() -Jonathan On Tue, Mar 31, 2009 at 8:23 AM, Stu.Axon stu.a...@gmail.com wrote: Heres some

[sqlalchemy] Re: SqlSoup joins broken in 0.5.3

2009-03-31 Thread Michael Bayer
oh, you could send that as a tuple to join, i.e. db.devmap_device.join((db.devmap_manufacturer, db.devmap_device.manufacturer_id == db.devmap_manufacturer.id)).first() this because join() accepts a list of join conditions, a composite condition is sent as a tuple. On Mar 31, 2009, at