"""Unit testcases for mysql_query_template."""

from pathlib import Path

from adjustments_json_import.mysql_query_template import render_sql_template


def test_render_sql_template():
    """Test render_sql_template method."""
    query = render_sql_template(
        f'{Path(__file__).parents[2]}/adjustments_json_import/sql_templates/get_statement_periods_by_years.sql',
        {'statement_years': ['2026']},
    )

    assert query == 'SELECT * FROM statement_period WHERE statement_year IN (2026);'