如何在金字塔web应用程序中手动提交sqlalchemy数据库事务？

from pyramid.view import view_config
from pyramid.response import Response
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from myapp.models import DBSession

engine = create_engine('数据库连接字符串')
DBSession.configure(bind=engine)
Session = sessionmaker(bind=engine)

@view_config(route_name='commit_transaction', request_method='GET')
def commit_transaction(request):
    # 获取数据库会话
    session = Session()

    try:
        # 执行需要的数据库操作，例如插入、更新等
        # ...

        # 手动提交事务
        session.commit()

        return Response("事务提交成功")
    except:
        # 发生异常时回滚事务
        session.rollback()
        return Response("事务提交失败")
    finally:
        # 关闭数据库会话
        session.close()