"""Tests for the dependency-free SQL helpers in utilities/sql_utils.py."""


class TestEscapeLike:
    """Tests for escape_like — must be paired with escape='\\' at call site."""

    def test_escapes_percent(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("100%") == "100\\%"

    def test_escapes_underscore(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("a_b") == "a\\_b"

    def test_escapes_backslash(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("a\\b") == "a\\\\b"

    def test_no_special_chars(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("Nature") == "Nature"

    def test_mixed(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("a%b_c\\d") == "a\\%b\\_c\\\\d"

    def test_empty_string(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("") == ""

    def test_only_wildcards(self):
        from local_deep_research.utilities.sql_utils import escape_like

        assert escape_like("%_") == "\\%\\_"