insert json into mysql. json string is obtained from json.dumps

Question

The problem is with inserting json strings into MySQL database. In my python program I obtain json as a result of json.dumps(d) where d is a dictionary. Inserting code is:

        query = ("INSERT INTO bm_triesJsons VALUES (%s, %s, %s);"%
                 (article_id, revision_number, jsn))
        print query
        cur.execute(query)

It looks like the problem is quotes, there is no escape symbol in front of quotes. How can I fix this?

jdi · Accepted Answer · 2012-07-16 04:33:53Z

4

Use the parameterized approach to values when doing a query. The driver will handle escapes:

query = "INSERT INTO bm_triesJsons VALUES (%s, %s, %s);"
cur.execute(query, (article_id, revision_number, jsn))

If you want direct and manual access to the escape function MySQLdb uses, you can do it like this:

c = MySQLdb.connection()
print c.escape_string('{"foo":"bar"}')
# {\"foo\":\"bar\"}

answered Jul 16, 2012 at 4:33

jdi

93k20 gold badges174 silver badges208 bronze badges

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

Collectives™ on Stack Overflow

insert json into mysql. json string is obtained from json.dumps

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related