cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Python ASE & IQ drivers

pythondev
Explorer
0 Likes
2,565

Hello,

I would like to execute queries in Python 2 (and 3 if possible) to ASE and IQ Sybase servers.

What are the most performant implementations in Python 2/3 ?

Best regards,

View Entire Topic
pythondev
Explorer
0 Likes

Also, I've tried using SQL Alchemy to execute queries seemsly on IQ and ASE but it works only for IQ:

import sqlalchemy
from sqlalchemy.dialects import registry

registry.register('sqlalchemy_sqlany', 'sqlalchemy_sqlany.base', 'SQLAnyDialect')
engine = sqlalchemy.create_engine("sqlalchemy_sqlany://{}:{}@{}:{}".format(usr, pwd, host, port), echo=True)
engine.connect()
metadata = sqlalchemy.MetaData()
table = sqlalchemy.Table("MY_TABLE", metadata, autoload=True, autoload_with=engine)
result = sqlalchemy.select([table]).where(table.columns.MY_COLUMN == "MY_VALUE")