python propresql mysql_SQLAlchemy可以只对一些查询使用MySQL的SSCursor吗？

stream_results – Available on: Connection, statement. Indicate to the

dialect that results should be “streamed” and not pre-buffered, if

possible. This is a limitation of many DBAPIs. The flag is currently

understood only by the psycopg2 dialect.

我认为您只需要创建多个会话一个用于流式处理，一个用于普通查询，例如：from sqlalchemy.orm import sessionmaker

from sqlalchemy import create_engine

def create_session(engine):

# configure Session class with desired options

Session = sessionmaker()

# associate it with our custom Session class

Session.configure(bind=engine)

# work with the session

session = Session()

return session

#streaming

stream_engine = create_engine(connect_str, connect_args={'cursorclass': MySQLdb.cursors.SSCursor})

stream_session = create_session(stream_engine)

stream_session.execute(MyTable.__table__.select())

#normal

normal_engine = create_engine(connect_str)

normal_session = create_session(normal_engine)

normal_session.execute(MyTable.__table__.select())