Python SQLITE 3插入不工作

Question

我有这个python脚本，当我运行它时，我没有错误，但我的数据库总是空的。。。你知道吗

import sqlite3
import subprocess

conn = sqlite3.connect('stockage.db')
cursor = conn.cursor()

filename = '../Collecteur/collecteur_cpu_reseau.txt'
proc_name = subprocess.check_output(["sed","-n",r"1p",filename])
proc_freq = subprocess.check_output(["sed","-n",r"2p",filename])
proc_core = subprocess.check_output(["sed","-n",r"3p",filename])
proc_hyperthreading = subprocess.check_output(["sed","-n",r"4p",filename])
proc_architecture = subprocess.check_output(["sed","-n",r"5p",filename])
proc_cache_L1 = subprocess.check_output(["sed","-n",r"6p",filename])
proc_cache_L2 = subprocess.check_output(["sed","-n",r"7p",filename])
proc_cache_L3 = subprocess.check_output(["sed","-n",r"8p",filename])
proc_virtualisation = subprocess.check_output(["sed","-n",r"9p",filename])
proc_load_average = subprocess.check_output(["sed","-n",r"10p",filename])
ip_infos_addr_ipv4 = subprocess.check_output(["sed","-n",r"11p",filename])
ip_infos_addr_ipv6 = subprocess.check_output(["sed","-n",r"12p",filename])
ip_publique_addr = subprocess.check_output(["sed","-n",r"13p",filename])
carte_reseau = subprocess.check_output(["sed","-n",r"14p",filename])

cursor.execute("""
INSERT INTO sonde_cpu_reseau(proc_name,proc_freq,proc_core,proc_hyperthreading,proc_architecture,proc_cache_L1,proc_cache_L2,proc_cache_L3,proc_virtualisation,proc_load_average,   ip_infos_addr_ipv4,ip_infos_addr_ipv6,ip_publique_addr,carte_reseau) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)""",(proc_name,proc_freq,proc_core,proc_hyperthreading,proc_architecture,proc_cache_L1,proc_cache_L2,proc_cache_L3,proc_virtualisation,proc_load_average,
    ip_infos_addr_ipv4,ip_infos_addr_ipv6,ip_publique_addr,carte_reseau))
conn.commit()

`

提前谢谢