def convert_sqlite_row_to_dict(row, n: int): """ Convert a single row of rows returned by a select query of sqlite3. :param row: :param n: The number of the first n columns those are grouped by. :return: """ row_dict = {} for i in range(n - 1, -1, -1): if i == n - 1: tmp_dict = {f'{row[i]}': row[i+1:]} else: tmp_dict = {f'{row[i]}': tmp_dict} update_dict_cascade(row_dict, tmp_dict) return row_dict def convert_sqlite_rows_to_dict(rows: list, n: int): """ Convert a list of rows returned by a select query of sqlite3. :param rows: :param n: The number of the first n columns those are grouped by. :return: """ rows_dict = {} for i, row in enumerate(rows): row_dict = convert_sqlite_row_to_dict(row, n) update_dict_cascade(rows_dict, row_dict) return rows_dict
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 震惊!C++程序真的从main开始吗?99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码?零基础破解AI编程运行原理
· 单元测试从入门到精通
· 上周热点回顾(3.3-3.9)
· winform 绘制太阳,地球,月球 运作规律