如何使用SQLAlchemy声明性语法指定关系?

假设你指的是 the declarative plugin ,我要说的每一句话都用例子记录下来了:

class User(Base):
    __tablename__ = 'users'

    id = Column('id', Integer, primary_key=True)
    addresses = relation("Address", backref="user")

class Address(Base):
    __tablename__ = 'addresses'

    id = Column('id', Integer, primary_key=True)
    user_id = Column('user_id', Integer, ForeignKey('users.id'))

查看的“配置关系”部分 Declarative docs . 没有“一个托马斯”那么高的级别,但比完全指定关系要好。

class Address(Base):
    __tablename__ = 'addresses'

    id = Column(Integer, primary_key=True)
    email = Column(String(50))
    user_id = Column(Integer, ForeignKey('users.id'))