Re: [sqlalchemy] Running an externally supplied SQL statement with special characters

2013-11-29 Thread Ivan Kalinin
...@zzzcomputing.comwrote: On Nov 22, 2013, at 2:08 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Nov 22, 2013, at 1:11 PM, Ivan Kalinin pupss...@gmail.com wrote: Hello there, fellow developers! We've recently run into a terrible problem. A small tool uses SQLAlchemy to execute statements read

Re: [sqlalchemy] Running an externally supplied SQL statement with special characters

2013-11-29 Thread Ivan Kalinin
...@zzzcomputing.comwrote: yes, that workaround works, but much more simply, using a backslash in text() should work as well On Nov 29, 2013, at 2:01 PM, Ivan Kalinin pupss...@gmail.com wrote: Actually, using the session.connection().execute did help! Also, I think there is an option

[sqlalchemy] Running an externally supplied SQL statement with special characters

2013-11-22 Thread Ivan Kalinin
Hello there, fellow developers! We've recently run into a terrible problem. A small tool uses SQLAlchemy to execute statements read from a text file against a database. The trouble comes when that pre-defined statement has a colon symbol in the field value of a, say, INSERT statement. Like

[sqlalchemy] Re: pymssql and uuid.UUID convertion

2012-11-23 Thread Ivan Kalinin
Well, anyone? On Thursday, November 22, 2012 1:42:07 AM UTC+4, Ivan Kalinin wrote: Hellow, fellow developers! I have run into and issue trying to use SQLAlchemy (0.7.4) and recent pymssql (2.0.0). Precisely, pymssql can not handle uuid.UUID objects as parameters (see related post

Re: [sqlalchemy] pymssql and uuid.UUID convertion

2012-11-23 Thread Ivan Kalinin
: On Nov 21, 2012, at 4:42 PM, Ivan Kalinin wrote: Hellow, fellow developers! I have run into and issue trying to use SQLAlchemy (0.7.4) and recent pymssql (2.0.0). Precisely, pymssql can not handle uuid.UUID objects as parameters (see related post on their ML herehttps

Re: [sqlalchemy] pymssql and uuid.UUID convertion

2012-11-23 Thread Ivan Kalinin
://docs.sqlalchemy.org/en/rel_0_8/core/types.html#sqlalchemy.types.UserDefinedType). SQLAlchemy's type system is fully extensible here. On Nov 23, 2012, at 2:41 PM, Ivan Kalinin wrote: Thanks for the reply! However, I see that MSSQL dialect contains a UNIQUEIDENTIFIER type that is to represent similarly named

Re: [sqlalchemy] pymssql and uuid.UUID convertion

2012-11-23 Thread Ivan Kalinin
/pyodbc.py?at=default#cl-120. On Nov 23, 2012, at 5:45 PM, Ivan Kalinin wrote: Wait. I mean that SA _already_ has implemented UNIQUEIDENTIFIER over here: https://bitbucket.org/sqlalchemy/sqlalchemy/src/0c8e0b613da3b2bf6e965e1e5c15b6b3e540368a/lib/sqlalchemy/dialects/mssql/base.py?at=default

[sqlalchemy] pymssql and uuid.UUID convertion

2012-11-21 Thread Ivan Kalinin
to writing these dialects. Best regards, Ivan Kalinin. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/C7_dDgzrWg4J. To post to this group, send email