FROM python:3.12.2

# Set workdir
WORKDIR /app

# Copy files
COPY requirements.txt requirements.txt
COPY templates/ /app/templates/
COPY static/ /app/static
COPY merge_sql_nosql.py merge_sql_nosql.py
COPY app.py app.py

# Install dependencies
RUN pip install -r requirements.txt
RUN mkdir -p /app/cache /app/uploads /app/data && chmod -R 777 /app/cache /app/uploads /app/data
RUN mkdir -p /static
RUN chmod -R 777 /app

# Expose default port for Spaces
EXPOSE 7860

CMD ["python", "app.py"]