mcescalante

import sqlite3
import json

conn = sqlite3.connect('test.db')
c = conn.cursor()

# Insert values
c.execute('''insert into data values(?)''', (json.dumps({'test':'test2'}),))
conn.commit()

mcescalante

import sqlite3
import json

conn = sqlite3.connect('test.db')
c = conn.cursor()

# Insert {'test':'test2'} dummy values into database
c.execute('''insert into data values(?)''',(json.dumps({'test':'test2'}),))
conn.commit()

mcescalante

# Select those values, get them to be json
c.execute('select * from data')
data = c.fetchall()
print data
# Data will print: [(u'{"test": "test2"}',)]
# To load the JSON for python use
for item in data:
  print json.loads(item[0])
# Data will print: {u'test': u'test2'}