1 from PyQt4 import QtSql, QtCore
2 from 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):
12 query=QtSql.QSqlQuery()
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):
28 query=QtSql.QSqlQuery()
30 if QtCore.QString(version).toInt()[1]==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, ""