FROM debian:stable

# Install Node.js (version 22) + Python3 + pip
RUN apt-get update && \
    apt-get install -y curl python3 python3-pip && \
    curl -fsSL https://deb.nodesource.com/setup_22.x | bash - && \
    apt-get install -y nodejs && \
    rm -rf /var/lib/apt/lists/*

# Enable pip
RUN bash -c 'rm -f /usr/lib/python3*/EXTERNALLY-MANAGED'

# Upgrade pip and install Python dependencies
RUN python3 -m pip install boto3 pymysql

# Set working directory for Node.js app
WORKDIR /app

# Copy package.json + package-lock.json first to leverage Docker cache
COPY package*.json ./

# Install Node.js dependencies
RUN npm install

# Copy the rest of the app
COPY . .

EXPOSE 3000

# Start your Node.js app
CMD ["node", "index.js"]