【python 问题解决】 ---- sqlite 查询数据返回的是元组，转换为字典

  # 数据转字典
  def dict_factory(self, cursor, row):
    data = {}
    for idx, col in enumerate(cursor.description):
      data[col[0]] = row[idx]
    return data

  # 查询数据
  def query(self,sql):
    with self.con:
      self.con.row_factory = self.dict_factory
      self.cur = self.con.cursor()
      self.cur.execute(sql)
      rows = self.cur.fetchall()
      return rows