根据值将SQLAlchemy外键ID添加到另一个表中

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

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    posts = relationship('Post', backref='user')

class Post(Base):
    __tablename__ = 'posts'
    id = Column(Integer, primary_key=True)
    title = Column(String)
    user_id = Column(Integer, ForeignKey('users.id'))

# 假设我们已经有一个用户对象，我们想要将其ID添加到一个新的帖子对象中
user = session.query(User).filter_by(name='John').first()

# 创建一个新的帖子对象，并将外键字段设置为用户对象的ID
post = Post(title='Hello World', user_id=user.id)

# 将新的帖子对象添加到会话中并提交更改
session.add(post)
session.commit()