ctds 1.2.3

DB API 2.0-compliant Linux driver for SQL Server

cTDS is a full Python DB API-2.0-compliant SQL Server database library for Linux and Mac OS X supporting both Python 2 and Python 3.

Features

• Supports Microsoft SQL Server 2008 and up.

• Complete DB API-2.0 support.

• Python 2.6, Python 2.7, Python 3.3, Python 3.4, and Python 3.5 support.

• Bulk insert (bcp) support.

• Written entirely in C.

Documentation

The full documentation for cTDS can be found here.

Generate documentation using the following:

make doc
# Generated to build/docs/html

Development

To setup a development environment, some system packages are required. On Debian systems these can be installed using:

make setup

This will also install the supported Python versions for testing.

Testing

cTDS tests require an actual SQL Server instance to run. SQL Server Express is a free, readily available variant should a paid version not be available. The included test-setup.sql script will create the necessary database, login, etc. required for running the tests.

Additionally, the hostname for the SQL Server instance to use for the tests must be configured in the ctds/tests/database.ini configuration file.

To run the tests against the default version of Python and FreeTDS, use:

make test

To run the tests against an arbitrary version of Python and FreeTDS:

make test_X.Y_Z.ZZ.ZZ

To run tests against all versions of Python and FreeTDS:

make check