"""Tests for mysql module."""

from sqlalchemy import text

from carveouts.connectors import mysql


def test_foreign_key_checks_is_on_by_default() -> None:
    """Test foreign key checks is still ON."""
    with mysql.db_connector.db_session() as session:
        result = session.execute(text("SHOW VARIABLES LIKE 'foreign_key_checks';"))
        assert result.mappings().one() == {
            "Variable_name": "foreign_key_checks",
            "Value": "ON",
        }