Decoding json into SQL in python. Asked by https://www.facebook.com/wintang.murtiari

example.py

import json

# this is your json
my_json_data = '{"nick_name" : "Annakin", "family_name" : "Skywalker"}'

# this is the decoded json
my_data = json.loads(my_json_data)

# sql command
sql = "INSERT INTO tbl(nick_name, family_name) VALUES('"+my_data["nick_name"]+"', '"+my_data["family_name"]+"')"

# make connection and cursor
import sqlite3
conn = sqlite3.connect("db/pokemon.db") # or use :memory: to put it in RAM
cursor = conn.cursor()
# run the sql command
cursor.execute(sql)

thank you frendi !