Jan-09-2021, 10:36 AM
How to insert multiple rows in a single request using flask-sqlalchemy.
class relatives(db.Model): id = db.Column(db.Integer, primary_key=True) main_id = db.Column(db.Integer, db.ForeignKey('maindevotee.id'), nullable=False) name = db.Column(db.String(225)) star = db.Column(db.String(225)) gender = db.Column(db.String(45)) relation = db.Column(db.String(45)) def json(self): return {'main_id': self.main_id, 'name': self.name, 'star':self.star, 'gender': self.gender, 'relation': self.relation} def add_relatives(_main_id, _name, _star, _gender, _relation): new_relative = relatives(main_id=_main_id, name=_name, star=_star, gender=_gender, relation=_relation) db.session.add(new_relative) db.session.commit()I am unable to insert multiple rows(multiple objects) in a table.How it is possible. I mean i want to add more than one row in a single request.
@app.route('/relatives',methods=['GET','POST']) def relative(): request_data = request.get_json() relatives.add_relatives(request_data['main_id'], request_data['name'], request_data['star'], request_data['gender'], request_data['relation']) response = Response('Relative added', 201, mimetype='application/json') return response