FROM python:3.12.2

# Set workdir
WORKDIR /app

# Copy files
COPY requirements.txt requirements.txt
COPY templates/ /app/templates/
COPY static/ /app/static
COPY merge_sql_nosql.py merge_sql_nosql.py
COPY app.py app.py

# Install system dependencies + Microsoft ODBC Driver 17 (modern method)
RUN apt-get update && apt-get install -y \
    curl \
    apt-transport-https \
    gnupg \
    lsb-release \
    unixodbc \
    unixodbc-dev \
    libodbc1 \
    && curl https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > /usr/share/keyrings/microsoft.gpg \
    && echo "deb [signed-by=/usr/share/keyrings/microsoft.gpg] https://packages.microsoft.com/debian/12/prod bookworm main" \
        > /etc/apt/sources.list.d/mssql-release.list \
    && apt-get update \
    && ACCEPT_EULA=Y apt-get install -y msodbcsql17 \
    && rm -rf /var/lib/apt/lists/*

# Install dependencies
RUN pip install -r requirements.txt
RUN mkdir -p /app/cache /app/uploads /app/data && chmod -R 777 /app/cache /app/uploads /app/data
RUN mkdir -p /static
RUN chmod -R 777 /app

# Expose default port for Spaces
EXPOSE 7860

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