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
-~----------~----~----~----~------~----~------~--~---
