def get_json(csr):
data = csr.fetchall()
fields = csr.description
columns = []
for field in fields:
columns.append(field[0])
results = []
for row in data:
result = {}
for idx, data in enumerate(row):
result[columns[idx]] = data
results.append(result)
return json.dumps(results)