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
