def getVMinfo(self, name): _vmList = list() _rows = self.__conn.execute \ ( \ "SELECT \ name, \ createdate, \ lifetimedays, \ comment, \ mail, \ image_file, \ owner, \ os \ FROM vmachine \ WHERE \ name = '" + name + "';" \ ) for _row in _rows: name, createdate, lifetimedays, comment, mail, image_file, owner, os = _row _vmInfo = VMinfo() _vmInfo.name = name _vmInfo.createdate = createdate _vmInfo.lifetimedays = lifetimedays _vmInfo.comment = comment _vmInfo.mail = mail _vmInfo.image_file = image_file _vmInfo.owner = owner _vmInfo.os = os _vmList.append(_vmInfo) return _vmList[0]
def reConfigureVM(self): print "[reConfigureVM...]" _result = "" _vmInfo = VMinfo() _vmInfo.name = str(self.vmNameLineEdit.text()) _vmInfo.lifetimedays = str(self.lifeTimeSpinBox.value()) _vmInfo.comment = unicode(self.commentLineEdit.text(), "utf-8") _vmInfo.mail = str(self.mailLineEdit.text()) _vmInfo.owner = unicode(self.__vmOwnerLineEdit.text(), "utf-8") try: self.__vmInfoDB.updateVMinfo(_vmInfo) except sqlite3.Error, e: infotext = "An error occurred:", e.args[0] QtGui.QMessageBox.critical(self, "Error",str(infotext)) return