def __init__(self, name): QtGui.QDialog.__init__(self) self.ui = Ui_change_username() self.ui.setupUi(self) self.name = name self.ui.change_btn.clicked.connect(self.update) self.ui.cancel_btn.clicked.connect(self.close)
def __init__(self, name): QtGui.QDialog.__init__(self) self.ui = Ui_change_username() self.ui.setupUi(self) self.name = name; self.ui.change_btn.clicked.connect(self.update) self.ui.cancel_btn.clicked.connect(self.close)
class username_window(QtGui.QDialog): def __init__(self, name): QtGui.QDialog.__init__(self) self.ui = Ui_change_username() self.ui.setupUi(self) self.name = name; self.ui.change_btn.clicked.connect(self.update) self.ui.cancel_btn.clicked.connect(self.close) def update(self): # if cannot connect to database showing error window if not self.conn(): QtGui.QMessageBox.warning( self, 'Error', 'database contecting error') # get username and password from gui self.input_name = self.ui.userLineEdit.text() self.input_newName = self.ui.newUserLineEdit.text() self.input_confirm = self.ui.confirmLineEdit.text() self.checkQuery = QSqlQuery() self.checkQuery.exec_("Select User_password From Account Where User_name = '%s'"\ % (self.name)) if self.checkQuery.next(): record = self.checkQuery.record() self.confirm = str(record.value(0)) #check for password confirmation if self.confirm != self.input_confirm: QtGui.QMessageBox.warning( self, 'Error', "Incorrect Password") self.ui.userLineEdit.clear() self.ui.newUserLineEdit.clear() self.ui.confirmLineEdit.clear() elif self.input_newName == "": QtGui.QMessageBox.warning( self, 'Error', "Please enter a new username") self.ui.userLineEdit.clear() self.ui.newUserLineEdit.clear() self.ui.confirmLineEdit.clear() elif self.input_name != self.name: QtGui.QMessageBox.warning( self, 'Error', "Please enter your username") self.ui.userLineEdit.clear() self.ui.newUserLineEdit.clear() self.ui.confirmLineEdit.clear() else: # make changes change_query = QSqlQuery() change_query.exec_("Update Account SET User_name ='%s' WHERE User_name = '%s'" \ %(self.input_newName, self.input_name)) self.default_msg = "Username Changed" self.default_reply = QtGui.QMessageBox.information(self, 'Change Username', self.default_msg, QtGui.QMessageBox.Ok) self.accept(); def getName(self): return self.input_newName # set up database connection def conn(self): self.db = QSqlDatabase.addDatabase("QMYSQL") self.db.setHostName("services1.mcs.sdsmt.edu") self.db.setDatabaseName("db_dancesoft_f15") self.db.setUserName("dancesoft_f15") self.db.setPassword("DanceSoft") return self.db.open()
class username_window(QtGui.QDialog): def __init__(self, name): QtGui.QDialog.__init__(self) self.ui = Ui_change_username() self.ui.setupUi(self) self.name = name self.ui.change_btn.clicked.connect(self.update) self.ui.cancel_btn.clicked.connect(self.close) def update(self): # if cannot connect to database showing error window if not self.conn(): QtGui.QMessageBox.warning(self, 'Error', 'database contecting error') # get username and password from gui self.input_name = self.ui.userLineEdit.text() self.input_newName = self.ui.newUserLineEdit.text() self.input_confirm = self.ui.confirmLineEdit.text() self.checkQuery = QSqlQuery() self.checkQuery.exec_("Select User_password From Account Where User_name = '%s'"\ % (self.name)) if self.checkQuery.next(): record = self.checkQuery.record() self.confirm = str(record.value(0)) #check for password confirmation if self.confirm != self.input_confirm: QtGui.QMessageBox.warning(self, 'Error', "Incorrect Password") self.ui.userLineEdit.clear() self.ui.newUserLineEdit.clear() self.ui.confirmLineEdit.clear() elif self.input_newName == "": QtGui.QMessageBox.warning(self, 'Error', "Please enter a new username") self.ui.userLineEdit.clear() self.ui.newUserLineEdit.clear() self.ui.confirmLineEdit.clear() elif self.input_name != self.name: QtGui.QMessageBox.warning(self, 'Error', "Please enter your username") self.ui.userLineEdit.clear() self.ui.newUserLineEdit.clear() self.ui.confirmLineEdit.clear() else: # make changes change_query = QSqlQuery() change_query.exec_("Update Account SET User_name ='%s' WHERE User_name = '%s'" \ %(self.input_newName, self.input_name)) self.default_msg = "Username Changed" self.default_reply = QtGui.QMessageBox.information( self, 'Change Username', self.default_msg, QtGui.QMessageBox.Ok) self.accept() def getName(self): return self.input_newName # set up database connection def conn(self): self.db = QSqlDatabase.addDatabase("QMYSQL") self.db.setHostName("services1.mcs.sdsmt.edu") self.db.setDatabaseName("db_dancesoft_f15") self.db.setUserName("dancesoft_f15") self.db.setPassword("DanceSoft") return self.db.open()