on ‎2019 Mar 18 3:52 PM
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,
Request clarification before answering.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.