RE: [sqlalchemy] Kerberos authentication with sybase

2010-06-15 Thread Cserna, Zsolt
I think it you want to make it flexible there should be a dictionary or a two-dimensional list specifying which options should be set, so in case of kerberos it would have two elements. Unfortunatelly these options cannot be specified for the connect() function of python-sybase. the

RE: [sqlalchemy] Kerberos authentication with sybase

2010-06-14 Thread Cserna, Zsolt
To: sqlalchemy@googlegroups.com Subject: Re: [sqlalchemy] Kerberos authentication with sybase On Jun 11, 2010, at 4:50 AM, Cserna, Zsolt wrote: The DBAPI is python-sybase (http://python-sybase.sourceforge.net/). Here is an example: conn = Sybase.connect(hostname

RE: [sqlalchemy] Kerberos authentication with sybase

2010-06-11 Thread Cserna, Zsolt
. On Jun 10, 2010, at 9:10 AM, Cserna, Zsolt wrote: Hi all, Is there any plan to add kerberos authentication to the sybase engine in sqlalchemy? I've implemented it but it's using the creator parameter of the create_engine function, which is ok, but in certain

RE: [sqlalchemy] Sybase reports conversion from datatype 'CHAR' to 'INT' is not allowed. when using string instead of int for filterby

2010-06-10 Thread Cserna, Zsolt
SQLAlchemy doesn't do type coercion out of the box. Some DBAPIs do, which is why you may have not noticed this issue on other platforms. You can build that functionality yourself using TypeDecorator:

[sqlalchemy] Kerberos authentication with sybase

2010-06-10 Thread Cserna, Zsolt
Hi all, Is there any plan to add kerberos authentication to the sybase engine in sqlalchemy? I've implemented it but it's using the creator parameter of the create_engine function, which is ok, but in certain circumstances when the application using sqlalchemy uses configuration from a text

[sqlalchemy] Sybase reports conversion from datatype 'CHAR' to 'INT' is not allowed. when using string instead of int for filterby

2010-06-09 Thread Cserna, Zsolt
Hi all, We're trying to use sybase dialect in sqlalchemy, but it creates invalid select parameters when we are trying to use a python-string (or unicode object) variable to specify a sql-int variable. That problem occurs when we use pylons web framework with formalchemy with sqlalchem+sybase