FROM python:3.12-slim

WORKDIR /app

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

COPY . .

# Create directory for sqlite db
RUN mkdir -p /app/data

# Environment variable for database to persist (if mounting a volume)
# ENV SQLALCHEMY_DATABASE_URL="sqlite:///./data/sql_app.db"

CMD ["uvicorn", "app.main:app", "--host", "0.0.0.0", "--port", "7860"]