Guest User

Untitled

a guest
Jan 18th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. Class Parent(db.Model):
  2. id = db.Column(db.Integer, nullable=False, autoincrement=True, primary_key=True)
  3. name = db.Column(db.String, nullable=False)
  4.  
  5. children = relationship('Child',
  6. secondary=parent_has_children,
  7. back_populates='parents'
  8. )
  9.  
  10.  
  11. Class Child(db.Model):
  12. id = db.Column(db.Integer, nullable=False, autoincrement=True, primary_key=True)
  13. name = db.Column(db.String, nullable=False)
  14.  
  15. parents = relationship('Parent',
  16. secondary=parent_has_children,
  17. back_populates='children'
  18. )
  19.  
  20. parent_has_children = db.Table('parent_has_children', db.metadata,
  21. db.Column('parent_id', db.Integer, ForeignKey('Parent.id')),
  22. db.Column('child_id', db.Integer, ForeignKey('Child.id'))
  23. )
  24.  
  25. @app.route('/buildrelationship', methods=['POST'])
  26. def buildrelationship():
  27. child_id= request.json['student_id']
  28. parent_id = request.json['parent_id']
  29. child = Child.query.get(child_id)
  30. parent = Parent.query.get(parent_id)
  31. parent.children.append(child)
  32. db.session.commit()
Add Comment
Please, Sign In to add comment