Guest User

Untitled

a guest
Feb 25th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. association_table = db.Table('association', db.Model.metadata,
  2. db.Column('left_id', db.Integer, db.ForeignKey('orders.order_id')),
  3. db.Column('right_id', db.Integer, db.ForeignKey('fooditems.fooditem_id'))
  4. )
  5.  
  6. class OrderModel(ReviewableModel):
  7. __tablename__ = 'orders'
  8. order_id = db.Column(db.Integer, db.ForeignKey('reviewables.id'), primary_key=True)
  9. food_items = db.relationship("FoodItemModel", secondary = association_table)
  10. __mapper_args__ = {'polymorphic_identity':'orders'}
  11.  
  12. class FoodItemModel(ReviewableModel):
  13. __tablename__ = 'fooditems'
  14. fooditem_id = db.Column(db.Integer, db.ForeignKey('reviewables.id'), primary_key=True)
  15. __mapper_args__ = {'polymorphic_identity':'fooditems'}
  16.  
  17. def save_to_db(self):
  18. print('before: '+str(self.food_items))
  19. db.session.add(self)
  20. db.session.commit()
  21. print('after: '+str(self.food_items))
  22.  
  23. before: [<FoodItemModel u'Pizza'>, <FoodItemModel u'Pizza'>, <FoodItemModel u'Pizza'>]
  24. after: [<FoodItemModel u'Pizza'>]
  25.  
  26. "left_id" "right_id"
  27. "6" "3"
  28. "6" "3"
  29. "6" "3"
Add Comment
Please, Sign In to add comment