"""Tests for mysql module."""

import pytest
from sqlalchemy import exc

import mysql
import test_utils


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