model-view-controller - 在 SQLAlchemy 中记录模型

Question

是否有正确的方法来记录 SQLAlchemy 模型？我希望能够将字段描述直接放入类中，以便我可以以某种方式获取描述。有事Django's help_text field

 class User(Base):
    username   = Column(u'username', String(255))
    email      = Column(u'email', String(255))

类似的东西

 class User(Base):
    username   = Column(u'username', String(255), description="System Username unique across all clusters")
    email      = Column(u'email', String(255), description="Email address of the User, and some other important info about it I would like to get at" )

Answer 1

你可以在你的 Base.metadata.create_all(self.db) 之后做这个......不过不要引用我，它很原始

conn = self.db.connect()
for table in Base.metadata.tables.itervalues():
    for colname in table.columns.keys():
        doc = table.columns[colname].doc
        conn.execute("COMMENT ON COLUMN %s.%s IS %%s"
                     % (table.name, colname), doc)
conn.execute("COMMIT")
conn.close()