[sqlalchemy] [Q] SQLSoup and pymssql from Linux

2012-10-05 Thread Ladislav Lenart
Hello. I try to access a Microsoft SQL database from Linux (Debian testing): from sqlalchemy.ext.sqlsoup import SqlSoup conn_string = 'mssql+pymssql://user:pass@freetds_name' db = SqlSoup(conn_string) v = db.some_table.first() print v freetds_name is the section name from

Re: [sqlalchemy] attribute for the size of a LargeBinary

2012-10-05 Thread Michael Bayer
On Oct 5, 2012, at 10:26 AM, Andre wrote: I would like to make this more efficient by adding an attribute to the DocumentBase class above, which simply does a SQL query to get the size of the file_object at the DB level, thinking that this will not require to load the binary object into

Re: [sqlalchemy] [Q] SQLSoup and pymssql from Linux

2012-10-05 Thread lenartlad
Hello. I dont have easy access to pymssql here so can you fully define what fails means ? stack trace ? I don't have access to my development environment during the weekend, so I cannot provide you with a stacktrace, but I try to better describe the issue: def

Re: [sqlalchemy] attribute for the size of a LargeBinary

2012-10-05 Thread Andre Charbonneau
On 12-10-05 11:27 AM, Michael Bayer wrote: On Oct 5, 2012, at 10:26 AM, Andre wrote: I would like to make this more efficient by adding an attribute to the DocumentBase class above, which simply does a SQL query to get the size of the file_object at the DB level, thinking that this

Re: [sqlalchemy] [Q] SQLSoup and pymssql from Linux

2012-10-05 Thread Michael Bayer
what I can do for the moment is this patch, if you want to try it: diff -r 17cab4ad55d5 lib/sqlalchemy/dialects/mssql/pymssql.py --- a/lib/sqlalchemy/dialects/mssql/pymssql.py Thu Oct 04 18:26:55 2012 -0400 +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py Fri Oct 05 18:46:01 2012 -0400 @@ -80,7