#download the docker image similar to aws-lambda instance

$ sudo docker run -it --rm --entrypoint bash -e ODBCINI=/var/task -e ODBCSYSINI=/var/task -v "$PWD":/var/task lambci/lambda:build-python3.6

curl ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.5.tar.gz -O

tar xvzf unixODBC-2.3.5.tar.gz

cd unixODBC-2.3.5

./configure --sysconfdir=/var/task --disable-gui --disable-drivers --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE --prefix=/home

make install

cd ..

mv /home/* .

mv unixODBC-2.3.5 unixODBC-2.3.5.tar.gz /tmp/

curl https://packages.microsoft.com/config/rhel/6/prod.repo > /etc/yum.repos.d/mssql-release.repo

yum install e2fsprogs.x86_64 0:1.43.5-2.43.amzn1 fuse-libs.x86_64 0:2.9.4-1.18.amzn1 libss.x86_64 0:1.43.5-2.43.amzn1

ACCEPT_EULA=Y yum install msodbcsql17 --disablerepo=amzn*

export CFLAGS="-I/var/task/include"

export LDFLAGS="-L/var/task/lib"


cd /opt

cat <<EOF > odbcinst.ini
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/var/task/msodbcsql/lib64/libmsodbcsql-17.3.so.1.1
UsageCount=1
EOF


cat <<EOF > odbc.ini
[ODBC Driver 17 for SQL Server]
Driver = ODBC Driver 17 for SQL Server
Description = My ODBC Driver 17 for SQL Server
Trace = No
EOF

yum install python36-devel
yum install boost-devel
yum install unixODBC-devel

pip install pybind11

pip install pybind11 -t .

pip install turbodbc -t .

pip install sqlalchemy -t
pip install sqlalchemy-turbodbc -t .

zip -r9 ../<name>.zip