sql to dict

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
def sqltodict(query,param):
    from django.db import connection
    cursor = connection.cursor()
    cursor.execute(query,param)
    fieldnames = [name[0] for name in cursor.description]
    result = []
    for row in cursor.fetchall():
        rowset = []
        for field in zip(fieldnames, row):
            rowset.append(field)
        result.append(dict(rowset))
    return result

More like this

  1. executesql by amitu 2 years, 10 months ago
  2. sqltojson by amitu 2 years, 10 months ago
  3. html helpers for images and links by buriy 4 years, 4 months ago
  4. Choices helper by jacobian 2 years, 6 months ago
  5. Dom ID by bmihelac 2 years, 2 months ago

Comments

(Forgotten your password?)