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 votes258 views1 answer
Pychamrfind and replace
Python
3 votes258 views2 answers
What day i s it
Python
0 vote172 views1 answer
Dictionary increment
Python
0 vote201 views1 answer
Assert_series_equal
Python
1 vote215 views1 answer
How to slice dataframe based on daterange in pandas
Python
8 votes205 views2 answers
Discord python get member object by id
Python
3 votes190 views2 answers
Python use variable in another file
Python
0 vote307 views1 answer
Lipa na mpesa daraja python
Python
11 votes235 views2 answers
How to add static files in django
Python Django
19 votes187 views1 answer
Python substring from end
Python