"""Tests for mysql module."""

import pytest
from sqlalchemy import exc

from lyrics.connectors import mysql
from tests.test_utils import db


@db.test_schema
def test_session_rollback(mocker):
    """Check session context manager rollbacks transaction in exception."""
    mock = mocker.patch.object(mysql, '_db_session')
    with pytest.raises(exc.SQLAlchemyError):
        with mysql.db_session():
            raise exc.SQLAlchemyError()
    session = mock.return_value
    assert session.rollback.called
    assert session.close.called


def test_wrap_errors_fails(context, mocker):
    """Check wrap errors decorator."""
    @mysql.wrap_db_errors
    def func():
        raise exc.SQLAlchemyError()

    mock = mocker.patch('lyrics.connectors.mysql.capture_exception')
    with context:
        response = func()
    assert response.status == 500
    assert mock.called


def test_wrap_errors_pass():
    """Check wrap errors decorator."""
    @mysql.wrap_db_errors
    def func():
        pass
    response = func()
    assert response is None