ZhangZhihui's Blog  
复制代码
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
复制代码

 

posted on   ZhangZhihuiAAA  阅读(66)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 震惊!C++程序真的从main开始吗?99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码?零基础破解AI编程运行原理
· 单元测试从入门到精通
· 上周热点回顾(3.3-3.9)
· winform 绘制太阳,地球,月球 运作规律
 
点击右上角即可分享
微信分享提示