Function sqlite_engine_meta

tests/_sql/test_sqlalchemy.py:92–110

Create a temporary SQLite database with information_schema. Use a mock information_schema

()

@pytest.fixture
def sqlite_engine_meta() -> sa.Engine:
    """Create a temporary SQLite database with information_schema.
    Use a mock information_schema"""

    import sqlalchemy as sa

    engine = sa.create_engine("sqlite:///:memory:")

    sql("ATTACH ':memory:' AS information_schema", engine=engine)
    sql(
        "CREATE TABLE information_schema.tables (table_name TEXT)",
        engine=engine,
    )
    sql(
        "INSERT INTO information_schema.tables VALUES ('tables')",
        engine=engine,
    )

    return engine


@pytest.mark.skipif(not HAS_SQLALCHEMY, reason="SQLAlchemy not installed")