Django saving json value to database/model

Question

Im new to django and im trying to save json to database. The problem is that im able to get data the data in my views but not sure how to save it in database. Im trying to save the comments

models.py

class Post(models.Model):
    title=models.CharField(max_length=200)
    description=models.TextField(max_length=10000)
    pub_date=models.DateTimeField(auto_now_add=True)
    slug = models.SlugField(max_length=40, unique=True)

    def __unicode__(self):
        return self.title


class Comment(models.Model):
    title=models.ForeignKey(Post)
    comments=models.CharField(max_length=200)

    def __unicode__(self):
        return '%s' % (self.title)

serializer.py

class CommentSerializer(serializers.ModelSerializer):
    id = serializers.CharField(source="title.id", read_only=True)
    title = serializers.CharField(source="title.title", read_only=True)

class Meta:
    model = Comment
    fields = ('id','title','comments')


class PostSerializer(serializers.ModelSerializer):

    class Meta:
        model = Post
        fields = ('id','title','description','pub_date')

Please help me saving the data from views to database

view.py

def add_comments(request):
    if 'application/x-www-form-urlencoded' in request.META['CONTENT_TYPE']:
        print 'hi'
        data = json.loads(request.body)
        comment = data.get('comment', None)
        id = data.get('id', None)
        title = data.get('title', None) 
        ....................# not sure how to save to database
       pass

Thanks in advance........Please let me know if there is any better way to do it...

GIA · Accepted Answer · 2023-06-29 22:49:26Z

13

If you're using Postgres, you can store json with JSONField (read more), but if not, you need parse json to string and save with CharField/TextField using json.dumps(data). To recovery data, use json string to dict with json.loads(json_string)

Remember to import json lib: import json

Update 2023

Based on @Jarad comment,

JSONField is supported on MariaDB, MySQL, Oracle, PostgreSQL, and SQLite (with the JSON1 extension enabled).

https://docs.djangoproject.com/en/4.2/ref/models/fields/#jsonfield

edited Jun 29, 2023 at 22:49

answered Jun 9, 2017 at 17:50

GIA

1,7462 gold badges29 silver badges41 bronze badges

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

1 Comment

Jarad Over a year ago

JSONField is supported on MariaDB, MySQL, Oracle, PostgreSQL, and SQLite (with the JSON1 extension enabled). Django 4.2 Docs

Josh O'Bryan · Accepted Answer · 2018-11-01 21:39:29Z

8

Assuming a model of:

class User(models.Model):
  name = models.CharField()
  phone_number = models.CharField()

Sending json of {"name":"Test User", "phone_number":"123-456-7890"}

In the view you could do the following to save it to the database.

def SaveUser(request):
  body_unicode = request.body.decode('utf-8')
  body = json.loads(body_unicode)
  u = User(**body)
  u.save()
  return JsonResponse({"result": "OK"})

answered Nov 1, 2018 at 21:39

Josh O'Bryan

3272 silver badges9 bronze badges

Comments

Hetvee Shah · Accepted Answer · 2022-12-20 17:45:04Z

3

If I understand your question clearly then Your view should be something like.

def add_comments(request):
    if 'application/x-www-form-urlencoded' in request.META['CONTENT_TYPE']:
        print 'hi'
        data = json.loads(request.body)
        comment = data.get('comment')
        id = data.get('id')
        title = data.get('title') 
        
        post = Post.objects.get(id = id)
        com = Comment()
        com. comments = comment
        com.title = post
        com.save()

edited Dec 20, 2022 at 17:45

Hetvee Shah

9810 bronze badges

answered Mar 21, 2016 at 5:45

burning

2,5966 gold badges26 silver badges41 bronze badges

2 Comments

Coeus Over a year ago

Thanks for reply...Yes this is what is required.........Is there a better way of storing data...instead of individually adding data......?

Yaser Khahani Over a year ago

(de)serializations in django

rprasad · Accepted Answer · 2017-08-10 16:39:40Z

3

If you want to store the intact JSON, try using the django-jsonfield project: https://github.com/dmkoch/django-jsonfield

answered Aug 10, 2017 at 16:39

rprasad

3763 silver badges9 bronze badges

Comments

hassanzadeh.sd · Accepted Answer · 2020-06-29 08:30:15Z

0

according to Django doc you can use :

from django.contrib.postgres.fields import JSONField
from django.db import models

class Dog(models.Model):
    name = models.CharField(max_length=200)
    data = JSONField()

    def __str__(self):
        return self.name

then create with this :

Dog.objects.create(name='Rufus', data={
     'breed': 'labrador',
     'owner': {
         'name': 'Bob',
         'other_pets': [{
             'name': 'Fishy',
         }],
     },
})

answered Jun 29, 2020 at 8:30

hassanzadeh.sd

3,5811 gold badge23 silver badges29 bronze badges

Collectives™ on Stack Overflow

Django saving json value to database/model

5 Answers 5

Update 2023

1 Comment

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Update 2023

1 Comment

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related