python fieldnames_python – ValueError：dict包含不在fieldnames中的字段

有人可以帮我弄这个吗.

我有我的Select查询

selectAttendance = """SELECT * FROM table """

我想要我的选择查询的内容,并在下载csv文件时包含一个标题,

所以我做了这个查询：

with open(os.path.join(current_app.config['UPLOAD_FOLDER'], 'csv.csv'), 'wb') as csvfile:

writer = csv.DictWriter(csvfile,fieldnames = ["Bio_Id","Last_Name","First_Name","late","undertime","total_minutes", "total_ot", "total_nsd", "total_absences"], delimiter = ';')

writer.writeheader()

writer.writerow(db.session.execute(selectAttendance))

db.session.commit()

但它给了我这个错误

**ValueError: dict contains fields not in fieldnames**

我想在我下载的csv文件中输出这个输出：

Bio_Id Last_Name First_Name late undertime total_minutes total_ot total_nsd total_absences

1 Joe Spark 1 1 2 1 1 1

先谢谢你.