azLQb7X6

1import hashlib
2import sqlite3
3# retourne l'exadecimal sha256 d'un text passer en parramettre
4def f_exa(fv_text):
5    return hashlib.sha256(fv_text).hexdigest()
6
7# connection a la base
8def f_dbconnect(fv_name_database):
9    conn = sqlite3.connect(fv_name_database)
10    return conn.cursor()
11
12# Insertion d une donnee
13def f_insert_exa_text(fv_exa, fv_text,cursor):
14    cursor.execute("""
15    CREATE TABLE IF NOT EXISTS T_EXA(c_exa TEXT UNIQUE,c_textoriginale TEXT UNIQUE)
16    """)
17# Ecriture
18def f_write_db():
19    conn.commit()
20
21def f_Programe_principal():
22    print "Demarrage"
23    conn=f_dbconnect("ma_base.db")
24    v_montexte="A"
25    f_insert_exa_text(f_exa(v_montexte),v_montexte,vRet_db)
26    f_write_db()
27    print "terminer"
28
29f_Programe_principal()