"""Test file for release_subtitles model."""

from product_digital.connectors import mysql
from product_digital.models import release_subtitles
from tests.testutils import db


@db.test_schema
def test_delete(product_id):
    """Test delete release subtitles for given product."""
    new_release_subtitles = release_subtitles.ReleaseSubtitles(
        release_id=product_id, import_asset_id=1, file_type='srt',
        language_tag='abc', track_id=11, status='new'
    )
    db.seed_models(new_release_subtitles)
    with mysql.db_session() as session:
        release_subtitles.delete(product_id, session)
        result = session.query(release_subtitles.ReleaseSubtitles).all()
    assert result == []