Sqlalchemy 数据库连接为什么不会被关闭？如何解决这个问题？

from sqlalchemy import create_engine, url, select
from sqlalchemy.orm import sessionmaker, scoped_session
# ... other imports

class Database:
    env = None
    # ... other methods and attributes

    def table_data_query_all(self, model, condition=None, order=None, limit=500, fields=None):
        query = select(model)
        # ... query construction ...
        result = [row.dict() for row in self.database.execute(query.limit(limit)).scalars()]
        self.database.get_bind().dispose()  #尝试释放连接
        return result

    def close(self):
        if self.database is not None:
            self.database.close()

from sqlalchemy import create_engine, select
from sqlalchemy.orm import sessionmaker

engine = create_engine(your_database_url)  # your_database_url should be replaced with your connection string
Session = sessionmaker(bind=engine)

def table_data_query_all(model, condition=None, order=None, limit=500, fields=None):
    with Session() as session:
        query = select(model)
        # ... query construction ...
        result = [row.dict() for row in session.execute(query.limit(limit)).scalars()]
        return result

# No explicit close() method needed.

engine = create_engine(your_database_url)
# ... your code ...
engine.dispose() # 关闭连接池