FROM python:3.11-slim

WORKDIR /app

# Install dependencies
RUN pip install --no-cache-dir flask PyMySQL psycopg2-binary

# Copy the SQL executor script
COPY scripts/sql-query-executor.py /app/app.py

# Expose port
EXPOSE 4000

# Health check
HEALTHCHECK --interval=10s --timeout=5s --retries=5 \
  CMD python -c "import urllib.request; urllib.request.urlopen('http://localhost:4000/health').read()"

# Run the app
CMD ["python", "app.py"]