Re: [SQLObject] Complex system problem

2008-02-19 Thread Oleg Broytmann
On Tue, Feb 19, 2008 at 12:57:57PM -0800, Guillaume wrote: > Would there be a way around making an algorithm that retrieve every field > in the many to many relationship for each item in the "primary" table > without using a firm table name for the many to many table. sqlbuilder.Select() Oleg.

[SQLObject] Complex system problem

2008-02-19 Thread Guillaume
I have a search to do over different tables. One of this tables is in a many to many relationship with another table. SqlObject handle this many to many relation with a ForeignKey. I don't wan't to use the generated middle table directly, since SqlObject can handle it differently in different versi

Re: [SQLObject] SQLObjectNotFound when creating a new row instance

2008-02-19 Thread Oleg Broytmann
On Tue, Feb 19, 2008 at 06:38:26PM +0100, Sophana wrote: > Could you please explain the process of creating a new row instance? SQLObject.__init__() calls ._create() that calls .set() with sqlmeta._creating set; .set() collects the initializations values in ._SO_createValues dictionary; ._creat

Re: [SQLObject] SQLObjectNotFound when creating a new row instance

2008-02-19 Thread Sophana
Oleg Broytmann a écrit : > On Tue, Feb 19, 2008 at 04:35:24PM +0100, Sophana wrote: > >> SQLObjectNotFound: The object StateActive by the ID 208879 does not exist >> > >IWBN to turn on debugging (db_uri="...?debug=1"), redirect stdout to > a logfile and watch the log. What is the result

Re: [SQLObject] SQLObjectNotFound when creating a new row instance

2008-02-19 Thread Oleg Broytmann
On Tue, Feb 19, 2008 at 04:35:24PM +0100, Sophana wrote: > SQLObjectNotFound: The object StateActive by the ID 208879 does not exist IWBN to turn on debugging (db_uri="...?debug=1"), redirect stdout to a logfile and watch the log. What is the result of "QueryOne result" before the exception? O

[SQLObject] SQLObjectNotFound when creating a new row instance

2008-02-19 Thread Sophana
Hi My web service is sometimes throwing a weird exception: I get an SQLObjectNotFound exception during a new row instance creation. This does happen not very often (once a week) but it is quite regular. Does someone has an idea why? Thanks backtrace: ... r=StateActive(user=user,spot=spot,curSta

Re: [SQLObject] SQLObject 0.10.0b2

2008-02-19 Thread Markus Gritsch
On 18/02/2008, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Sun, Feb 17, 2008 at 07:00:08PM +0100, Markus Gritsch wrote: > > what should one use as the omni-present parameter 'db' in various > > SQLObject 0.10 methods? In version 0.9 I used to call > > query.tablesUsed(), but this does not work