http://www.ergo.io/blog/sqlalchemy-relationships-from-beginner-to-advanced
class Cabinet(db.Model): __tablename__ = 'cabinet' uuid = db.Column(db.String(40), primary_key=True, nullable=True, default=str(uuid.uuid4())) id = db.Column(db.String(20)) description = db.Column(db.Text) racks = db.relationship('Rack', backref='cabinet') class Rack(db.Model): __tablename__ = 'rack' uuid = db.Column(db.String(40), primary_key=True, nullable=True, default=str(uuid.uuid4())) id = db.Column(db.String(20)) cabinet_id = db.Column(db.String(40), db.ForeignKey('cabinet.uuid'))方法1
racks = [ Rack(uuid=uuid.uuid4(), id=i for i in xrange(1,43) ] cabinet = Cabinet(id='bj-01', description='bj-01', racks=racks) # 前一个racks是到Rack的关联对象，后一个racks是一个Rack对象数组 db.session.add(cabinet) db.session.commit()方法2
cabinet = Cabinet(id='bj-01', description='bj-01') db.session.add(cabinet) for i in xrange(42): rack = Rack(uuid=str(uuid.uuid4()), id=i, cabinet=cabinet) #cabinet是反向引用 db.session.add(rack) db.session.commit() posted on 2017-01-16 14:15 北京涛子 阅读( ...) 评论( ...) 编辑 收藏转载于:https://www.cnblogs.com/liujitao79/p/6289447.html
