Python Sqlite3 How to return query results in a dictionary _python

The sqlite3 itself does not natively provide a dictionary-like cursor as pymysql.

cursor = conn.cursor (pymysql.cursors.DictCursor)

But the official document has already reserved the corresponding implementation plan.

def dict_factory (cursor, row): 
  d = {} 
  for idx, col in Enumerate (cursor.description): 
    d[col[0]] = Row[idx] 
  

Use this function instead of the Conn.raw_factory property.

con = Sqlite3.connect (": Memory:") #打开在内存里的数据库
con.row_factory = dict_factory
cur = con.cursor ()
Cur.execute ("Select 1 as a")
print Cur.fetchone () ["a"]

Official Document Links

The above is a small series for everyone to bring Python Sqlite3 in the dictionary form to return the results of the implementation of the query all the content, I hope that we support cloud Habitat Community ~