siax/python_sqlserver_connection repository overview

# mssql-python-pyodbc
# Python runtime with pyodbc to connect to SQL Server
# FROM ubuntu:16.04
FROM mileiq/ubuntu16-python3-mssql-kafka:1.0

# install necessary locales
RUN apt-get update && apt-get install -y locales \
    && echo "en_US.UTF-8 UTF-8" > /etc/locale.gen \
    && locale-gen
#RUN pip3 install --upgrade pip3
RUN pip install --upgrade pip
#RUN pip install pylint

# install Pandas and NumPy
RUN pip install pandas
RUN pip install NumPy

# install SQL Server Python SQL Server connector module - pyodbc
RUN pip install pyodbc

#install MySQL Controller and driver
RUN pip install pymysql SQLAlchemy

# Install library to convert XML to Dictionary
RUN pip install xmltodict

# install additional utilities
RUN apt-get update && apt-get install gettext nano vim -y