On Jun 15, 2010, at 9:13 AM, Cserna, Zsolt wrote:

> 
>>> 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 goal here is so that the options can all be embedded in 
>> the URL at least as key/value pairs.  How would the 
>> Sybase.XXX symbols be embedded ?
>> 
> 
> The biggest problem here is the serialization of those values to string and 
> de-serializing them when sqlalchemy sets them to python-sybase.
> It could be ok if we would know the type of the property but as far as I see 
> it cannot be introspected from the sybase library.
> 
> We could have an algorithm serializing/deserializing the value:
> - if it's starting with "CS_", we use it as the name of the variable in the 
> Sybase module 
> - if we can convert it to an integer we use it as an integer
> - otherwise we use it as string specified
> 
> Based on the above, my kerberos connection url would be the following 
> (missing username+pw in this case):
> 
> sybase+pysybase://hostname/?CS_SEC_NETWORKAUTH=CS_TRUE&CS_SEC_SERVERPRINCIPAL=sybase/some_host
> 
> It's just an idea, I don't know how it could fit into the design of 
> sqlalchemy.


we can do whatever we want, this would all be local to the python-sybase 
dialect.  The above is sort of like what I was thinking.




> 
> Zsolt
> 
> 
> --------------------------------------------------------------------------
> NOTICE: If received in error, please destroy, and notify sender. Sender does 
> not intend to waive confidentiality or privilege. Use of this email is 
> prohibited when received in error. We may monitor and store emails to the 
> extent permitted by applicable law.
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to 
> [email protected].
> For more options, visit this group at 
> http://groups.google.com/group/sqlalchemy?hl=en.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to