1 from PyQt4 import QtSql, QtCore
2 from tableDeBase import TableDeBase
4 class TableGroupes (TableDeBase):
6 TableDeBase.__init__(self,"Groupes")
7 self.setField(('Groupe','Maillage','Version','Entite','NbEntite'))
8 self.setTypeField(('str','int','int','str','int'),('nomGroupe','idMaillage','idVersion','Entite'))
11 def createSqlTable(self):
12 query=QtSql.QSqlQuery()
15 texteQuery ="create table Groupes( nomGroupe varchar(40),idMaillage int, idVersion int,"
16 texteQuery+="Entite var(40), NbEntite int,"
17 texteQuery+="foreign key (idMaillage) references Maillages(id),"
18 texteQuery+="foreign key (idVersion) references Versions(id),"
19 texteQuery+="primary key (nomGroupe,idMaillage,idVersion,Entite));"
21 print "Creation de TableGroupes : ", query.exec_(texteQuery)
24 def getVal(self,nomGroupe,idMaillage,idVersion,typeMaille):
25 val=0 # Valeur si l enregistrement n existe pas
26 query=QtSql.QSqlQuery()
27 texteQuery ='select NbEntite from Groupes where nomGroupe ="' + nomGroupe +'"'
28 texteQuery +=' and idMaillage=' + str(idMaillage)
29 texteQuery +=' and idVersion = ' + str(idVersion)
30 texteQuery +=' and Entite ="' + str(typeMaille) + '";'
31 query.exec_(texteQuery)
32 while (query.next()) :
33 val=query.value(0).toInt()[0]
34 while (query.next()) :
35 print "plusieurs enregistrements dans groupe pour ", nomGroupe," ",str(idMaillage)," ",str(idVersion),"\n"
39 def getAllEntity(self):
40 query=QtSql.QSqlQuery()
41 texteQuery ="select distinct Entite from Groupes;"
42 query.exec_(texteQuery)
44 while (query.next()) :
45 maListe.append(str(query.value(0).toString()))