Re: [SQLObject] field alias

On Wed, Jun 14, 2006 at 06:29:40PM +0200, Fran?ois wrote: > How can I make a field alias ? There is sqlbuilder.Alias, and it's documented. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

[SQLObject] field alias

Hello, I want to have results of a query, ordered by a count() field. I've tried : >>>Catalogue._connection.sqlrepr(sqlbuilder.Select([Fournisseurs.q.id, func.Count(Fournisseurs.q.id)] ,AND(Catalogue.q.marqueID==self.id

Re: [SQLObject] patch for sqlite timeout specification

On Wed, May 31, 2006 at 03:18:38PM +0300, Dan Pascu wrote: > -opts['timeout'] = float(popKey(kw, 'timeout')) > +if using_sqlite2: > +opts['timeout'] = float(popKey(kw, 'timeout')) > +else: > +opts['timeout'] = int(float(popKey(kw,

Re: [SQLObject] unicode for varchar, blob

On Wed, Jun 14, 2006 at 04:23:58PM +0200, Ivan Horvath wrote: > yes, but i didn't find anything in postgresconnection which > handle unicode blob fields. Postgres has BYTEA - special byte array type for BLOBs; no need to guess if it is TEXT or BLOB. > i thought also that this ca

Re: [SQLObject] unicode for varchar, blob

Dear Oleg, yes, but i didn't find anything in postgresconnection which handle unicode blob fields. or did i miss something? i thought also that this cannot handle binary data. should be created another column BlobUnicodeCol, or what is your idea? Wednesday, June 14,

Re: [SQLObject] unicode for varchar, blob

On Wed, Jun 14, 2006 at 03:53:33PM +0200, Ivan Horvath wrote: > i've sent you the mysqlconnection.py couple a days ago. > a modification was done because if there is a unicode support, the > varchar, blob fields value wasn't receive as unicode I am looking into it right now. And I don't l

Re: [SQLObject] Using UNION, INTERSECT, EXCEPT set operations

On Wed, Jun 14, 2006 at 06:39:37AM -0500, Charles Duffy wrote: > I'm in a situation where I'll be wanting to dynamically construct > strings of queries combined with set operations, with explicitly defined > grouping (as in "(A UNION B) INTERSECT C" as opposed to the default > behavior "A UNION

Re: [SQLObject] odbc

On Wed, Jun 14, 2006 at 12:18:56PM +0200, Johan Van den Neste wrote: > I was wondering how hard it would be to use sqlobject with odbc. Look at mysqlconnection.py, postgresconnection.py, sqliteconnection.py - these are thre the most advanced connection classes in SQLObject. Oleg. -- Oleg

[SQLObject] Using UNION, INTERSECT, EXCEPT set operations

I'm in a situation where I'll be wanting to dynamically construct strings of queries combined with set operations, with explicitly defined grouping (as in "(A UNION B) INTERSECT C" as opposed to the default behavior "A UNION (B INTERSECT C)"). Is there support in SQLObject for this? If not, is

[SQLObject] odbc

hello, I was wondering how hard it would be to use sqlobject with odbc. I'm considering implementing the necessary code, to be able to use sqlobject. I need to access data from a FileMaker 8 database, and all I have is the "Datadirect Sequelink" ODBC driver. Any thoughts/comments would be great

Re: [SQLObject] pickling an SQLObject?

On Wed, Jun 14, 2006 at 10:25:00AM +0200, sophana wrote: > It would be nice to have a method that works in all protocols based on > getstate - setstate only. > But I don't think it is possible. I think it's possible - __setstate__() should not call get(), instead it should call _init() and put

Re: [SQLObject] pickling an SQLObject?

Oleg Broytmann wrote: On Mon, Jun 12, 2006 at 11:50:49AM +0200, sophana wrote: class MySqlObject(SQLObject): def __getstate__(self): return self.id def __setstate__(self,id): pass def __new__(cls, *args, **kw): if len(args) == 1: return cls.