Re: [SQLObject] help with circular foreign keys?

[inhahe <in...@gm...>]

On Tue, May 12, 2009 at 4:00 AM, Oleg Broytmann <ph...@ph...> wrote:

> On Tue, May 12, 2009 at 03:08:16AM -0400, inhahe wrote:
> > class Pics(SQLObject):
> >   itemid = IntCol()
> >   picdata = BLOBCol()
> >   thumbnail = ForeignKey("Thumbs", cascade='null')
> > try:
> >   Pics.createTable()
> >   print "Created table Pics"
> > except dberrors.OperationalError: pass
>
>    Why do you need these try/except?


i want it to create each table but only if the table doesn't already exist
if it already exists it gives me an operationalerror.
i had tried looking for a better way but couldn't find one!


>
> http://sqlobject.org/FAQ.html#mutually-referencing-tables
>
>
ah, thanks