1 from qtsalome import QSqlQuery
2 from tableDeBase import TableDeBase
4 class TableMailles (TableDeBase):
6 TableDeBase.__init__(self,"Mailles")
7 self.setField(('Maillage','Version','Entite','NbEntite'))
8 self.setTypeField(('int','int','str','int'),('idMaillage','idVersion','Entite'))
11 def createSqlTable(self):
15 texteQuery ="create table Mailles(idMaillage int, idVersion int, Entite var(40), NbEntite int, "
16 texteQuery+="foreign key (idMaillage) references Maillages(id),"
17 texteQuery+="foreign key (idVersion) references Versions(id),"
18 texteQuery+="primary key (idMaillage,idVersion,Entite));"
20 print "Creation de TableMailles : " , query.exec_(texteQuery)
23 def getVal(self,idMaillage, idVersion, Entite):
25 texteQuery ='select NbEntite from Mailles where idMaillage='+str(idMaillage)
26 texteQuery+=' and idVersion='+str(idVersion)
27 texteQuery+=" and Entite='" + str(Entite) +"';"
28 query.exec_(texteQuery)
30 val=0 # Valeur si l enregistrement n existe pas
31 while (query.next()) :
32 val=query.value(0).toInt()[0]
34 if nb > 1 : print "Double valeur de Reference dans la table des mailles"
38 def getAllEntity(self):
40 texteQuery ="select distinct Entite from Mailles;"
41 query.exec_(texteQuery)
43 while (query.next()) :
44 maListe.append(str(query.value(0).toString()))