Sql to python converter

Convert sql to python

# credit to Stack Overflow user in the source link
# NOTE: this is ust an example, you have to adapt the query and other stuff to your needs

import sqlite3
import json

query = """
{
    "ID": "4",
    "Name": "David",
    "Transformation": "SELECT ID || Name AS NewField FROM inputdata"
}"""

query_dict = json.loads(query)

db = sqlite3.Connection('mydb')
db.execute('create table inputdata ({} VARCHAR(100));'.format(' VARCHAR(100), '.join(query_dict.keys())))
db.execute('insert into inputdata ({}) values ("{}")'.format(','.join(query_dict.keys()),'","'.join(query_dict.values())))

r = db.execute(query_dict['Transformation'])
response = {}
response[r.description[0][0]] = r.fetchone()[0]

print(response)
>>> {'NewField': '4David'}

db.execute('drop table inputdata;')
db.close()

Source: stackoverflow.com

Similar codes

0 vote165 views1 answer
Python print every row of dataframe
Python
6 votes177 views4 answers
List iteration
Python
3 votes183 views2 answers
Count number of each item in list python
Python
15 votes344 views3 answers
Python flask sample application
Python Flask
14 votes165 views2 answers
How to print random in python
Python
28 votes166 views2 answers
Get a slice of string in python
Python
0 vote200 views2 answers
Apply butterworth filter python
Python
6 votes143 views1 answer
Unicodeencodeerror: 'charmap' codec can't encode characters in position 0-3: character maps to <undefined>
Python
3 votes194 views2 answers
Draw bounding box on image python cv2
Python
0 vote176 views1 answer
Windows python absolute path
Python