Pytest mock database: Fixture

conftest.py

import pytest
from pytest_mock_resources import create_postgres_fixture
from sqlalchemy.orm import Session

from model import Actor, User

pg = create_postgres_fixture(
    *[Actor, User]
)


@pytest.fixture
def session_same_name(pg):
    with Session(pg) as s:
        models = {
            'User': User(name='mock'),
            'Actor': Actor(name='mock')
        }
        s.bulk_save_objects(models.values())
        yield s, models