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

-1 vote320 views1 answer
Percent chart seaborn
Python
1 vote321 views1 answer
Numpy array heaviside float values to 0 or 1
Python
0 vote351 views1 answer
Django voice lib
Python
2 votes350 views1 answer
DEPRECATION: The default format will switch to columns in the future. You can use --format=(legacy|columns) (or define a format=(legacy|columns) in your pip.conf under the [list] section) to disable this warning.
Python
1 vote332 views1 answer
Pandas column rank
Python
0 vote316 views2 answers
Python defualt error handler
Python
0 vote369 views1 answer
Qaction hide show python
Python
1 vote366 views1 answer
A0 = dict(zip(('a','b','c','d','e'),(1,2,3,4,5)))
Python
1 vote350 views4 answers
Get python script path
Python
23 votes427 views6 answers
How to combine two lists in python
Python