FROM python:3.13.17-slim-bookworm@sha256:e32be0e55814a08977501ca863271d9bd02443710db8f2afaf8372e2c4508530
RUN apt-get update && apt-get install -y --no-install-recommends curl ca-certificates unixodbc-dev g++ \
    && curl -fsSL https://packages.microsoft.com/config/debian/12/packages-microsoft-prod.deb -o /tmp/ms.deb \
    && dpkg -i /tmp/ms.deb && rm /tmp/ms.deb \
    && apt-get update && ACCEPT_EULA=Y apt-get install -y --no-install-recommends msodbcsql18 \
    && rm -rf /var/lib/apt/lists/*
WORKDIR /workspace
COPY .local/database-tests/sdk/ /tmp/sdk/
RUN python -m pip install --no-cache-dir --upgrade 'pip @ https://files.pythonhosted.org/packages/3f/06/3e4420302363fbb71be3c7f35ce042f54bfca330e3e66b3a2e3c4cca579f/pip-26.2.2-py3-none-any.whl#sha256=fd7f4dfa8190e014013b9f08f3e973f4e4c26ffd179a204895533a7254813a70' \
    && python -m pip install --no-cache-dir certifi==2026.10.19 \
    && pip install --no-cache-dir -r /tmp/sdk/requirements.txt
COPY pyproject.toml README.md LICENSE MANIFEST.in ./
COPY scripts/ scripts/
COPY api/ api/
COPY src/ src/
COPY docs/ docs/
COPY .mainsequence/workflows/metatables-api.yaml .mainsequence/workflows/metatables-api.yaml
COPY .agents/skills/client/ .agents/skills/client/
RUN python -m pip install --no-cache-dir --upgrade 'pip @ https://files.pythonhosted.org/packages/3f/06/3e4420302363fbb71be3c7f35ce042f54bfca330e3e66b3a2e3c4cca579f/pip-26.2.2-py3-none-any.whl#sha256=fd7f4dfa8190e014013b9f08f3e973f4e4c26ffd179a204895533a7254813a70' \
    && python -m pip install --no-cache-dir certifi==2026.10.19 \
    && pip install --no-cache-dir '.[dev,mysql]'
ENV PYTHONPATH=/workspace/src:/workspace
ENTRYPOINT ["python", "-m", "scripts.test_databases", "--inside"]
