遍历项目列表并保存

Question

什么是更好的为什么要遍历这个项目列表并保存它

if cursor:

    for row in cursor:

        date = str(row[0])

        servicelevel = str(row[1])

        power = str(row[2])

        rebootime = str(row[3])

        result = str(row[4])

        result_two = str(row[5])

        moredata = str(row[6])

        data_Rows.append({'date': date, 'servicelevel': servicelevel, 'power': power, 'rebootime': rebootime,

                           'result': result, 'result_two': result_two, 'moredata': moredata})

Answer 1

您可以将字段名称字典用于行索引。例如：cursor = [(1, 2, 3), (4, 5, 6)]fields = { 'date' : 0 , 'servicelevel' : 1, 'power' : 2 }data_Rows = []for row in cursor:    data_Rows.append({ f : str(row[v]) for f, v in fields.items() })print(data_Rows)输出：[{'power': '3', 'servicelevel': '2', 'date': '1'}, {'power': '6', 'servicelevel': '5', 'date': '4'}]

Answer 2

您可以使用每行的列标题来使用构造函数zip为每一行创建一个字典：dictheaders = 'date', 'servicelevel', 'power', 'rebootime', 'result', 'result_two', 'moredata'data_Rows.extend(dict(zip(headers, map(str, row))) for row in cursor)

Answer 3

也许是这样：if cursor:    for row in cursor:        data_Rows.append({'date': str(row[0]), 'servicelevel': str(row[1]), 'power': str(row[2]), 'rebootime': str(row[3]),                           'result': str(row[4]), 'result_two': str(row[5]), 'moredata': str(row[6])})