sqlalchemy-bind-manager/tests/test_sqlalchemy_bind_manager.py at 452f436b5eaeecf86fb5763c64eb47cd06453747 · febus982/sqlalchemy-bind-manager · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
from unittest.mock import patch

import pytest
from sqlalchemy import MetaData
from sqlalchemy.ext.asyncio import AsyncSession
from sqlalchemy.orm import Session, registry

from sqlalchemy_bind_manager import (
    SQLAlchemyBindManager,
    SQLAlchemyConfig,
)
from sqlalchemy_bind_manager.exceptions import (
    InvalidConfigError,
    NotInitializedBindError,
)


@pytest.mark.parametrize(
    "supplied_config",
    [
        {"bind_name": "Invalid Config"},
        {
            "valid": SQLAlchemyConfig(
                engine_url="sqlite://",
                engine_options=dict(connect_args={"check_same_thread": False}),
                session_options=dict(expire_on_commit=False),
            ),
            "invalid": "Invalid Config",
        },
        "Invalid single config",
    ],
)
def test_invalid_config_raises_exception(supplied_config):
    # We consciously ignore the type to supply an invalid config
    with pytest.raises(InvalidConfigError):
        SQLAlchemyBindManager(supplied_config)  # type: ignore


def test_initialised_bind_raises_error(single_config):
    sa_manager = SQLAlchemyBindManager(single_config)
    with pytest.raises(NotInitializedBindError):
        sa_manager.get_session("uninitialised bind")


def test_single_config_creates_default_bind(single_config):
    sa_manager = SQLAlchemyBindManager(single_config)

    assert len(sa_manager.get_binds()) == 1

    default_bind = sa_manager.get_bind()
    assert default_bind is not None
    assert isinstance(sa_manager.get_mapper(), registry)
    assert isinstance(sa_manager.get_session(), Session)
    assert sa_manager.get_session().get_bind() == default_bind.engine


def test_multiple_binds(multiple_config):
    sa_manager = SQLAlchemyBindManager(multiple_config)
    assert len(sa_manager.get_binds()) == 2

    mappers_metadata = sa_manager.get_bind_mappers_metadata()
    assert len(mappers_metadata) == 2
    for key in ["default", "async"]:
        assert key in mappers_metadata
        assert isinstance(mappers_metadata[key], MetaData)

    default_bind = sa_manager.get_bind()
    assert default_bind is not None
    assert isinstance(sa_manager.get_mapper(), registry)
    assert isinstance(sa_manager.get_session(), Session)

    async_bind = sa_manager.get_bind("async")
    assert async_bind is not None
    assert isinstance(sa_manager.get_mapper("async"), registry)
    assert isinstance(sa_manager.get_session("async"), AsyncSession)


def test_engine_is_disposed_on_cleanup(multiple_config):
    """Test that engines are disposed synchronously during garbage collection.

    This test verifies that both sync and async engines are properly disposed
    using synchronous disposal (sync_engine.dispose() for async engines).
    """
    sa_manager = SQLAlchemyBindManager(multiple_config)
    sync_engine = sa_manager.get_bind("default").engine
    async_engine = sa_manager.get_bind("async").engine

    original_sync_dispose = sync_engine.dispose
    # For async engines, we now use sync_engine.dispose() for safe cleanup
    original_async_sync_dispose = async_engine.sync_engine.dispose

    with (
        patch.object(
            sync_engine,
            "dispose",
            wraps=original_sync_dispose,
        ) as mocked_dispose,
        patch.object(
            async_engine.sync_engine,
            "dispose",
            wraps=original_async_sync_dispose,
        ) as mocked_async_sync_dispose,
    ):
        sa_manager = None

    mocked_dispose.assert_called_once()
    mocked_async_sync_dispose.assert_called_once()


def test_atexit_cleanup_disposes_all_managers(multiple_config):
    """Test that the atexit handler disposes all tracked manager instances."""
    from sqlalchemy_bind_manager._bind_manager import _cleanup_all_managers

    sa_manager = SQLAlchemyBindManager(multiple_config)

    with patch.object(
        sa_manager,
        "_dispose_sync",
    ) as mocked_dispose_sync:
        _cleanup_all_managers()

    mocked_dispose_sync.assert_called_once()