from sqlalchemy import text

from carveouts.connectors.mysql import db_connector


def get_active_contract_id(vendor_id: int) -> int | None:
    with db_connector.db_session() as session:
        result = session.execute(
            text(
                """
                CALL sp_get_active_vendor_contract(:vendor_id)
                """
            ),
            {"vendor_id": vendor_id},
        )

    row = result.first()

    return int(row.vendor_contract_id) if row else None