import sqlite3
print("sqlite3.version",sqlite3.version)
print("sqlite3.sqlite_version",sqlite3.sqlite_version)

import Main

# Crée la table si non existante
def HV_Data():
    con = sqlite3.connect("HV.db")
    cur = con.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS HV (id INTEGER PRIMARY KEY, HV_Nom TEXT,  HV_INSI INTEGER,  HV_IODE INTEGER,  HV_KHO INTEGER,  HV_NaOH REAL)")
    con.commit()
    con.close()

# Charge table par ordre alphabétic sur le champ [HV_Nom]
def loadRecord():
    con = sqlite3.connect("HV.db")
    cur = con.cursor()
    cur.execute("SELECT id, HV_Nom, HV_INSI, HV_IODE, HV_KHO, HV_NaOH FROM HV ORDER BY HV_Nom ASC")
    mData = cur.fetchall()
    print("Nombre d'enregistrement _ lecture Table", len(mData))
    con.close()
    return mData


HV_Data()