"""Test Release Approval Queue Model."""
import time

from ows_product_physical.connector.mysql import db_session
from ows_product_physical.models import release_approval_queue as release_approval_queue_model # noqa
from ows_product_physical.models.release_approval_queue import ReleaseApprovalQueue # noqa


def _fetch_release_approval_queue(product_id, session):
    """Util for fetching a release approval queue row."""
    return session.query(ReleaseApprovalQueue) \
        .filter(ReleaseApprovalQueue.release_id == product_id) \
        .one().to_dict()


def test_create_release_approval_queue(db_fixture):
    """Test successful creation of release approval with default values."""
    product_id = 42
    vendor_id = 7123

    with db_session() as session:
        release_approval_queue_model.create(product_id, vendor_id, session)

        result = _fetch_release_approval_queue(product_id, session)

        assert result == {
            'release_id': product_id,
            'admin_approval': 'N',
            'status': 'checked_in',
            'submitted_by': vendor_id,
            'release_approval_id': 1,
            'last_updated': time.strftime('%Y-%m-%d'),
            'date_submitted': time.strftime('%Y-%m-%d')
        }