回答編集履歴

コードをテキストで貼ったのを修正しました。

2020/08/06 07:20

投稿

スコア73

answer CHANGED Viewed

@@ -1,11 +1,16 @@
+```ここに言語を入力
+import csv
+import sqlite3
 conn = sqlite3.connect('./temp/test.db')
 c = conn.cursor()
-with open ('./temp/rawdata_sorted2.csv',"w",newline='',  encoding="utf-8") as f_handle:
-       writer = csv.writer(f_handle)
-       header = [ 'KB','VIN_NUM','MODEL_CD','DATA_YMD','M2M_REPORT_ID','M2M_REPORT_ID_SUB','M2M_REPORT_ROW_ID','M2M_REPORT_COL_ID','CALC_VAL']
-       writer.writerow(header)
-       for row in c.execute('SELECT * FROM test ORDER BY VIN_NUM ASC'):
-           writer.writerow(row)
-conn.close()
+with open ('./temp/rawdata_sorted.csv',"w",newline='', encoding="utf-8") as f_handle:
+    writer = csv.writer(f_handle)
+    header = [ 'KB','VIN_NUM','MODEL_CD','DATA_YMD','M2M_REPORT_ID','M2M_REPORT_ID_SUB','M2M_REPORT_ROW_ID','M2M_REPORT_COL_ID','CALC_VAL']
+    writer.writerow(header)
+    for row in c.execute('SELECT * FROM hoge ORDER BY VIN_NUM ASC,MODEL_CD ASC,DATA_YMD ASC,M2M_REPORT_ID ASC,M2M_REPORT_ID_SUB ASC,M2M_REPORT_ROW_ID ASC,M2M_REPORT_COL_ID ASC,M2M_REPORT_COL_ID ASC,CALC_VAL ASC'):
+        writer.writerow(row)
+conn.close()
+```