Another mistake.... I did not write unit tests. I'm not experienced with unit testing. Can someone help me here?

--
JP

On 10/2/05, Joćo Paulo Fernandes Farias <jpaulofarias@gmail.com> wrote:
Hi!

I did a forward to SQLObject-Discuss just after sending my message... ;-)

--
JP


On 10/2/05, Kevin Dangoor < dangoor@gmail.com> wrote:
Hi JP,

I'm forwarding your message on to the SQLObject list for further review.

Does your patch include unit tests?

Kevin

---------- Forwarded message ----------
From: Joćo Paulo Fernandes Farias < jpaulofarias@gmail.com>
Date: Oct 2, 2005 9:09 AM
Subject: [TurboGears] Re: How to create tables with cyclic references?
To: turbogears@googlegroups.com


Hi!

I've patched SQLObject to do late reference on creation of tables.

It is no 100%, but it is a starting point.

I've attached the patch.

--
JP


On 10/1/05, Ian Bicking <ianb@colorstudy.com> wrote:
>
> Joćo Paulo Fernandes Farias wrote:
> > Hi!
> >
> > How do I create tables with cyclic references?
> >
> > As an example, suppose we have two classes:
> >
> > class A(SQLObject):
> >     b = ForeignKey('B')
> >
> > class B(SQLObject):
> >     a = ForeignKey('A')
> >
> >
> > /me using turbogears...
> >
> > I issue a: turbogears-admin.py sql create
> >
> > It gives me some erros because it tries to create table A but B does not
> > exists, so it cannot be referenced.
> >
> > My suggestion is: Create all tables and then issue all the "alter table
> > add constraint" as necessary.
>
> This is kind of hard.  Technically you can do it like:
>
> class A(SQLObject):
>     b = ForeignKey('B')
>
> class B(SQLObject):
>     pass
>
> def create():
>     B.createTable()
>     A.createTable()
>     B.sqlmeta.addColumn (ForeignKey(name='a', foreignKey='A'),
> changeSchema=True)
>
>
> However, this won't work with sqlobject-admin (and thus
> turbogears-admin.py).
>




--
Kevin Dangoor
Author of the Zesty News RSS newsreader

email: kid@blazingthings.com
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com