How to store data into SQLite database from existing JSON file in Django?

Question

Suppose I have JSON file

{Key1:value,
key2:value,
key3:value}

{Key1:value,
key2:value,
key3:value}

Now I want to store this data into SQLite database which should have one table having fields: Key 1, Key 2, Key 3.

How can I save this data into database using script?

Brian Guggenheimer · Accepted Answer · 2017-07-14 22:35:41Z

4

What you are looking for is django fixtures.

First, make a django model that represents the table that you want to create. Key1, Key2, etc. are the fields in your model.

Then, all you need to do is get your data into the correct json format like the one below.

[
  {
    "model": "myapp.person",
    "pk": 1,
    "fields": {
      "first_name": "John",
      "last_name": "Lennon"
    }
  },
  {
    "model": "myapp.person",
    "pk": 2,
    "fields": {
      "first_name": "Paul",
      "last_name": "McCartney"
    }
  }
]

Finally, run python manage.py loaddata <json filepath>. And you're done!

answered Jul 14, 2017 at 22:35

Brian Guggenheimer

2331 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

How to store data into SQLite database from existing JSON file in Django?

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