#!/usr/bin/python

import sys, os, sqlite3
from time import strftime, localtime
sys.path.insert(0, '/home/pi/ADC/1x15/')
from CO2 import co2

if os.path.isfile("valeur.sqlite"):
        print "La BDD existe :"
        con = sqlite3.connect("valeur.sqlite")
        con.isolation_level = None
        cur = con.cursor()

        Time = strftime("%H:%M:%S", localtime())

        cur.execute('INSERT INTO CO2 VALUES (?,?)', (Time,co2()))

        cur.execute("SELECT * FROM CO2")
        for l in cur:
                print(l)

        con.commit()
        con.close()
else:
        print "BDD inexistante, creation"
        con = sqlite3.connect("valeur.sqlite")
        con.isolation_level = None
        cur = con.cursor()

        cur.execute("CREATE TABLE CO2 (time TEXT, qty REAL)")

        con.commit()
        con.close()