@pytest_asyncio.fixture(scope="session", autouse=True)
async def init_test_db():
    db_url = "sqlite://:memory:"
    await Tortoise.init(db_url=db_url, modules={"modules": ["app.models"]})
    await Tortoise.generate_schemas()
    yield
    await Tortoise._drop_databases()

I did it like this