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