FROM python:3.9

WORKDIR /code

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

COPY . .

# ✅ Make sure /data folder exists and is writable
RUN mkdir -p /data && chmod 777 /data

# ✅ Set environment variable so SQLite DB uses /data/expenses.db
ENV DB_PATH=/data/expenses.db

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