[sqlalchemy] Eagerloading a polymorphic relationship's attributes

2010-07-31 Thread Nikolaj
I have a one to one relationship between Company and Employee where Employee is subclassed using joined table inheritance into Manager and Engineer. I'm trying to query for a list of companies with the employee eagerloaded including the type-specific columns. I've been looking at the example at ht

Re: [sqlalchemy] Error with SqlSoup and Firebird engine

2010-07-31 Thread Michael Bayer
On Jul 31, 2010, at 3:46 PM, maxi wrote: > Hi, > > I'm trying to use SqlSoup with firebird backed. > My environment is: python 2.6, sqlalchemy 0.6.3 all in virtualenv. > The firebird version is 2.1 > > I do all steps to do a simple test: > > db = SqlSoup('firebird://SYSDBA:master...@127.0.0

Re: [sqlalchemy] Merge support with ConcreteInheritedProperty

2010-07-31 Thread Michael Bayer
On Jul 31, 2010, at 7:41 AM, Kent wrote: > I'm having a problem trying to merge() an object for which I have > setup a polymorphic_union: > > artran_union = polymorphic_union({ >'artran': artrans_table, >'archive': artransarchive_table >}, 'type', 'artran_union') > > artranb

[sqlalchemy] Error with SqlSoup and Firebird engine

2010-07-31 Thread maxi
Hi, I'm trying to use SqlSoup with firebird backed. My environment is: python 2.6, sqlalchemy 0.6.3 all in virtualenv. The firebird version is 2.1 I do all steps to do a simple test: db = SqlSoup('firebird://SYSDBA:master...@127.0.0.1/home/maxi/ databases/test.fdb') people = db.people.all()

[sqlalchemy] Merge support with ConcreteInheritedProperty

2010-07-31 Thread Kent
I'm having a problem trying to merge() an object for which I have setup a polymorphic_union: artran_union = polymorphic_union({ 'artran': artrans_table, 'archive': artransarchive_table }, 'type', 'artran_union') artranbase_mapper = mapper(ArTranBase, artran_union, polymorp