"""Tests for project MySQL queries."""

import pytest
from pytest_mock import MockerFixture

from contributor.queries.mysql.project import reassign_contributor_projects


@pytest.fixture
def session(mocker: MockerFixture):
    return mocker.Mock()


class TestReassignContributorProjects:
    def test_updates_matching_projects(self, session, mocker: MockerFixture) -> None:
        reassign_contributor_projects(
            session=session,
            contributor_artist_info_id=11,
            duplicate_artist_info_id=22,
        )

        session.execute.assert_called_once()
        session.commit.assert_called_once()

        update_stmt = session.execute.call_args.args[0]
        assert "project" in str(update_stmt)