[SQLObject] Superset inheritence

[John B. <jb...@te...>]

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.