"""Test file for release_manual_adjustment model."""

from datetime import datetime

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


@db.test_schema
def test_delete(product_id):
    """Test delete release manual adjustment for given product."""
    new_release_manual_adjustment = release_manual_adjustment.ReleaseManualAdjustment(
        date_created=datetime.today(), created_by=179, category_id=1,
        release_id=product_id, amount=1, currencies_id=1,
        vendor_manual_adjustment_id=1, last_updated=datetime.today()
    )
    db.seed_models(new_release_manual_adjustment)
    with mysql.db_session() as session:
        release_manual_adjustment.delete(product_id, session)
        result = session.query(
            release_manual_adjustment.ReleaseManualAdjustment).all()
    assert result == []