Figured it out on my own :-)
You need the following for a mapper:
...
properties = { ...
'forks':relation(Fork,
secondary=UtensileTable,
primaryjoin=PlaceSetting.c.id==UtensileTable.c.placeSettingID,
secondaryjoin=UtensileTable.c.id==ForkTable.c.id,
backref=backref("placeSetting",
remote_side=[UtensileTable.c.id]),
)
...
enjoy
-percious
On Apr 13, 11:51 am, "percious" <[EMAIL PROTECTED]> wrote:
> I am trying to do something like this:
>
> PlaceSettingTable = Table("place_setting", metadata,
> Column('id', Integer, primary_key=True)
> )
>
> UtensileTable = Table("utensile", metadata,
> Column('id', Integer, primary_key=True),
> Column('name', Unicode(256)),
> Column('placeSettingID', Integer,
> ForeignKey('place_setting.id'))
> )
>
> ForkTable = Table("fork", metadata,
> Column('id', Integer, ForeignKey('utensile.id'),
> primary_key=True),
> Column('numberOfTines', Integer),
> )
> SpoonTable = Table("spoon", metadata,
> Column('id', Integer, ForeignKey('utensile.id'),
> primary_key=True),
> )
> KnifeTable = Table("knife", metadata,
> Column('id', Integer, ForeignKey('utensile.id'),
> primary_key=True),
> )
>
> class PlaceSetting(object):pass
> class Utensile(object):pass
> class Fork(object):pass
> class Knife(object):pass
> class Spoon(object):pass
>
> utensileMapper = mapper(Utensile, UtensileTable)
> forkMapper = mapper(Fork, ForkTable, inherits=utensileMapper)
>
> placeSettingMapper = mapper(PlaceSetting, PlaceSettingTable,
> properties={'forks':relation(Fork,
>
> primaryjoin=PlaceSettingTableTable.c.id==Fork.c.placeSettingID,
>
> backref=backref("placeSetting", remote_side=[UtensileTable.c.id]))
> }
> )
>
> unsuccessfully.....
>
> Anyone have any ideas?
>
> -chris
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
