How to insert multiple records using JSON in SQLAlchemy

Question

I want to insert multiple records using json like this:

posts = [{
            "title": "First Post",
            "user_id": 1
        }, 
        {
            "title": "Second Post", 
            "user_id": 2
        }]

How do you save posts like this way?:

post = Post(title=posts.title, user_id=posts.user_id)
db.session.add(post)
db.session.commit()

I am using flask 1.0.2 and Python 3.6.6.

Stephen Rauch · Accepted Answer · 2018-08-09 03:53:33Z

3

You can do something like this:

for post_dict in posts:
    db.session.add(Post(**post_dict))
db.session.commit()

The ** magic is explained (Here).

answered Aug 9, 2018 at 3:53

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

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

Collectives™ on Stack Overflow

How to insert multiple records using JSON in SQLAlchemy

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related