how to insert multiple rows into a single table using flask-sqlalchemy

Question

Here this is my table.

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

show us the request you are sending

SLDem
– SLDem

2021-01-09 10:11:55 +00:00
Commented Jan 9, 2021 at 10:11 — SLDem
– SLDem, Commented Jan 9, 2021 at 10:11

giuppep · Accepted Answer · 2021-01-11 16:35:46Z

2

You have two ways of doing this:

data = [{"main_id": 1, "name": "test", ...}, ...]

# method 1
relatives_to_add = [Relative(**row) for row in data]
db.session.add_all(relatives_to_add)
db.session.commit()

# method 2
db.session.bulk_insert_mappings(Relative, data)
db.session.commit()

PS: use proper casing for classes https://www.python.org/dev/peps/pep-0008/#class-names

answered Jan 11, 2021 at 16:35

giuppep

1,1532 gold badges11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert multiple rows into a single table using flask-sqlalchemy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related