"""Tests for mysql module."""

import pytest
from sqlalchemy import exc

from salessheets.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, '_ss_db_session')
    with pytest.raises(exc.SQLAlchemyError):
        with mysql.ss_db_session():
            raise exc.SQLAlchemyError()
    session = mock.return_value
    assert session.rollback.called
    assert session.close.called