SQLAlchemy -通过父模型访问子模型的列(一对一关系)

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

Base = declarative_base()

class Parent(Base):
    __tablename__ = 'parents'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    child = relationship("Child", uselist=False, backref="parent")

class Child(Base):
    __tablename__ = 'children'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    parent_id = Column(Integer, ForeignKey('parents.id'))

# 创建数据库表
Base.metadata.create_all()

# 创建父模型对象
parent = Parent(name='Parent 1')

# 创建子模型对象
child = Child(name='Child 1')

# 将子模型对象关联到父模型对象
parent.child = child

# 通过父模型访问子模型的列
print(parent.child.name)  # 输出: Child 1