1 # Copyright (C) 2013-2019 CEA/DEN, EDF R&D
3 # This library is free software; you can redistribute it and/or
4 # modify it under the terms of the GNU Lesser General Public
5 # License as published by the Free Software Foundation; either
6 # version 2.1 of the License, or (at your option) any later version.
8 # This library is distributed in the hope that it will be useful,
9 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11 # Lesser General Public License for more details.
13 # You should have received a copy of the GNU Lesser General Public
14 # License along with this library; if not, write to the Free Software
15 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
17 # See http://www.salome-platform.org/ or email : webmaster.salome@opencascade.com
20 from qtsalome import QSqlQuery
21 from Base.tableDeBase import TableDeBase
23 class TableMaillages (TableDeBase):
25 TableDeBase.__init__(self,"Maillages")
26 self.setField(("id","nomMaillage","Script","fichier","idMailleur","Dimension","Seuil CPU","Seuil Ratio","Seuil Taille","Seuil Nb Maille","Commentaire"))
27 self.cols="(nomMaillage,nomScript,medResultat,idMailleur,dimension,seuilCPU,seuilRatio,seuilTaille,seuilNbMaille,commentaire)"
28 self.setTypeField(('int','str','str','str','int','int','int','int','int','int','str'),('id'))
30 def createSqlTable(self):
32 texteQuery ="create table Maillages(id integer primary key autoincrement, nomMaillage varchar(10), "
33 texteQuery+="nomScript varchar(40), medResultat varchar(15), idMailleur int, dimension int,"
34 texteQuery+="seuilCPU int, seuilRatio int, seuilTaille int, seuilNbMaille int, commentaire varchar(60), "
35 texteQuery+="foreign key (idMailleur) references Mailleur(id));"
36 print("creation de TableMaillages : " , query.exec_(texteQuery))
38 def getVal(self,idMaillage, nomChamp):
41 texteQuery ='select '+ nomChamp + ' from Maillages where id=' + str(idMaillage) + ";"
42 query.exec_(texteQuery)
43 while (query.next()) :
44 valeur=query.value(0).toInt()[0]
45 while (query.next()) :
46 print("plusieurs enregistrements dans Maillages pour ",str(idMaillage))
50 def dejaRemplie(self):
51 texteQuery="select * from Maillages where medResultat='/tmp/tetra.med';"
53 maQuery.exec_(texteQuery)
55 while(maQuery.next()): nb=nb+1
59 if self.dejaRemplie():
60 print("table Maillage deja initialisee")
62 # self.insereLigneAutoId(('Fiche_7566_TUNNEL', '/home/H77945/CAS_TEST/MAILLEUR/FICHE_7566_TUNNEL/Fiche_7566_TUNNEL.py', '/tmp/Fiche_7566_TUNNEL.med', 3,3,10,10,10,10, 'Maillage d un tunnel'))
63 # self.insereLigneAutoId(('Fiche_7957_AILETTE', '/home/H77945/CAS_TEST/MAILLEUR/FICHE_7957_AILETTE/Fiche_7957_AILETTE.py', '/tmp/Fiche_7957_AILETTE.med', 1,2,10,10,10,10, 'Maillage d une attache d aillette'))
65 def construitListeMaillages(self):
67 texteQuery="select id, nomScript,medResultat from Maillages;"
68 maQuery.exec_(texteQuery)
70 while(maQuery.next()):
71 listeMaillages.append((maQuery.value(0).toInt()[0], maQuery.value(1).toString(), maQuery.value(2).toString()))
74 def verifieListeMaillages(self,listeMaillage):
77 for idM in listeMaillage:
78 texteQuery="select id, nomScript,medResultat from Maillages where id = " + str(idM) +';'
79 maQuery.exec_(texteQuery)
81 while(maQuery.next()):
83 newListeMaillages.append((maQuery.value(0).toInt()[0], maQuery.value(1).toString(), maQuery.value(2).toString()))
85 print("impossible de traiter le maillage : ", idM)
86 return newListeMaillages
88 def getSeuilsPourMaillage(self,idMaillage):
89 texteQuery="select id,nomMaillage,seuilCPU,seuilRatio,seuilTaille,seuilNbMaille from Maillages where id = "+ str(idMaillage) +" ;"
91 maQuery.exec_(texteQuery)
92 while(maQuery.next()):
93 l1 = maQuery.value(0).toInt()[0]
94 l2 = maQuery.value(1).toString()
95 l3 = maQuery.value(2).toInt()[0]
96 l4 = maQuery.value(3).toInt()[0]
97 l5 = maQuery.value(4).toInt()[0]
98 l6 = maQuery.value(5).toInt()[0]
99 return l1,l2,l3,l4,l5,l6
102 maillagesIdListe=[]; maillagesNomListe=[]
103 texteQuery="select id,nomMaillage from Maillages order by id;"
105 maQuery.exec_(texteQuery)
106 while(maQuery.next()):
107 maillagesIdListe.append( maQuery.value(0).toInt()[0])
108 maillagesNomListe.append( maQuery.value(1).toString())
109 return maillagesIdListe, maillagesNomListe
111 def getMailleurId(self,idMaillage):
112 texteQuery="select idMailleur from Maillages where id = "+ str(idMaillage) +" ;"
115 print(maQuery.exec_(texteQuery))
116 maQuery.exec_(texteQuery)
117 while(maQuery.next()):
118 idMailleur = maQuery.value(0).toInt()[0]