Json to django models. Python data-type error

Question

I have got when I want convert json data in django models. How can I solve it.

class Persons(models.Model):
rank = models.IntegerField()
employer = models.CharField(max_length=100)
employeesCount = models.IntegerField()
medianSalary = models.IntegerField()

object creater:

for json in json_string:
Persons.objects.create(id=json['rank'], employer=json['employer'], employeesCount=json['employeesCount'], medianSalary=json['medianSalary'])

json reader

f = open('data.json')
json_string = f.read()
f.close()

json file: [ { "rank": 1, "employer": "Walmart", "employeesCount": 2300000, "medianSalary": 19177 }, { "rank": 2, "employer": "Amazon", "employeesCount": 566000, "medianSalary": 38466 } ]

Márcio Carôso · Accepted Answer · 2020-08-01 13:27:30Z

1

Your code is expecting a dictionary. Convert the json string using the builtin library

import json
your_json = json.loads(f.read())

answered Aug 1, 2020 at 13:27

Márcio Carôso

1638 bronze badges

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

Comments

willeM_ Van Onsem · Accepted Answer · 2020-08-01 13:56:18Z

0

Th json_strings is just a string, not a list of dictionaries. You can make use of the json module [python-doc] to JSON deserialize it:

from json import load as json_load

with open('data.json') as f:
    json_data = json_load(f)

Persons.objects.bulk_create([
    Person(
        id=record['rank'],
        employer=record['employer'],
        employeesCount=record['employeesCount'],
        medianSalary=record['medianSalary']
    )
    for record in json_data
])

By using bulk_create you create the objects in bulk in the database, which reduces the number of roundtrips to the database.

edited Aug 1, 2020 at 13:56

answered Aug 1, 2020 at 13:27

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Collectives™ on Stack Overflow

Json to django models. Python data-type error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest