"""Unit tests for artist_links model."""

from unittest.mock import MagicMock

from participant.models import artist_links


def test_get_query_no_id(monkeypatch):
    """Test get query no id."""
    monkeypatch.setattr(artist_links, '_log_missing_id', MagicMock())

    data = [
        {
            'id': 1,
            'store_artist_id': 'cow\'cow',
        },
        {
            'store_artist_id': 'dang',
        },
    ]

    result = artist_links._get_query(data)
    assert (
        result
        == """
        INSERT INTO participant_external_link (
        participant_external_link_id,
        store_artist_id,
        vendor_id,
        store_id,
        created_at,
        last_updated
        )
        VALUES
        (1, "cow\\'cow",1, 1, NOW(), NOW())
        ON DUPLICATE KEY UPDATE
            store_artist_id = VALUES(store_artist_id),
            last_updated = NOW();
        """
    )