How to Load JSON Data in Django Model

Question

I want to load below json data in my Model.

{
    "99popularity": 79.0,
    "director": "William Cottrell",
    "genre": [
      "Animation",
      " Family",
      " Fantasy",
      " Musical",
      " Romance"
    ],
    "imdb_score": 7.9,
    "name": "Snow White and the Seven Dwarfs"
  },
  {
    "99popularity": 84.0,
    "director": "Stanley Kubrick",
    "genre": [
      "Adventure",
      " Mystery",
      " Sci-Fi"
    ],
    "imdb_score": 8.4,
    "name": "2001 : A Space Odyssey"
  },

I have create two models using reference to json data

class Genre(models.Model):
    name = models.CharField(max_length=30)

class Movie(models.Model):
    popularity = models.FloatField(max_length=10)
    director = models.CharField(max_length=30)
    genre = models.ManyToManyField(Genre)
    imdb_score = models.FloatField(max_length=10)
    name = models.CharField(max_length=30)

But in Genre Model i don't have any data and in json in genre section their is no id instead name. How can i load that data in my model. Please Help.

right now i am trying to read json file and trying to convert 99popularity because it is not valid field name in django model — Cipher
– Cipher, Commented Mar 13, 2019 at 14:14
When you say you want to load the json into the db what do you mean? Is that inside a migration file to load this once? Or in a view where you process the json? Or are you talking about manage.py loaddata? — dirkgroten
– dirkgroten, Commented Mar 13, 2019 at 14:19
Then show us the code you have till now, so we can see what’s not working. — dirkgroten
– dirkgroten, Commented Mar 13, 2019 at 14:26

p14z · Accepted Answer · 2019-03-14 16:12:23Z

5

You can use the get_or_create method, but you have to make the name field unique. To create two models using reference to json data, I would use a custom class method like this:

class Genre(models.Model):
    name = models.CharField(max_length=30, unique=True)  # make unique

class Movie(models.Model):
    popularity = models.FloatField(max_length=10)
    director = models.CharField(max_length=30)
    genre = models.ManyToManyField(Genre)
    imdb_score = models.FloatField(max_length=10)
    name = models.CharField(max_length=30)


    @classmethod
    def create(cls, **kwargs):
        movie = cls.objects.create(
            popularity=kwargs['99popularity'],
            director=kwargs['director'],
            imdb_score=kwargs['imdb_score'],
            name=kwargs['name']
        )
        for genre_name in kwargs['genre']:
            genre, created = Genre.objects.get_or_create(name=genre_name)
            movie.genre.add(genre)
        return movie

Assuming you converted your json data to a string you can do this:

import json
from .models import Movie

# you can also keep this inside a view
with open('movie_data.json', encoding='utf-8') as data_file:
    json_data = json.loads(data_file.read())

    for movie_data in json_data:
        movie = Movie.create(**movie_data)
        # movie and genres created

edited Mar 14, 2019 at 16:12

answered Mar 13, 2019 at 14:46

p14z

1,8101 gold badge13 silver badges17 bronze badges

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

4 Comments

Cipher Over a year ago

Your code gave me good idea how to do it. I am confused how to load that json data. because i am not using fixture

p14z Over a year ago

If you have a json file you can use this question on how to convert it to a dict stackoverflow.com/questions/2835559/…

Cipher Over a year ago

Thanks you understood my actual question. This was my first time to play with json file in Python

p14z Over a year ago

@gormih yes, you can use bulk_create for big datasets.

Collectives™ on Stack Overflow

How to Load JSON Data in Django Model

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related