X-Git-Url: http://git.salome-platform.org/gitweb/?p=modules%2Fsmesh.git;a=blobdiff_plain;f=src%2FTools%2FVerima%2FBase%2FtablePerfs.py;h=a69d6f8eb29e422b95c36bed6520dcf9f087d685;hp=8707711d63b1f3ddbd514c499edf05f7947747ed;hb=HEAD;hpb=2d16118826a6b7874b3093ed11284cfbb30a5efa diff --git a/src/Tools/Verima/Base/tablePerfs.py b/src/Tools/Verima/Base/tablePerfs.py index 8707711d6..9fa9fe5e9 100644 --- a/src/Tools/Verima/Base/tablePerfs.py +++ b/src/Tools/Verima/Base/tablePerfs.py @@ -1,5 +1,24 @@ -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 TablePerfs (TableDeBase): def __init__(self): @@ -8,17 +27,17 @@ class TablePerfs (TableDeBase): self.setTypeField(('int','int','str','int','int'),('idMaillage','idVersion','Machine')) def createSqlTable(self): - query=QtSql.QSqlQuery() + query=QSqlQuery() texteQuery ="create table Perfs(idMaillage int, idVersion int, Machine varchar(10), NbCpu int, Mem int, " 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));" - print "Creation de TablePerfs : " , query.exec_(texteQuery) + print("Creation de TablePerfs : " , query.exec_(texteQuery)) def getVal(self,idMaillage,idVersion,Machine): - query=QtSql.QSqlQuery() + query=QSqlQuery() texteQuery ='select NbCpu from Perfs where idMaillage=' + str(idMaillage) texteQuery +=' and idVersion = ' + str(idVersion) texteQuery +=" and Machine ='" + Machine + "';" @@ -27,7 +46,7 @@ class TablePerfs (TableDeBase): while (query.next()) : cpu=query.value(0).toInt()[0] while (query.next()) : - print "plusieurs enregistrements dans perf pour ",str(idMaillage)," ",str(idVersion)," ",Machine + print("plusieurs enregistrements dans perf pour ",str(idMaillage)," ",str(idVersion)," ",Machine) if cpu==None : - print "pas d enregistrement dans perf pour ",str(idMaillage)," ",str(idVersion)," ",Machine + print("pas d enregistrement dans perf pour ",str(idMaillage)," ",str(idVersion)," ",Machine) return cpu