FROM python:3.10-slim

RUN apt-get update && apt-get install -y \
    lsb-release \
    wget \
    gnupg \
    && rm -rf /var/lib/apt/lists/*

RUN echo "deb http://apt.postgresql.org/pub/repos/apt bookworm-pgdg main" > /etc/apt/sources.list.d/pgdg.list \
    && wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -

RUN apt-get update && apt-get install -y \
    libpq-dev \
    libmagic1 \
    postgresql-client-17 \
    && rm -rf /var/lib/apt/lists/*

RUN mkdir -p /app/backups && chmod 777 /app/backups

WORKDIR /app

COPY req.txt .

RUN pip install --no-cache-dir -r req.txt

COPY . .

EXPOSE 8000

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