Python CSV SQL行未打印

Question

我试图将查询的结果写入每一列，但是当我运行我的“下面”脚本时，它的格式似乎是数据没有出现在显示所有行的列旁边

results = []
results2 = []
results3 = []
results4 = []
results5 = []
results6 = []

cur.execute(dbQuery)

results.extend(cur.fetchall())

cur.execute(dbQuery2)

results2.extend(cur.fetchall())

cur.execute(dbQuery3)

results3.extend(cur.fetchall())

cur.execute(dbQuery4)

results4.extend(cur.fetchall())

cur.execute(dbQuery5)

results5.extend(cur.fetchall())

cur.execute(dbQuery6)

results6.extend(cur.fetchall())


with open("out.csv", "wb") as csv_file:
    csv_writer = csv.writer(csv_file)
    csv_writer.writerow(['Query1', 'Query2', 'Query3', 'Query4', 'Query5', 'Query6'])
    csv_writer.writerow(results, results2, results3, results4, results5, results6)

Answer 1

您必须迭代所有查询的结果，然后需要编写CSV文件。我假设DB的所有结果如下所示

import csv

results = [1,2,3,4]
results2 = [11,12,13,14]
results3 = [21,22,23,24]
results4 = [31,32,33,34]
results5 = [41,42,43,44]
results6 = [51,52,53,54]

with open('out.csv', 'wb') as csv_file:
    csv_writer = csv.writer(csv_file)
    csv_writer.writerow(['Query1', 'Query2', 'Query3', 'Query4', 'Query5', 'Query6'])
    csv_writer.writerows(zip(*[results, results2, results3, results4, results5, results6]))