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

2 votes175 views1 answer
Discard vs remove python
Python
0 vote142 views1 answer
Triangle quest
Python
0 vote191 views2 answers
Python combine two lists into matrix
Python
1 vote184 views1 answer
Python turtle shooting game
Python
0 vote199 views1 answer
Aggregate the elements of each partition, and then the results for all the partitions
Python
0 vote190 views1 answer
Normal discord.py codes
Python
39 votes190 views5 answers
Csv to python
Python
2 votes210 views2 answers
Raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported') xlrd.biffh.XLRDError: Excel xlsx file; not supported
Python
0 vote178 views1 answer
Df max count syntax
Python
1 vote171 views1 answer
Python 2 print sep end
Python