遍历项目列表并保存

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为每一行创建一个字典：dict

headers = '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])})