Thread: [SQLObject] Superset inheritence
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: John B. <jb...@te...> - 2003-10-22 11:30:15
|
Hello, I come from the world of Java and 'Objectmatter' (www.objectmatter.com). I'm rather fond of Objectmatter, and it supports superset mappings rather nicely. If I wanted to model the following using SQLObject, is it possible? class Area (SQLObject): address = StringCol() class House (Area): someField = StringCol() class Office (Area): department = IntCol() So I had tables Area, House and Office created, where House and Office had a foreign key to a row in Area. Therefore inserting an Office would mean I had one row in Area and one row in Office inserted. This then means I can have a collection of Areas, and not care whether they are a House or an Office. I've found SQLObject to create a table for House and Office using the above example, but put the address field in both tables and not create an Area table. Thanks John -- John Baker, Senior Developer, TEAM. http://www.teamenergy.com Views expressed in this mail are my own. |
From: Ian B. <ia...@co...> - 2003-10-22 17:01:53
|
This is covered in the FAQ: http://sqlobject.org/docs/FAQ.html#how-does-inheritance-work On Wednesday, October 22, 2003, at 05:21 AM, John Baker wrote: > Hello, > > I come from the world of Java and 'Objectmatter' > (www.objectmatter.com). I'm > rather fond of Objectmatter, and it supports superset mappings rather > nicely. > > If I wanted to model the following using SQLObject, is it possible? > > class Area (SQLObject): > address = StringCol() > > class House (Area): > someField = StringCol() > > class Office (Area): > department = IntCol() > > So I had tables Area, House and Office created, where House and Office > had a > foreign key to a row in Area. Therefore inserting an Office would mean > I had > one row in Area and one row in Office inserted. This then means I can > have a > collection of Areas, and not care whether they are a House or an > Office. > > I've found SQLObject to create a table for House and Office using the > above > example, but put the address field in both tables and not create an > Area > table. > > Thanks > > > John > > -- > John Baker, Senior Developer, TEAM. > http://www.teamenergy.com > Views expressed in this mail are my own. > > > ------------------------------------------------------- > This SF.net email is sponsored by OSDN developer relations > Here's your chance to show off your extensive product knowledge > We want to know what you know. Tell us and you have a chance to win > $100 > http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54 > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > -- Ian Bicking | ia...@co... | http://blog.ianbicking.org |