Sign inSign up

toast38coza/python-mssql

By toast38coza

•Updated over 9 years ago

A Python container capable of talking to Ms SQL

Image
0

4.0K

toast38coza/python-mssql repository overview

⁠python3.6-mssql

A Python 3.6 Docker image which is capable of talking to MS SQL

This sets up a Python container with freetds, pyodbc and django-pyodbc-azure

See docker-compose.text.yml + the example Django project for an example using this with Django.

⁠Notes:

⁠Example Django settings:
DATABASES = {
    'default': {
        'ENGINE': "sql_server.pyodbc",
        'HOST': "db",
        'PORT':'1433',
        'USER': "sa",
        'PASSWORD': os.environ.get('SA_PASSWORD'),
        'NAME': os.environ.get('DB_NAME'),
        # 'AUTOCOMMIT': True,
        'OPTIONS': {
            "driver": "FreeTDS",
            "host_is_server": True,
            "unicode_results": True,
            "extra_params": "tds_version=8.0",
        }
    }
}
⁠Example pyodbc connection string:
db_name = os.environ.get('DB_NAME')
pwd = os.environ.get('SA_PASSWORD')
connection_string = "driver=FreeTDS;server=db;PORT=1433 database=master;UID=sa;PWD={};TDS_Version=8.0;".format(pwd)

Tag summary

Content type

Image

Digest

Size

280.5 MB

Last updated

over 9 years ago

docker pull toast38coza/python-mssql