Unfortunately if the tables reference each other, then neither table can be created first. I've been running tg-admin sql sql, removing the constraints, then placing them at the bottom in ALTER TABLE statements (which works fine as all the tables exist by that point).
It should be possible to do this programmatically in some way, but I'm not sure how. Regexs seem an ugly solution, and a parser seems like too much work. Anyone got any ideas? Ed On 01/12/06, Stuart Clarke <[EMAIL PROTECTED]> wrote: > > You have to manually order the creation of tables. Include this near > the top of your model.py: > > soClasses = ( > 'Team', > 'Player') > > Player references Team (the ForeignKey), so Team needs to be created > first. > > This requirement is specific to PG, but your model will continue to work > with other DB systems. > > Stuart > > > On Thu, 2006-11-30 at 16:41 -0800, Suren wrote: > > This error seem to be a very common one but a clean solution is > > elusive. > > > > Using database URI postgres://postgres:[EMAIL PROTECTED]/fooball > > .........stack trace............ > > psycopg2.ProgrammingError: relation "team" does not exist' > > > > I am trying to follow the tutorial > > > > http://docs.turbogears.org/1.0/IntroductionToWidgets > > > > and want to use postgresql as that is our environment at work. It is > > linux based but for now I am trying this stuff on windows. I got > > turbogears a couple of days back... > > > > from sqlobject import * > > soClasses = ('Player','Team') > > from turbogears.database import PackageHub > > > > hub = PackageHub("Fooball") > > __connection__ = hub > > > > # class YourDataClass(SQLObject): > > # pass > > import datetime > > > > class Player(SQLObject): > > name = StringCol(length=40, alternateID=True) > > birthdate = DateCol(notNull=True) > > > > team = ForeignKey('Team') > > > > points = IntCol(default=0) > > > > class Team(SQLObject): > > city = StringCol(length=20, notNull=True) > > nickname = StringCol(length=20, notNull=True, alternateID=True) > > > > players = MultipleJoin('Player') > > > > > > Folks here keep mentioning about a 279 patch..what is it and how can I > > get it? I checked the trunks for SQLObject and they did not have the > > same solution that was atleast proposed in 279. Can someone point me to > > a place where I can have these errors fixed? > > > > I will try the creation manually but it would be nice to have a working > > tutorial for all databases for newbies like me. Thank ya.. > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
