Re: [sqlalchemy] Automatic server->client change propagation?

2010-10-09 Thread Michael Bayer
On Oct 9, 2010, at 3:14 PM, Wolfgang Keller wrote: > Hello, > > are there any plans to implement a functionality for SQLAlchemy, that > automatically propagates changes of database contents from the server to > all clients? For those databases that provide the required features > (e.g. notificat

[sqlalchemy] Automatic server->client change propagation?

2010-10-09 Thread Wolfgang Keller
Hello, are there any plans to implement a functionality for SQLAlchemy, that automatically propagates changes of database contents from the server to all clients? For those databases that provide the required features (e.g. notifications in PostgreSQL, events in Firebird, maybe others as well)? S

[sqlalchemy] Re: Two questions regarding unions.

2010-10-09 Thread Berteun
On 9 okt, 17:39, Michael Bayer wrote: > On Oct 9, 2010, at 7:02 AM, Berteun wrote: > I will start off by saying that the labeling applied to the NamedTuple > returned by Query was not originally intended to be a general purpose method > of targeting columns in the result.   That approach doesn't

Re: [sqlalchemy] Re: TypeError: an integer is required

2010-10-09 Thread Michael Bayer
On Oct 9, 2010, at 10:11 AM, M3nt0r3 wrote: > I found the problem. > in my sqlite test db i had a boolean field empty and the fetch failed > with that error. > > TypeError: an integer is required > > i don understand why with SA installed from pypi ( both 0.6.3 and > 0.6.4 ) it worked and wit

Re: [sqlalchemy] Two questions regarding unions.

2010-10-09 Thread Michael Bayer
On Oct 9, 2010, at 7:02 AM, Berteun wrote: > Hello, > > I've started using SQLAlchemy recently, and am using Python 2.6 and > SQLAlchemy 0.6.4. > > First of all: I'm unable to figure out how I can specify the names of > the results of a union, if I have this example: > > from sqlalchemy import

[sqlalchemy] Re: TypeError: an integer is required

2010-10-09 Thread M3nt0r3
I found the problem. in my sqlite test db i had a boolean field empty and the fetch failed with that error. TypeError: an integer is required i don understand why with SA installed from pypi ( both 0.6.3 and 0.6.4 ) it worked and with the 0.6.3 installed with deb no. sorry to all and thanks M

[sqlalchemy] Two questions regarding unions.

2010-10-09 Thread Berteun
Hello, I've started using SQLAlchemy recently, and am using Python 2.6 and SQLAlchemy 0.6.4. First of all: I'm unable to figure out how I can specify the names of the results of a union, if I have this example: from sqlalchemy import Column, Integer, String, create_engine from sqlalchemy.ext.dec

[sqlalchemy] fulltext index on mysql and sqlite

2010-10-09 Thread golnaz nilieh
Hi, I want to create a table with fulltext index using sqlalchemy. My database type is sqlite, according to this thread in the mailing list: http://www.mail-archive.com/sqlalchemy@googlegroups.com/msg12732.html I should put " sqlite_using='fts3' " at the end of my table declaration. Does the above