FROM python:3.11-slim

WORKDIR /app

# Install dependencies
COPY requirements.txt .
RUN pip install --no-cache-dir -r requirements.txt

# Copy application
COPY oracle_publisher.py .

# Create non-root user
RUN useradd -m -u 1000 oracle && chown -R oracle:oracle /app
USER oracle

# Run application
CMD ["python", "oracle_publisher.py"]

