1 from PyQt4 import QtSql, QtCore
2 from tableDeBase import TableDeBase
5 class TableMachines (TableDeBase):
7 TableDeBase.__init__(self,"Machines")
8 self.setField(("nomMachine","Os"))
9 self.setTypeField(('str','str'),('nomMachine'))
11 def createSqlTable(self):
12 query=QtSql.QSqlQuery()
13 print "creation de TableMachine : ", query.exec_("create table Machines( nomMachine varchar(10) primary key, os varchar(10));")
15 def creeMachine(self):
16 nomMachine=os.uname()[1]
18 self.insereLigne((nomMachine,nomOs))
20 def chercheMachine(self):
21 query=QtSql.QSqlQuery()
23 texteQuery ="select nomMachine from Machines where nomMachine ='" + machine +"' ;"
24 query.exec_(texteQuery)
28 nom=str(query.value(0).toString())
29 if nb != 1 : return 0, ""