mercredi 6 avril 2016

Python SQLITE 3 INSERT INTO not working

I have this python script, when I run it I have no error but my database is always empty...

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()

`

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire