felipederodrigues/python37withpyodbc repository overview

FROM felipederodrigues/python37withpyodbc:v1

COPY . /app
WORKDIR /app

RUN pip install --upgrade pip
RUN python -m pip install -r requirements.txt

ENTRYPOINT [ "python", "Main.py" ]

docker build -t the-name-of-your-image:latest .

docker run the-name-of-your-image:latest

docker run \
    -e SQL_SERVER_SERVER="hostname.your.network" \
    -e SQL_SERVER_DATABASE="YourDatabaseName" \
    -e SQL_SERVER_USERNAME="YourDatabaseUsername" \
    -e SQL_SERVER_PASSWORD="YourDatabasePassword" \
    the-name-of-your-image:latest

@staticmethod
def connect_db():
    """        
    Parameters
    ----------
    """

    print("Conecting to database ...")
    server = os.environ['SQL_SERVER_SERVER']
    database = os.environ['SQL_SERVER_DATABASE']
    username = os.environ['SQL_SERVER_USERNAME']
    password = os.environ['SQL_SERVER_PASSWORD']
    return db.DBConnection(server, database, username, password)

root@84e7f4ffff9e:/# python --version
Python 3.7.4
root@84e7f4ffff9e:/# odbcinst -j
unixODBC 2.3.4
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
root@84e7f4ffff9e:/# uname -r
4.9.125-linuxkit
root@84e7f4ffff9e:/# pip --version
pip 19.2.3 from /usr/local/lib/python3.7/site-packages/pip (python 3.7)