from datetime import datetime
from uuid import uuid1

from ytownership.connectors.mysql import session_scope
from ytownership.models.apilog import YouTubeApiLog


def test_db_insert(db_fixture):
    with session_scope() as session:
        log_record = YouTubeApiLog()
        log_record.code = 200
        log_record.created_date_utc = datetime.utcnow()
        log_record.content_owner_id = 'theorchardmusic'
        log_record.correlation_id = str(uuid1())
        log_record.isrc = 'TEST_ISRC'
        log_record.message = 'test_message'
        log_record.territories = 'US,CA'
        log_record.status = 'success'
        session.add(log_record)
        record = session.query(YouTubeApiLog).first()
        assert record