[sqlalchemy] Re: SA and IBM DB2

2011-07-06 Thread Bastian
Hi Luca, On Jun 29, 12:43 pm, Luca Lesinigo l...@lesinigo.it wrote: Hello there. I'd like to use SQLalchemy with an existing db2 database (I can already access it with plain SQL using pyODBC from a python-2.6/ win32 system). You could also try to use http://pypi.python.org/pypi/JayDeBeApi/

[sqlalchemy] Does orm.synonym's comparator_factory work?

2011-07-06 Thread Arturo Sevilla
Hi, I have a mapping between a table row and a python field, for which I have a synonym. I've read the documentation and it says: Each of column_property(), composite(), relationship(), and comparable_property() accept an argument called comparator_factory. For which I assume that synonym()

[sqlalchemy] Re: EOFError while querying

2011-07-06 Thread rajasekhar911
Hi Is there a way that, i can validate the values in BLOB column (the binary data) maps to a valid pickle string. if I dump the data from the row to a file, will it be of any use? select results into dumpfile '/tmp/blob_data.txt' from task_results where task_id=1; is there any utility that i

[sqlalchemy] SQLTap - Profiling and Introspection for SQLAlchemy applications

2011-07-06 Thread Alan Shreve
Hello SQLalchemy users, I just wanted to share my latest project for profiling sqlalchemy applications. It's an extremely simple library that hooks in via sqlalchemy's new eventing system to give you really easy introspection, profiling and reporting. Docs: https://sqltap.you-compete.com/

[sqlalchemy] read event for an attribute

2011-07-06 Thread Burak Arslan
Hello, I've implemented a 'read' event for attributes, similar to 'set'. It's called 'read' and not 'get' because it's fired only when data is fetched from the database. The implementation looks a bit crude to me, as I'm not so familiar with sqlalchemy internals. (but this exercise did teach a

Re: [sqlalchemy] Re: ImportError: DLL load failed: The specified module could not be found

2011-07-06 Thread Michael Bayer
This is a cx_Oracle installation issue and you should email their list at https://lists.sourceforge.net/lists/listinfo/cx-oracle-users . On Jul 6, 2011, at 4:22 AM, Upul Iroshan Abayagunawardhana wrote: I found in the cx_oracle.py dialect file line 537 is as follows def dbapi(cls):

[sqlalchemy] sqlalchemy 0.7.1 pgarray

2011-07-06 Thread ddarko
t = Session.query(Tests).get(1) print(t.array) t.array.append(1) Session.commit() t.array - is an int. array in postgresql This simple construction does not change the content of the list after commit, and it seems to me that it should. Of course t.array = t.array + [1] works correctly. -- You

[sqlalchemy] Re: sqlalchemy 0.7.1 pgarray

2011-07-06 Thread ddarko
psycopg2 2.4.1 python 3.2.0 -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options,

Re: [sqlalchemy] sqlalchemy 0.7.1 pgarray

2011-07-06 Thread Michael Bayer
On Jul 6, 2011, at 10:03 AM, ddarko wrote: t = Session.query(Tests).get(1) print(t.array) t.array.append(1) Session.commit() t.array - is an int. array in postgresql This simple construction does not change the content of the list after commit, and it seems to me that it should. Of

Re: [sqlalchemy] Does orm.synonym's comparator_factory work?

2011-07-06 Thread Michael Bayer
On Jul 6, 2011, at 5:47 AM, Arturo Sevilla wrote: Hi, I have a mapping between a table row and a python field, for which I have a synonym. I've read the documentation and it says: Each of column_property(), composite(), relationship(), and comparable_property() accept an argument

[sqlalchemy] Re: sqlalchemy 0.7.1 pgarray

2011-07-06 Thread ddarko
THX On Jul 6, 4:09 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 6, 2011, at 10:03 AM, ddarko wrote: t = Session.query(Tests).get(1) print(t.array) t.array.append(1) Session.commit() t.array - is an int. array in postgresql This simple construction does not change the

[sqlalchemy] Re: SA and IBM DB2

2011-07-06 Thread Christian Klinger
Hi Michael, i am intrested in writing a dialect for DB2. Is there any howto which covers what is needed to start. Do you think we should write an extension, or should this dialect in sqlalchemy itself? Thanks in advance Christian On Jun 29, 2011, at 6:43 AM, Luca Lesinigo wrote: Hello

Re: [sqlalchemy] Re: SA and IBM DB2

2011-07-06 Thread Michael Bayer
On Jul 6, 2011, at 11:19 AM, Christian Klinger wrote: Hi Michael, i am intrested in writing a dialect for DB2. Is there any howto which covers what is needed to start. Do you think we should write an extension, or should this dialect in sqlalchemy itself? first off, HOORAY, secondly,

[sqlalchemy] pymssql and decimal support

2011-07-06 Thread emmanuel CAZENAVE
Hello, I'm facing problems with mssql+pymssql: it seems that pymssql has poor decimal support. As a result there are some rounding differences between the values stored in the database, and the values I get when querying through mssql+pymssql. And I absolutely need the exacts values stored in the

Re: [sqlalchemy] pymssql and decimal support

2011-07-06 Thread Michael Bayer
On Jul 6, 2011, at 12:57 PM, emmanuel CAZENAVE wrote: Hello, I'm facing problems with mssql+pymssql: it seems that pymssql has poor decimal support. As a result there are some rounding differences between the values stored in the database, and the values I get when querying through

[sqlalchemy] setting collection backref during merge()

2011-07-06 Thread Kent
If I merge() an object with a collection property, the backref's are not set as they would be if I had assigned the collection to the object. I expected that this should occur. Is there rationale for not setting backref's or would it be possible to make this change? Thanks, Kent -- You

Re: [sqlalchemy] setting collection backref during merge()

2011-07-06 Thread Michael Bayer
A persistent object doesn't populate an unloaded backref on a forward set event. This is for efficiency so that when you do something like: for b in Session.query(B): b.a = some_a it doesn't spend time loading the bs collection of some_a, which if you had a lot of different some_a