FROM python:3.11.4

COPY requirements.txt /product_ms/

COPY app /product_ms/

WORKDIR /product_ms

RUN pip install --no-cache-dir -r requirements.txt


RUN apt-get update && apt-get install -y \
    unixodbc \
    unixodbc-dev \
    freetds-dev \
    tdsodbc \
    && rm -rf /var/lib/apt/lists/*

# Set environment variables for ODBC configuration if needed
ENV ODBCINI=/etc/odbc.ini
ENV ODBCSYSINI=/etc

CMD ["python", "index.py"]