[sqlalchemy] Re: pymssql and decimal support

2011-07-07 Thread Emmanuel Cazenave
All right, I'm going to try pyodbc + freetds. Thank you very much for your response. On 6 juil, 19:39, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 6, 2011, at 12:57 PM, emmanuelCAZENAVEwrote: Hello, I'm facing problems with mssql+pymssql: it seems that pymssql has poor decimal

[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

[sqlalchemy] Re: session.execute(sql_statement) does not flush the session in a autoflush=True session ?

2010-11-29 Thread Emmanuel Cazenave
statements as much as it was apparently surprising to you that it did not. On Nov 26, 2010, at 1:49 PM, Emmanuel Cazenave wrote: Hi, In a session which has some dirty objects, doing session.execute(sql_statement) doesn't not flush the dirty objects to the database before executing

[sqlalchemy] session.execute(sql_statement) does not flush the session in a autoflush=True session ?

2010-11-26 Thread Emmanuel Cazenave
Hi, In a session which has some dirty objects, doing session.execute(sql_statement) doesn't not flush the dirty objects to the database before executing the sql_statement query. The session was initialized with autoflush=True. Is it the expected behaviour ? Is it a bug ? Thanks -- You