在SQLAlchemy的多个表中自动插入/更新行

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

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

from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    addresses = relationship('Address', back_populates='user')

class Address(Base):
    __tablename__ = 'address'
    id = Column(Integer, primary_key=True)
    email = Column(String)
    user_id = Column(Integer, ForeignKey('user.id'))
    user = relationship('User', back_populates='addresses')

user = User(name='John')
address = Address(email='john@example.com')
user.addresses.append(address)

session.add(user)
session.commit()

user.name = 'John Smith'
address.email = 'john.smith@example.com'
session.commit()