denisenkom / pytds

Python DBAPI driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation
MIT License
191 stars 53 forks source link

Integration with SQLAlchemy? #58

Closed dellintosh closed 6 years ago

dellintosh commented 8 years ago

Any plans to add a dialect to tie in with SQLAlchemy?

http://docs.sqlalchemy.org/en/latest/dialects/index.html

denisenkom commented 8 years ago

Not at the moment, but there may be in future. Thanks for registering this issue.

tpow commented 7 years ago

It looks like someone already did the work to build a dialect:

https://github.com/m32/sqlalchemy-tds

I was able to use this and connect using code like this:

eng = sqlalchemy.create_engine('mssql+pytds://' + username + ':' + password + '@' + dbserver + '/' + dbname)

sylvainr commented 7 years ago

Just to confirm that sqlalchemy-tds works as expected.

gabomgp commented 7 years ago

I'm new to Python and I don't know how to use sqlalchemy with pytds passing table valued parameters...¿someone knows a example doing it? ¿can help me pointing that sample, please?