Re: [SQLObject] quirk, bug, or what?

2006-06-27 Thread Luke Opperman
Apologies, didn't see that you mentioned the SQLObject version. Anyways, tested with r1675 and same successful result as below. Quoting Luke Opperman <[EMAIL PROTECTED]>: > Going to need to know what that unhelpful exception message was, what version > of SQLObject, database, etc. Threw your cod

Re: [SQLObject] quirk, bug, or what?

2006-06-27 Thread Luke Opperman
Going to need to know what that unhelpful exception message was, what version of SQLObject, database, etc. Threw your code into a test file, using svn SQLObject, sqlite and postgres, and it works fine: [EMAIL PROTECTED]:~/code $ python2.4 -i test1.py >>> me >>> me.memberJID >>> - Luke Quoting

Re: [SQLObject] SQLObject using SQLite and Multithreading

2006-06-27 Thread Alex Le Dain
David Creemer wrote: > FYI, As of SQLite 3.3.1, some of the threading restrictions on > database connection sharing have been relaxed. I have not yet tried > it with SQLObject, but it looks like threaded connection pooling > might now work. See: > > http://www.sqlite.org/cvstrac/wiki?p=Multi

[SQLObject] quirk, bug, or what?

2006-06-27 Thread Matthew Anderson
I've just had the frustrating experience of tracking down the cause of a random, unexpected exception that was being thrown. This doesn't work (and blows up with an unhelpful exception message): class JID(SQLObject): node = StringCol() class GroupMember(SQLObject): fullname

[SQLObject] SQLBuilder

2006-06-27 Thread Lutz Steinborn
Hello, I need a litle bit of advice how to use SQLBuilder. First question: has anybody examples or documentation about SQLBuilder ? At the moment I'm using this way to get the data: res=conn.queryAll("select fa.name as fa_name, fa.id as fa_id, fa.catalog_name as fa_catalog_name, \ ca.name, ca.

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Michael Gauckler
Luke Opperman metathusalan.com> writes: > > Forgot to copy the list before, gist was use SQL*Join instead, so that it uses > a SelectResults instance. That's also the answer here: you can then use > .count, .filter, .sum, etc on the join property. > > j.transactions.count() > Thank you, this

Re: [SQLObject] Reuducing the number of SQL Queries for MultipleJoins

2006-06-27 Thread Michael Gauckler
Forwarded Message From: Luke Opperman <[EMAIL PROTECTED]> To: Michael Gauckler <[EMAIL PROTECTED]> Subject: Re: [SQLObject] Reuducing the number of SQL Queries for MultipleJoins Date: Mon, 26 Jun 2006 19:14:02 -0500 I haven't looked closely at it, and it seems your debug sql stat

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Luke Opperman
Forgot to copy the list before, gist was use SQL*Join instead, so that it uses a SelectResults instance. That's also the answer here: you can then use .count, .filter, .sum, etc on the join property. j.transactions.count() Quoting Michael Gauckler <[EMAIL PROTECTED]>: > Hi, > > thank your for t

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Michael Gauckler
> have I missed something ? > I've not seen the reply on the list. The reply went to my private address, see below. Forwarded Message From: Luke Opperman <[EMAIL PROTECTED]> To: Michael Gauckler <[EMAIL PROTECTED]> Subject: Re: [SQLObject] Reuducing the number of SQL Queries for

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Lutz Steinborn
Hello, On Tue, 27 Jun 2006 06:39:27 + (UTC) Michael Gauckler <[EMAIL PROTECTED]> wrote: > Hi, > > thank your for the reply to me previous posting. Using SQLMultipleJoin > (instead of MultipleJoin) speeds things up dramatically. have I missed something ? I've not seen the reply on the list.