直接更新SQLalchemy类并获取实例

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('数据库连接字符串')

Session = sessionmaker(bind=engine)

Base = declarative_base()

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

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

Base.metadata.create_all(engine)

session = Session()

new_instance = MyTable(name='John', age=25)
session.add(new_instance)
session.commit()

instances = session.query(MyTable).all()
for instance in instances:
    print(instance.name, instance.age)