Adding json to new Django database

Question

I'm trying to create a database in Django with data stored in json.

 {
   'Vincent van Gogh': 
       {'The Starry Night': ['starryLink'], 
        'Irises': ['irisesLink']}, 
   'Leonardo da Vinci': 
       {'Mona Lisa': ['monalisalink'], 
        'The Last Supper': ['lastsupperlink']},
 }

Do I need to rewrite the above json into the format below?

[
{
    "model": "model.artistModel",
    "pk": 1,
    "fields": {
        "artist": "Vincent van Gogh",
        "title": "The Starry Night",
        "link": ["link.com"]
    }
},

I saw some examples of creating a Django db from a json but none looked like my json file. Do I have to script my data into a db with loops and such or can Django do it automatically?

Just the basic Django app. I haven't learned what Django Rest is yet. I'm just trying to create a new Django database with data stored in json — ian-campbell
– ian-campbell, Commented Nov 26, 2014 at 9:08

wolendranh · Accepted Answer · 2014-11-26 10:31:50Z

1

There is package Django Json Field. It has support of Python 3 and Django 1.7. Example:

from django.db import models
from jsonfield import JSONField

class MyModel(models.Model):
  json = JSONField()

answered Nov 26, 2014 at 10:31

wolendranh

4,3021 gold badge30 silver badges37 bronze badges

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

4 Comments

ian-campbell Over a year ago

I don't need to keep my json file intact. I just want to take the data and make a mysql database out of it for queries.

wolendranh Over a year ago

@edmund_spenser Are you talkink about json file like some initial data from which you will ceate a DB? Without created models in app?

ian-campbell Over a year ago

That's right, I don't even need the models really. I want to set up a database and then use it with Django.

wolendranh Over a year ago

I think you will still need to create models fro data that you want to loadinto db. For example model - Painter for your data from example. And then use initial.json like in this tutorial - docs.djangoproject.com/en/1.7/howto/initial-data

ian-campbell · Accepted Answer · 2014-12-07 20:57:37Z

To answer my own question, I had to rewrite my json file to be compliant with the Django model. I created my model in models.py to look like

class Art(models.Model):
    title = models.CharField()
    artist = models.CharField()
    link = models.URLField()

    def __unicode__(self):
        return u'%s, %s, %s' % (self.title, self.artist, self.link)

I went to the /admin/ panel, clicked on the Art model, and put in data and saved it. Then I ran

python manage.py dumpdata mydata.json

to see what the database would put out. The json it put out was in this format

[
{
     "pk": 1,  
     "model": "model.artistModel",
     "fields": {
         "artist": "Vincent van Gogh",
         "title": "The Starry Night",
         "link": "link.com"
     }
},

So I rearranged my json file to have that same structure, dropped in in my django /fixtures folder then ran

python manage.py loaddata myfixture.json

and like magic Django populated the database with all my data.

Collectives™ on Stack Overflow

Adding json to new Django database

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related