def create_database(self): self.progress_bar.setValue(0) PB_LIMIT = 50 def updatePB(): val = self.progress_bar.value() if val < PB_LIMIT: self.progress_bar.setValue(val + 5) self.progress_bar.update() self.timer1 = QtCore.QTimer() self.connect(self.timer1, QtCore.SIGNAL("timeout()"), updatePB) try: from openmolar import create_db if (create_db.exists_already(self.dialog.host, self.dialog.port, self.dialog.db_name, self.dialog.privileged_user_pass, self.dialog.privileged_user) and QtGui.QMessageBox.question( self, _("Confirm"), "%s '%s' %s<hr />%s" % (_("A database named"), self.dialog.db_name, _("exists already"), _("Overwrite this database?")), QtGui.QMessageBox.Yes | QtGui.QMessageBox.No, QtGui.QMessageBox.No) == QtGui.QMessageBox.No): self.dialog.database_exists_already() return self.timer1.start(10) # 1/100thsecond self.progress_bar.setValue(10) create_db.create_database(self.dialog.host, self.dialog.port, self.dialog.db_user, self.dialog.db_pass, self.dialog.db_name, self.dialog.privileged_user_pass, self.dialog.privileged_user) self.progress_bar.setValue(50) PB_LIMIT = 90 create_db.create_tables( self.dialog.host, self.dialog.port, self.dialog.db_user, self.dialog.db_pass, self.dialog.db_name, ) self.progress_bar.setValue(100) QtGui.QMessageBox.information(self, _("Success!"), _("Database created successfully!")) self.db_created = True self.dialog.next() except Exception as exc: LOGGER.exception("error creating database") message = "%s<hr />%s" % (_("Error Creating Database"), exc) QtGui.QMessageBox.warning(self, _("Error"), message) self.db_created = False
def unfinished_business(self): chosen_dbname = self.line_edit1.text().strip(" ") if chosen_dbname == "" or not self.create_new: return False if (create_db.exists_already( self.dialog.host, self.dialog.port, chosen_dbname, self.dialog.privileged_user_pass, self.dialog.privileged_user) and QtWidgets.QMessageBox.question( self, _("Confirm"), "%s '%s' %s<hr />%s" % (_("A database named"), chosen_dbname, _("exists already"), _("Overwrite this database?")), QtWidgets.QMessageBox.Yes | QtWidgets.QMessageBox.No, QtWidgets.QMessageBox.No) == QtWidgets.QMessageBox.No): return True return False
def unfinished_business(self): chosen_dbname = self.line_edit1.text().strip(" ") if chosen_dbname == "" or not self.create_new: return False if ( create_db.exists_already( self.dialog.host, self.dialog.port, chosen_dbname, self.dialog.privileged_user_pass, self.dialog.privileged_user, ) and QtWidgets.QMessageBox.question( self, _("Confirm"), "%s '%s' %s<hr />%s" % (_("A database named"), chosen_dbname, _("exists already"), _("Overwrite this database?")), QtWidgets.QMessageBox.Yes | QtWidgets.QMessageBox.No, QtWidgets.QMessageBox.No, ) == QtWidgets.QMessageBox.No ): return True return False
def create_database(self): self.progress_bar.setValue(0) PB_LIMIT = 50 def updatePB(): val = self.progress_bar.value() if val < PB_LIMIT: self.progress_bar.setValue(val + 5) self.progress_bar.update() self.timer1 = QtCore.QTimer() self.timer1.timeout.connect(updatePB) try: from openmolar import create_db if (create_db.exists_already(self.dialog.host, self.dialog.port, self.dialog.db_name, self.dialog.privileged_user_pass, self.dialog.privileged_user) and QtWidgets.QMessageBox.question( self, _("Confirm"), "%s '%s' %s<hr />%s" % (_("A database named"), self.dialog.db_name, _("exists already"), _("Overwrite this database?")), QtWidgets.QMessageBox.Yes | QtWidgets.QMessageBox.No, QtWidgets.QMessageBox.No) == QtWidgets.QMessageBox.No): self.dialog.database_exists_already() return self.timer1.start(10) # 1/100thsecond self.progress_bar.setValue(10) create_db.create_database( self.dialog.host, self.dialog.port, self.dialog.db_user, self.dialog.db_pass, self.dialog.db_name, self.dialog.privileged_user_pass, self.dialog.privileged_user ) self.progress_bar.setValue(50) PB_LIMIT = 90 create_db.create_tables(self.dialog.host, self.dialog.port, self.dialog.db_user, self.dialog.db_pass, self.dialog.db_name, ) self.progress_bar.setValue(100) QtWidgets.QMessageBox.information( self, _("Success!"), _("Database created successfully!") ) self.db_created = True next(self.dialog) except Exception as exc: LOGGER.exception("error creating database") message = "%s<hr />%s" % (_("Error Creating Database"), exc) QtWidgets.QMessageBox.warning(self, _("Error"), message) self.db_created = False