KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a typical Relational Database model laid out in Django where a typical model contains some ForeignKeys , some ManyToManyFields , and some fields that extend Django's DateTimeField . I want to save data that I am receiving in JSON format (not flat) from an external api. I wan't it such that data gets saved to respective tables (not the whole json string to one field). What is the most clean and simple approach to do this? Is there a library available to make this task simpler? Here's an example to clarify my question, Models- class NinjaData(models.Model): id = models.IntegerField(primary_key=True, unique=True) name = models.CharField(max_length=60) birthdatetime = MyDateTimeField(null=True) deathdatetime = MyDatetimeField(null=True) skills = models.ManyToManyField(Skills, null=True) weapons = models.ManyToManyField(Weapons, null=True) master = models.ForeignKey(Master, null=True) class Skills(models.Model): id = models.IntegerField(primary_key=True, unique=True) name = models.CharField(max_length=60) difficulty = models.IntegerField(null=True) class Weapons(models.Model): id = models.IntegerField(primary_key=True, unique=True) name = models.CharField(max_length=60) weight = models.FloatField(null=True) class Master(models.Model): id = models.IntegerField(primary_key=True, unique=True) name = models.CharField(max_length=60) is_awesome = models.NullBooleanField() now, I typically have to save json string data that I obtain from an external api (secret ninja api) into this model, json looks like this JSON- { "id":"1234", "name":"Hitori", "birthdatetime":"11/05/1999 20:30:00", "skills":[ { "id":"3456", "name":"stealth", "difficulty":"2" }, { "id":"678", "name":"karate", "difficulty":"1" } ], "weapons":[
Tags (comma-separated)
Save Edits
Cancel