Thread: [SQLObject] foreign keys in sqlobject 0.7
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Todd G. <tgr...@ya...> - 2005-10-25 17:00:34
|
I'm cross posting from the turbogears news group (http://groups.google.com/group/turbogears/browse_frm/thread/0ef9deab591d6aae) I have a very simple model (below) that does not seem to process properly due (I'm guessing here) to the presence of the Foreign Key: REPRO: $ tg-admin shell (starts an ipython session) 1: p = Page(pagename="FooFoo") 4: dir(p) 'addColumn', 'addIndex', 'addJoin', ERROR: - there should be an addEntry in the Page object 'p' #model.py class Page(SQLObject): pagename = StringCol(alternateID=True, length=30) entries = MultipleJoin('Entry') class Entry(SQLObject): data = StringCol() page = ForeignKey('Page') Am I missing something here? Please cc me as I am not subscribed to this list. -Todd |
From: Humberto D. <adm...@di...> - 2005-10-26 01:02:08
|
AFAIK, SQLObject will create an addSomething method only for RelatedJoins= . In your case you would do: page =3D Page(pagename=3D"FooFoo") entry =3D Entry(page=3Dpage, data=3D"Bar") But it seems to me that it wouldn't do any harm to have SQLObject add a m= ethod for MultipleJoins too... On Tue, 25 Oct 2005 09:59:50 -0700 Todd Greenwood <tgr...@ya...> wrote: > I'm cross posting from the turbogears news group=20 > (http://groups.google.com/group/turbogears/browse_frm/thread/0ef9deab591d= 6aae) >=20 > I have a very simple model (below) that does not seem to process properly= due (I'm guessing here) to=20 > the presence of the Foreign Key: >=20 > REPRO: > $ tg-admin shell (starts an ipython session) > 1: p =3D Page(pagename=3D"FooFoo") > 4: dir(p) > 'addColumn', > 'addIndex', > 'addJoin', >=20 > ERROR: > - there should be an addEntry in the Page object 'p' >=20 > #model.py > class Page(SQLObject): > pagename =3D StringCol(alternateID=3DTrue, length=3D30) > entries =3D MultipleJoin('Entry') >=20 > class Entry(SQLObject): > data =3D StringCol() > page =3D ForeignKey('Page') >=20 > Am I missing something here? >=20 > Please cc me as I am not subscribed to this list. > -Todd --=20 Humberto Di=F3genes Diginet Brasil --=20 Esta mensagem foi verificada pelo sistema de anti-virus e acredita-se estar livre de perigo. |