[bos #40650][CEA 33012] Beta Law distribution: added a new type of distribution for...

[modules/smesh.git] / src / Tools / Verima / Base / tableTailles.py

diff --git a/src/Tools/Verima/Base/tableTailles.py b/src/Tools/Verima/Base/tableTailles.py
index c2763394f6392b8d09e0abab815b46c38b87d9cc..445af45685b09e6d5d4676d064269036a6006370 100644 (file)
--- a/src/Tools/Verima/Base/tableTailles.py
+++ b/src/Tools/Verima/Base/tableTailles.py
@@ -1,16 +1,35 @@
-from PyQt4 import QtSql, QtCore
-from tableDeBase import TableDeBase
+# Copyright (C) 2013-2024  EDF
+#
+# This library is free software; you can redistribute it and/or
+# modify it under the terms of the GNU Lesser General Public
+# License as published by the Free Software Foundation; either
+# version 2.1 of the License, or (at your option) any later version.
+#
+# This library is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# Lesser General Public License for more details.
+#
+# You should have received a copy of the GNU Lesser General Public
+# License along with this library; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA
+#
+# See http://www.salome-platform.org/ or email : webmaster.salome@opencascade.com
+#
+
+from qtsalome import QSqlQuery
+from Base.tableDeBase import TableDeBase
 
 class TableTailles (TableDeBase):
       def __init__(self):
           TableDeBase.__init__(self,"Tailles")
-          self.setField(('Maillage','Version','Machine','TailleMax','TailleMin','Quartile1','Mediane','Quartile3','Moyenne'))
-          self.setTypeField(('int','int','str','float','float','float','float','float','float'),('idMaillage','idVersion','Machine'))
+          self.setField(('Maillage','Version','TailleMax','TailleMin','Quartile1','Mediane','Quartile3','Moyenne'))
+          self.setTypeField(('int','int','str','float','float','float','float','float','float'),('idMaillage','idVersion'))
 
       def createSqlTable(self):
-          query=QtSql.QSqlQuery()
+          query=QSqlQuery()
 
-          texteQuery ="create table Tailles(idMaillage int, idVersion int, Machine varchar(10),"
+          texteQuery ="create table Tailles(idMaillage int, idVersion int, "
           texteQuery+="TailleMax float, TailleMin float, "
           texteQuery+="Q1 float, "
           texteQuery+="Mediane float, "
@@ -18,22 +37,20 @@ class TableTailles (TableDeBase):
           texteQuery+="Moyenne float, "
           texteQuery+="foreign key (idMaillage) references Maillages(id)," 
           texteQuery+="foreign key (idVersion) references Versions(id)," 
-          texteQuery+="foreign key (Machine) references Machines(nomMachine)," 
-          texteQuery+="primary key (idMaillage,idVersion,Machine));"
+          texteQuery+="primary key (idMaillage,idVersion));"
 
-          print "Creation de TableTailles : " , query.exec_(texteQuery)
+          print("Creation de TableTailles : " , query.exec_(texteQuery))
 
-      def getVal(self,idMaillage, idVersion, Machine, Entite):
-          query=QtSql.QSqlQuery()
+      def getVal(self,idMaillage, idVersion, Entite):
+          query=QSqlQuery()
           texteQuery ='select '+ str(Entite) + ' from Tailles where idMaillage='+str(idMaillage)
           texteQuery+=' and  idVersion='+str(idVersion)
-          texteQuery+=" and Machine='" + str(Machine) +"';"
           query.exec_(texteQuery)
           nb=0
           val=0                          # Valeur si l enregistrement n existe pas
           while (query.next()) :
-              val=query.value(0).toInt()[0]
+              val=query.value(0).toFloat()[0]
               nb=nb+1
-          if nb > 1 : print "Double valeur de Reference dans la table des mailles"
+          if nb > 1 : print("Double valeur de Reference dans la table des mailles")
           return val