Advertisement
Guest User

Untitled

a guest
Mar 24th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.43 KB | None | 0 0
  1. class SqlExecutor:
  2.     def dictfetchall(self, cursor):
  3.         # "Return all rows from a cursor as a dict"
  4.         columns = [col[0] for col in cursor.description]
  5.         return [
  6.             dict(zip(columns, row))
  7.             for row in cursor.fetchall()
  8.         ]
  9.  
  10.     def execute(self, sql):
  11.         with connection.cursor() as c:
  12.             c.execute(sql)
  13.             rows = self.dictfetchall(c)
  14.             return rows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement