Pytds - Microsoft SQL Server database adapter for Python¶
Pytds is the top to bottom pure Python TDS implementation, that means cross-platform, and no dependency on ADO or FreeTDS. It supports large parameters (>4000 characters), MARS, timezones, new date types (datetime2, date, time, datetimeoffset). Even though it is implemented in Python performance is comparable to ADO and FreeTDS bindings.
It also supports Python 3.
Connection to Mirrored Servers¶
When MSSQL server is setup with mirroring you should connect to it using two parameters of
pytds.connect(), one parameter is
this should be a main server and parameter
failover_partner should be a mirror server.
See also MSDN article.
Table Valued Parameters¶
Here is example of using TVP:
with conn.cursor() as cur: cur.execute('CREATE TYPE dbo.CategoryTableType AS TABLE ( CategoryID int, CategoryName nvarchar(50) )') conn.commit() tvp = pytds.TableValuedParam(type_name='dbo.CategoryTableType', rows=rows_gen()) cur.execute('SELECT * FROM %s', (tvp,))
To run tests you need to have tox installed. Also you would want to have different versions of Python, you can use pyenv to install those.
At a minimun you should set HOST environment variable to point to your SQL server, e.g.:
it could also specify SQL server named instance, e.g.:
By default tests will use SQL server integrated authentication using user sa with password sa and database test. You can specify different user name, password, database with SQLUSER, SQLPASSWORD, DATABASE environment variables.
To enable testing NTLM authentication you should specify NTLM_USER and NTLM_PASSWORD environment variables.
Once environment variables are setup you can run tests by running command:
Test configuration stored in tox.ini file at the root of the repository.