implementing FastAPI Dependency Injection for Async Database Calls in SQLAlchemy 1.4
I've looked through the documentation and I'm still confused about Quick question that's been bugging me - I'm working with difficulties when trying to use FastAPI's dependency injection system with asynchronous database calls in SQLAlchemy 1.4..... I want to ensure that my database session is properly managed and closed when a request is completed. However, I'm working with the behavior: `RuntimeError: Task <Task pending name='Task-1' coro=<...> cb=[<TaskWakeupMethWrapper object at 0x...>()]> got Future <Future pending> attached to a different loop`. I've set up my FastAPI application and SQLAlchemy session as follows: ```python from fastapi import FastAPI, Depends from sqlalchemy.ext.asyncio import AsyncSession, create_async_engine, async_sessionmaker from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker DATABASE_URL = 'postgresql+asyncpg://user:password@localhost/dbname' engine = create_async_engine(DATABASE_URL) Base = declarative_base() SessionLocal = async_sessionmaker(engine, class_=AsyncSession, expire_on_commit=False) app = FastAPI() async def get_db() -> AsyncSession: async with SessionLocal() as session: yield session @app.get("/items/") async def read_items(db: AsyncSession = Depends(get_db)): result = await db.execute("SELECT * FROM items") items = result.scalars().all() return items ``` In my testing, I notice that when making multiple requests in quick succession, this behavior occurs. I've also tried to run the FastAPI app with different configurations, but the scenario continues. I ensured that all dependencies are up-to-date, including `fastapi==0.68.0` and `sqlalchemy==1.4.22`. Any suggestions on how to properly handle the session management or resolve this runtime behavior would be greatly appreciated. How would you solve this?