johnf wrote: > On Thursday 14 May 2009 09:29:44 am Paul McNett wrote: >> create table people (id integer primary key, >> name char); >> >> create table categories (id integer primary key, >> name char); >> >> create table peoplecat (id integer primary key, >> person_id, >> category_id); >> >> The peoplecat table is the intermediary table. So I make a bizobj on the >> peoplecat table, with SQL like: >> >> select peoplecat.id as id, >> peoplecat.person_id as person_id, >> peoplecat.category_id as category_id, >> people.name as person_name, >> categories.name as category_name >> left join people >> on people.id = peoplecat.person_id >> left join categories >> on categories.id = peoplecat.category_id >> group by peoplecat.id >> >> I then make 2 subclasses, PeopleForCategory and CategoriesForPerson. >> PeopleForCategory has a LinkField of category_id, and CategoriesForPerson >> has a LinkField of person_id. >> >> Your People bizobj adds CategoriesForPerson as a child, and your Categories >> bizobj adds PeopleForCategory as a child. > > Trying to get my head around this. How do I create the subclasses???
Just like any other subclass. > class PeopleForCategory(Bizobj_peoplecat,dabo.biz.dBizobj) > def afterInit(self): > self.LinkField = 'category_id' No. class BizPeopleCat(dabo.biz.dBizobj): def initProperties(self): ... create the sql, set the common props, etc. class PeopleForCategory(BizPeopleCat): def initProperties(self): self.super() # get the common props initialized self.LinkField = 'category_id' HTH Paul _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/4a0c595e.3020...@ulmcnett.com