FROM python:latest
WORKDIR /app

RUN apt-get update \
    && apt-get install -y sqlite3 \
    && apt-get install -y git

COPY requirements.txt .

RUN pip install --upgrade --no-cache-dir pip \
    && pip install --upgrade --no-cache-dir -r requirements.txt

RUN git clone https://github.com/lerocha/chinook-database.git \
    && cp chinook-database/ChinookDatabase/DataSources/Chinook_Sqlite.sql .

RUN sqlite3 -init Chinook_Sqlite.sql Chinook.db ""

COPY script.py .
RUN --mount=type=secret,id=OPENAI_API_KEY,mode=0444,required=true

CMD ["streamlit", "run", "script.py", "--server.port", "7860"]