1 from qtsalome import QSqlQuery
2 from Base.tableDeBase import TableDeBase
4 class TableVersions (TableDeBase):
6 TableDeBase.__init__(self,"Versions")
7 self.setField(("id","nomVersion","commentaire"))
8 self.setTypeField(('int','str','str'),('id',))
9 self.cols=" (nomVersion, commentaire) "
11 def createSqlTable(self):
13 texteQuery ="create table Versions(id integer primary key autoincrement, nomVersion varchar(10),"
14 texteQuery+="commentaire varchar(30));"
15 print("Creation de TableVersions : " , query.exec_(texteQuery))
19 self.insereLigneAutoId(('Salome7.2.0',''))
20 self.insereLigneAutoId(('Salome7.3.0',''))
21 self.insereLigneAutoId(('Salome7.4.0',''))
23 def creeVersion(self,version,commentaire=""):
24 self.insereLigneAutoId((version,commentaire))
27 def chercheVersion(self,version):
30 if bool(version) == True :
31 texteQuery ="select id, nomVersion from Versions where id = " + str(version) +";"
33 texteQuery ="select id, nomVersion from Versions where nomVersion ='" + version +"' ;"
34 query.exec_(texteQuery)
38 id=query.value(0).toInt()[0]
39 nom=query.value(1).toString()
40 if nb != 1 : return 0, 0, ""