How to store json in django mysql database by using python?

Question

Story BackGround:

I want to store json object in django mysql database by using python programming language. But I got an error.

Configuration:

OS: Ubuntu 12.04 64bits
Program language: python
Framework: django
database: mysql
objects need to be store: json

Code Reference:

json_objects={ u'name': u'REF_1', u'text': u'it is apple', u'time': u'20131210T120039Z'}

Code:

--> models.py

from django.db import models
class Messages(models.Model):
        id           = models.AutoField(primary_key=True)
        received     = models.DateTimeField(null=False)
        name         = models.TextField()
        data         = models.TextField()
        text         = models.TextField()
        word         = models.TextField()

        def __unicode__(self):
            return self.text

--> views.py

from threechannels.models import Messages
data_send_to_db=Messages.objects.create(received=datetime.strptime(json_objects["time"], "%Y%m%dT%H%M%SZ"),name=json_objects_post["name"],data=json_objects_dumps,text=json_objects["text"],word=related_words_hits)

The error I got:

DatabaseError: (1054, "Unknown column 'data' in 'field list'")

If I change the json_objects as objects=json.dumps(json_objects), I got another error which is: string indices must be a integer not a string. I think json_objects_post["name"] will cause this problem.

Any Tips??? Thank you so much.

is your database schema up to date? (have you run syncdb since you added the data field) ? — WayneC
– WayneC, Commented Jan 6, 2014 at 15:46

Ali B · Accepted Answer · 2014-01-06 18:35:02Z

1

To me it seems your json_objects is a simple python dictionary. So this is a valid operation:

received=datetime.strptime(json_objects["time"], "%Y%m%dT%H%M%SZ")

But this one is not:

name=json_objects_post["name"]

I am not sure what you are trying to achieve with the "_post" but you can use the python dictionary the way it is supposed to be used as:

name=json_objects["name"]

Also for the other fields:

data=json_objects

or

data=json.dumps(json_objects)

etc...

answered Jan 6, 2014 at 18:35

Ali B

4911 gold badge6 silver badges14 bronze badges

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

Comments

chengji18 · Accepted Answer · 2014-01-07 13:19:12Z

0

The original code:

data_send_to_db=Messages.objects.create(received=datetime.strptime(json_objects["time"], "%Y%m%dT%H%M%SZ"),name=json_objects_post["name"],data=json_objects_dumps,text=json_objects["text"],word=related_words_hits)

Changes:

data_send_to_db=Messages(received=datetime.strptime(json_objects["time"], "%Y%m%dT%H%M%SZ"),name=json_objects_post["name"],data=json_objects_dumps,text=json_objects["text"],word=related_words_hits)

And It works......

answered Jan 7, 2014 at 13:19

chengji18

9731 gold badge9 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to store json in django mysql database by using python?

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

Related