1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
| # -*- coding: utf-8 -*-
import sqlite3, os, os.path
my_bdd = os.path.dirname(os.path.abspath(__file__))+'\local_data\mybdd.db'
#my_bdd = 'c:\mybdd.db'
#my_bdd = ":memory:"
if os.path.exists(my_bdd) == 1:
pass
else:
connection = sqlite3.connect("mybdd.db")
c = connection.cursor()
c.execute('''create table prpcalc(
key, chantier, dept, tn, dessus, fea, dfea, fed, dfed, fer,
dref, lref, nb_coude, debit, dem, nat_tuy_int, nat_rob, guidage, type_instal, dpr,
hpr, vupr, dn_int, L1cav, L2cav, hcav, ppe, qppe, hmtppe, pppe,
ippe, rppe, uppe, vppe, dppe, nb_ppe, secours, grille, panier, pelle,
clapet, vanne, dn_rob, cav, couv, vidange, h2s, brassage, agitateur, mano,
palan, treuil,com1, platine, coffret, dim_coffret, porte, cd, eclair, pc230,
pc24, telealarme, telegestion, debitmetre, dep_sup, balladeuse, detect, poires_sup, limiteur, verine,
com2, foudre)''')
connection.commit()
c.close()
connection.close()
def verif(key):
connection1 = sqlite3.connect(my_bdd)
c1 = connection1.cursor()
verif = []
c1.execute('SELECT * FROM prpcalc')
for row in c1 :
if row[0] == key:
verif.append('Erreur')
else: pass
return verif
connection1.commit()
c1.close()
connection1.close()
def sauv_prp(data):
connection1 = sqlite3.connect(my_bdd)
c1 = connection1.cursor()
data1 = [data]
for t in data1:
c1.execute('''insert into prpcalc values (
?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,
?,?)''', t)
connection1.commit()
c1.close()
connection1.close()
def rappel(choix, key):
connect = sqlite3.connect(my_bdd)
c2 = connect.cursor()
retour_data = []
c2.execute('SELECT * FROM ' + choix)
for row in c2 :
if row[0] == key:
#print row
for r in row:
retour_data.append(r)
c2.close()
connect.close()
return retour_data
def liste(choix):
connect = sqlite3.connect(my_bdd)
c2 = connect.cursor()
liste_projet = []
c2.execute('SELECT * FROM ' + choix)
for row in c2 :
liste = [row[2], row[1]]
liste_projet.append(liste)
c2.close()
connect.close()
return liste_projet
def delete(select):
connection1 = sqlite3.connect(my_bdd)
c1 = connection1.cursor()
c1.execute("delete from prpcalc where key = '%s'"%select)
connection1.commit()
c1.close()
connection1.close() |
Partager