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 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
