DB API 2.0-compliant driver for SQL Server
cTDS is a full Python DB API-2.0-compliant SQL Server database library for Linux, Windows, and Mac OS X supporting both Python 2 and Python 3.
The full documentation for cTDS can be found here.
Generate documentation using the following:
make doc # Generated to ./.gh-pages
Local development and testing is supported on Linux-based systems running Docker. Docker containers are used for both running a local instance of SQL Server on Linux and creating containers for each combination of Python and FreeTDS version supported. Only Docker and GNU make are required for running tests locally on Linux or OS X systems.
If desired, local development can be done by installing ctds against the system versions of FreeTDS and Python. Additionally there is a virtualenv target which will download and compile a recent version of FreeTDS and then install ctds into a virtualenv using the local version of FreeTDS.
# Install as a "develop" egg pip install -e . # Install tests. pip install -e .[tests] # Run tests (requires SQL Server running) python setup.py test
Development and testing will require an instance of SQL Server on Linux running for validation. A script is provided to start a Docker container running the database and create the login used by the tests.
# Start a docker-based SQL Server instance. make start-sqlserver # Run tests as needed ... # Stop the docker-base SQL Server instance. make stop-sqlserver
Testing is designed to be relatively seamless using Docker containers and SQL Server on Linux. All test targets will ensure a running database instance docker container exists and is accessible prior to running.
# Python X.Y & FreeTDS Z.ZZ.ZZ make test_X.Y_Z.ZZ.ZZ