# exemple de création d'un base contenant des données meteo aléatoires

import sqlite3 as lite
import sys
import time
import random

bdd = lite.connect('DummyBase.db')

cur = bdd.cursor()
cur.execute("DROP TABLE IF EXISTS Data")
cur.execute("CREATE TABLE Data(Idx INT, Heu INT, Min INT, Sec INT, Temp INT, Pression INT, Vent INT, Humidite INT, Ville TEXT)")

debut = time.time()
debut = (int)(debut)

index=random.randint(0,20);
ville=['Toulon','St Mandrier','La Ciotat','Brignoles']

while(time.time()<debut+30) :

        tem = random.randint(27,34)
        pre = random.randint(1005,1012)
        ven = random.randint(0,20)
        hum = random.randint(40,70)
        
        print("ecriture d'une entrée dans la base")
        req = "INSERT INTO Data VALUES("+str(index)+","+\
            time.strftime("%H,%M,%S,") + str(tem) + "," + str(pre) +","\
            + str(ven) + "," + str(hum) + ",'" + ville[random.randint(0,3)]\
            + "')"
        print(req)
        cur.execute(req)
        bdd.commit()
        index=index+1
        time.sleep(0.25)

print("fin")
#~ 
#~ 
bdd.commit()

#quelques vérifications
cur.execute("PRAGMA table_info(Data)")
data = cur.fetchall()
print(data)

cur.execute('SELECT * FROM Data')
data = cur.fetchall()
print(data)