FROM aisiuk/inspect-tool-support

RUN mkdir -p /workspace
WORKDIR /workspace

RUN apt-get update && \
    apt-get install -y sqlite3 && \
    apt-get clean && \
    rm -rf /var/lib/apt/lists/*

RUN mkdir -p /data
RUN sqlite3 /data/coffee_shop.db

RUN mkdir -p /utils
COPY eval_data/customers.csv /utils/customers.csv
COPY eval_data/inventory.csv /utils/inventory.csv
COPY eval_data/order_items.csv /utils/order_items.csv
COPY eval_data/orders.csv /utils/orders.csv
COPY eval_data/products.csv /utils/products.csv
COPY eval_data/average_sales.csv /utils/average_sales.csv
COPY eval_data/short_stock.csv /utils/short_stock.csv


RUN pip install pandas
