Dockerfile

FROM python:3.11-slim

WORKDIR /app

# Install dependencies
COPY requirements.txt .
RUN pip install --no-cache-dir -r requirements.txt

# Copy application
COPY app.py .
COPY months_config.json .
COPY column_config.json .
COPY static/ static/

# Create non-root user for security
RUN useradd -m -u 1000 user

# Create persistent data directory for SQLite
RUN mkdir -p /data && chown user:user /data

USER user

# Expose port
EXPOSE 7860

# Run the application
CMD ["uvicorn", "app:app", "--host", "0.0.0.0", "--port", "7860"]