FROM python:3.10.11

# Set the working directory in the container
WORKDIR /code

# Install ODBC drivers and development files
RUN apt-get update && apt-get install -y \
    unixodbc \
    unixodbc-dev \
    libsqlite3-dev \
    build-essential \
    && rm -rf /var/lib/apt/lists/*

# Copy the current directory contents into the container at /code
COPY . .

# Install Python packages
RUN pip install --no-cache-dir -r requirements.txt


# Run app.py when the container launches
CMD ["uvicorn", "app:app", "--host", "0.0.0.0", "--port", "7860"]