使用SqlAlchemy通过主键列表从数据库加载多个实例

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import and_, or_, not_, in_

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

Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    name = Column(String)

primary_keys = [1, 2, 3]  # 主键列表
instances = session.query(MyTable).filter(MyTable.id.in_(primary_keys)).all()

for instance in instances:
    print(instance.id, instance.name)