Populate model(database) with json data in django

Question

I read about de/serializers but i couldn't find my way here. I have two apps, one where i store my data(scraped data) and another where i use the current/new data to display. I have identical models in these two apps. So i converted model of say app A to json and now i want to populate model of app B with that json . How might it be done? I didn't like to use django REST framework though.

so i did python manage.py dumpdata app_name > somefile.json

how do i populate fields of model B with the contents of somefile.json?

theguru42 · Accepted Answer · 2014-03-26 16:39:08Z

3

You can use model serializers. Lets say you have a model MyModel, create a serailizer for this model by,

class MyModelSerializer(serializers.ModelSerializer):
    class Meta:
        model = MyModel

You will have to create a list with each element in the list as a dictionary of MyModel instance data. JSON data in python is basically a dictionary. So each element in your list will be dictionary (JSON data) for each unique instance of your model.

The list might look like:

[
    {
        "pk": "1",
        "field_1": "data_1",
        "field_2": "data_2",
        .....
    },
    {
        "pk": "2",
        "field_1": "data_1",
        "field_2": "data_2",
        .....
    },
    ...
]

Now pass the list with json data for MyModel to the serializer. If the json data is valid the serializer will deserialize the data into MyModel instances. Then you can simply save them.

serializer = MyModelSerializer(data=json_data, many=True)
if serializer.is_valid():
    serializer.save()  # `.save()` will be called on each deserialized instance

answered Mar 26, 2014 at 16:39

theguru42

3,38726 silver badges38 bronze badges

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

1 Comment

KareemElashmawy Over a year ago

This appears to be deprecated in Django 1.11 (serializers.ModelSerializer DNE)

Collectives™ on Stack Overflow

Populate model(database) with json data in django

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related