Python Sqlite3 Returning query results as a dictionary method introduction

The sqlite3 itself does not provide a cursor in the form of a dictionary as native as Pymysql.

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

But the official document has been reserved for the corresponding implementation plan.

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

Use this function instead of the Conn.raw_factory attribute.

def dict_factory (cursor, row):      d = {}      for idx, col in Enumerate (cursor.description):          d[col[0]] = row[idx]
  return d  con = Sqlite3.connect (": Memory:") #打开在内存里的数据库con. row_factory = Dict_factorycur = Con.cursor () Cur.execute ("Select 1 as a") print Cur.fetchone () ["a"]