Re: [SQLObject] sqlite connection and user-defined aggregate

2006-10-11 Thread jt
Hello, Sorry I was off for some days. Oddly, I disregarded the connection string: I always use the constructor with SQLite. But this is great news: I can use the pure trunk version again :-) On 10/10/06, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > Hello! > > On Fri, Oct 06, 2006 at 07:39:27PM +04

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-10-10 Thread Oleg Broytmann
Hello! On Fri, Oct 06, 2006 at 07:39:27PM +0400, Oleg Broytmann wrote: > if 'factory' in kw: > factory = popKey(kw, 'factory') > if isinstance(factory, basestring): > factory = globals()[factory] > if not callable(fact

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-10-06 Thread Oleg Broytmann
Hello. On Thu, Jun 22, 2006 at 11:08:34AM +0200, jt wrote: > I also tried the factory argument of pysqlite connection (could you > add it to the trunk?): > +if 'factory' in kw: > +opts['factory'] = popKey(kw, 'factory')(sqlite) This supposes that one always create

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-06-22 Thread Oleg Broytmann
Hi! On Thu, Jun 22, 2006 at 11:08:34AM +0200, jt wrote: > +if 'factory' in kw: > +opts['factory'] = popKey(kw, 'factory')(sqlite) Thank you. I'll look at it. I am very busy these days and cannot answer even simplest questions. There is a lot of questions and patches

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-06-22 Thread jt
Thanks Oleg. Dirty hack indeed :-) Looking at sqliteconnection.py and dbconnection.py I can see that what I want should work out of the box since I do not use multiple threads: getConnection should return the same sqliteconnection if you have not released it. I was also mislead because I called g

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-06-19 Thread Oleg Broytmann
On Sat, Jun 17, 2006 at 09:30:57PM +0200, jt wrote: > Is there another way to assure I keep the same connection? > Should I patch SQLObject for myself? I have had a similar problem for RLIKE because RLIKE requires installing a user-defined regexp function. Look at test_select.py, test_sqlbuilde

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-06-17 Thread jt
> The problem is the aggregate function belongs to the "pysqlite connection" > and that this connection is not reused when creating the view, or doing > other DML with sqlobject. So it always ends with a " > pysqlite2.dbapi2.OperationalError: no such function: > group_concat". Please correct me if

Re: [SQLObject] sqlite connection and user-defined aggregate

2006-06-17 Thread jt
> The problem is the aggregate function belongs to the "pysqlite connection" > and that this connection is not reused when creating the view, or doing > other DML with sqlobject. So it always ends with a " > pysqlite2.dbapi2.OperationalError: no such function: > group_concat". Please correct me if

[SQLObject] sqlite connection and user-defined aggregate

2006-06-17 Thread jt
Hello,I have a problem using sqlite user-defined aggregate with sqlobject 0.7.1b1. The problem also happens with last revision from the trunk but it does not happen with r1457.In short, I want to use the "group_concat" aggregate (from MySQL) in a view. I thus have to first create the aggregate with