FROM python:3.12-slim

# Set working directory
WORKDIR /app

# Install dependencies first (cached layer)
COPY requirements.txt .
RUN pip install --no-cache-dir -r requirements.txt

# Copy application files
COPY . .

# Create data directory for SQLite database
RUN mkdir -p /app/data

# Set environment variables
ENV FLASK_APP=app.py
ENV FLASK_ENV=production
ENV DB_PATH=/app/data/python108.db
ENV PORT=5000

# Expose port
EXPOSE 5000

# Run with gunicorn in production, fallback to flask dev server
CMD ["python", "app.py"]