"""Test artist delivery settings."""

from video.connectors import mysql
from video.models.sql.classes import artist_delivery_settings

from tests.unit import ar_db_utils


@ar_db_utils.test_schema
def test_get() -> None:
    """Test get."""
    artist_id = 12
    with mysql.ar_db_session(turn_off_foreign_key_constraint=True) as session:
        channel = artist_delivery_settings.ArtistDeliverySettings(
            channel_name="Bobby",
            channel_id="12",
            vevo_controlled="No",
            artist_id=artist_id,
        )
        session.add(channel)
        session.flush()

    result = artist_delivery_settings.get(artist_id)
    assert result == [
        {
            "id": 1,
            "artist_id": artist_id,
            "channel_id": "12",
            "channel_name": "Bobby",
            "vevo_controlled": "No",
        }
    ]