Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-16 Thread Daniel Nogradi
> Thanks very much! It really seems inheritance itself is a bit buggy. > Good news is that it has the same bug in probably all db backends :) Submitted a ticket to trac. - This SF.net email is sponsored by DB2 Express Downloa

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-15 Thread Daniel Nogradi
> > > > > Hi, can you please test the code below (if you have sqlite)? If you > > > > > use a different db, can you please change the connectionForURI to > use > > > > > yours and test then? The correct output should be 5 of course. > > > > > > > > I can't, but I don't see the point. What do you ex

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-15 Thread Oleg Broytmann
On Fri, Jun 15, 2007 at 02:00:51PM -0300, Leandro Lucarella wrote: > I thought Oleg tested that. Sorry, I didn't. I have upgraded OS on my computer, and I am still not fully up. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-15 Thread Leandro Lucarella
Leandro Lucarella, el 15 de junio a las 14:00 me escribiste: > Daniel Nogradi, el 14 de junio a las 17:19 me escribiste: > > > > Hi, can you please test the code below (if you have sqlite)? If you > > > > use a different db, can you please change the connectionForURI to use > > > > yours and test t

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-15 Thread Leandro Lucarella
Daniel Nogradi, el 14 de junio a las 17:19 me escribiste: > > > Hi, can you please test the code below (if you have sqlite)? If you > > > use a different db, can you please change the connectionForURI to use > > > yours and test then? The correct output should be 5 of course. > > > > I can't, but I

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-14 Thread Daniel Nogradi
> > > > > > > > sqlobject.dberrors.OperationalError: no such column: > animal.cage_id > > > > > > > > > > > > > >But there is "cage_id" columnm in the "animal" table > > > > > > > > > > > > Well, that's exactly the problem :) > > > > > > > > > >Are you sure this part of the problem is in SQ

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-13 Thread Leandro Lucarella
Daniel Nogradi, el 12 de junio a las 14:41 me escribiste: > > > > > > > sqlobject.dberrors.OperationalError: no such column: > > > > > > > animal.cage_id > > > > > > > > > > > >But there is "cage_id" columnm in the "animal" table > > > > > > > > > > Well, that's exactly the problem :) > > > >

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-12 Thread Daniel Nogradi
> > > > > > sqlobject.dberrors.OperationalError: no such column: animal.cage_id > > > > > > > > > >But there is "cage_id" columnm in the "animal" table > > > > > > > > Well, that's exactly the problem :) > > > > > >Are you sure this part of the problem is in SQLObject and not in > SQLite? >

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-11 Thread Leandro Lucarella
Daniel Nogradi, el 10 de junio a las 20:52 me escribiste: > > > > > sqlobject.dberrors.OperationalError: no such column: animal.cage_id > > > > > > > >But there is "cage_id" columnm in the "animal" table > > > > > > Well, that's exactly the problem :) > > > >Are you sure this part of the pr

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-10 Thread Daniel Nogradi
> > > > sqlobject.dberrors.OperationalError: no such column: animal.cage_id > > > > > >But there is "cage_id" columnm in the "animal" table > > > > Well, that's exactly the problem :) > >Are you sure this part of the problem is in SQLObject and not in SQLite? > (There are probably other pro

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-10 Thread Oleg Broytmann
On Sun, Jun 10, 2007 at 05:46:32PM +0200, Daniel Nogradi wrote: > > > sqlobject.dberrors.OperationalError: no such column: animal.cage_id > > > >But there is "cage_id" columnm in the "animal" table > > Well, that's exactly the problem :) Are you sure this part of the problem is in SQLObjec

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-10 Thread Daniel Nogradi
> Here is a thin that puzzles me: > > On Sun, Jun 10, 2007 at 03:05:28PM +0200, Daniel Nogradi wrote: > > sqlobject.dberrors.OperationalError: no such column: animal.cage_id > >But there is "cage_id" columnm in the "animal" table Well, that's exactly the problem :) > there were a lot > of INS

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-10 Thread Oleg Broytmann
Here is a thin that puzzles me: On Sun, Jun 10, 2007 at 03:05:28PM +0200, Daniel Nogradi wrote: > sqlobject.dberrors.OperationalError: no such column: animal.cage_id But there is "cage_id" columnm in the "animal" table, there were a lot of INSERTs and SELECTs for the table before the traceback

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-10 Thread Daniel Nogradi
> > if the model is changed slightly to use inheritance: > > then the exact same query stops working. > >In what way? Here is a full traceback: 37/QueryOne: SELECT COUNT(*) FROM named LEFT JOIN cage ON ((animal.cage_id) = (cage.id)) LEFT JOIN zoo ON ((cage.zoo_id) = (zoo.id)) WHERE (((named.

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-10 Thread Oleg Broytmann
On Sat, Jun 09, 2007 at 06:37:04PM +0200, Daniel Nogradi wrote: > if the model is changed slightly to use inheritance: > then the exact same query stops working. In what way? Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't di

Re: [SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-09 Thread Daniel Nogradi
> Multiple LEFTJOINOn queries seem to work if all classes subclass > SQLObject, but not if they subclass a subclass of > InheritableSQLObject. This is what I mean: > > > class zoo( SQLObject ): > name = StringCol( ) > cages =

[SQLObject] LEFTJOINOn and InheritableSQLObject weirdness

2007-06-09 Thread Daniel Nogradi
Multiple LEFTJOINOn queries seem to work if all classes subclass SQLObject, but not if they subclass a subclass of InheritableSQLObject. This is what I mean: class zoo( SQLObject ): name = StringCol( ) cages = MultipleJoin( '