def __init__(self):
QtGui.QDialog.__init__(self)
self.removeClass = Ui_removeClassDialog()
self.removeClass.setupUi(self)
self.conn()
self.removeClass.sel_class = QSqlRelationalTableModel(db = self.db)
self.removeClass.sel_class.setTable("Class")
if not self.conn():
QtGui.QMessageBox.warning(
self, 'Error', 'database contecting error')
self.idList = []
self.class_query = QSqlQuery()
self.class_query.exec_("Select Class_id, Class_name FROM Class")
while self.class_query.next():
record = self.class_query.record()
self.id = str(record.value(0))
self.name = str(record.value(1))
self.idList.append(self.id)
self.removeClass.classComboBox.addItem(self.name)
self.removeClass.ok_btn.clicked.connect(self.submit)
self.removeClass.cancel_btn.clicked.connect(self.close)
class removeClass(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.removeClass = Ui_removeClassDialog()
self.removeClass.setupUi(self)
self.conn()
self.removeClass.sel_class = QSqlRelationalTableModel(db = self.db)
self.removeClass.sel_class.setTable("Class")
if not self.conn():
QtGui.QMessageBox.warning(
self, 'Error', 'database contecting error')
self.idList = []
self.class_query = QSqlQuery()
self.class_query.exec_("Select Class_id, Class_name FROM Class")
while self.class_query.next():
record = self.class_query.record()
self.id = str(record.value(0))
self.name = str(record.value(1))
self.idList.append(self.id)
self.removeClass.classComboBox.addItem(self.name)
self.removeClass.ok_btn.clicked.connect(self.submit)
self.removeClass.cancel_btn.clicked.connect(self.close)
def submit(self):
self.selectedClass = self.removeClass.classComboBox.currentIndex()
self.selectedClass = self.idList[self.selectedClass]
self.name = self.removeClass.classComboBox.currentText()
self.confirmMessage = "Are you sure you want to remove '%s' from the system? This will remove all relevant information and can not be reversed." \
%(self.name)
self.confirmReply = QtGui.QMessageBox.question(self, 'Confirm',
self.confirmMessage, QtGui.QMessageBox.Yes, QtGui.QMessageBox.No)
if (self.confirmReply == QtGui.QMessageBox.Yes):
self.confirm_query = QSqlQuery()
self.class_query.exec_("DELETE from Class WHERE Class_id = '%s'" % self.selectedClass)
self.teachClass_query = QSqlQuery()
self.teachClass_query.exec_("DELETE from Teacher_Class WHERE Class_id = '%s'" % self.selectedClass)
self.message = "Class Removed"
self.confirmReply = QtGui.QMessageBox.information(self, 'Class Removed',
self.message)
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 removeClass(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.removeClass = Ui_removeClassDialog()
self.removeClass.setupUi(self)
self.conn()
self.removeClass.sel_class = QSqlRelationalTableModel(db=self.db)
self.removeClass.sel_class.setTable("Class")
if not self.conn():
QtGui.QMessageBox.warning(self, "Error", "database contecting error")
self.idList = []
self.class_query = QSqlQuery()
self.class_query.exec_("Select Class_id, Class_name FROM Class")
while self.class_query.next():
record = self.class_query.record()
self.id = str(record.value(0))
self.name = str(record.value(1))
self.idList.append(self.id)
self.removeClass.classComboBox.addItem(self.name)
self.removeClass.ok_btn.clicked.connect(self.submit)
self.removeClass.cancel_btn.clicked.connect(self.close)
def submit(self):
self.selectedClass = self.removeClass.classComboBox.currentIndex()
self.selectedClass = self.idList[self.selectedClass]
self.name = self.removeClass.classComboBox.currentText()
self.confirmMessage = (
"Are you sure you want to remove '%s' from the system? This will remove all relevant information and can not be reversed."
% (self.name)
)
self.confirmReply = QtGui.QMessageBox.question(
self, "Confirm", self.confirmMessage, QtGui.QMessageBox.Yes, QtGui.QMessageBox.No
)
if self.confirmReply == QtGui.QMessageBox.Yes:
self.confirm_query = QSqlQuery()
self.class_query.exec_("DELETE from Class WHERE Class_id = '%s'" % self.selectedClass)
self.teachClass_query = QSqlQuery()
self.teachClass_query.exec_("DELETE from Teacher_Class WHERE Class_id = '%s'" % self.selectedClass)
self.message = "Class Removed"
self.confirmReply = QtGui.QMessageBox.information(self, "Class Removed", self.message)
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()
def __init__(self):
QtGui.QDialog.__init__(self)
self.removeClass = Ui_removeClassDialog()
self.removeClass.setupUi(self)
self.conn()
self.removeClass.sel_class = QSqlRelationalTableModel(db=self.db)
self.removeClass.sel_class.setTable("Class")
if not self.conn():
QtGui.QMessageBox.warning(self, "Error", "database contecting error")
self.idList = []
self.class_query = QSqlQuery()
self.class_query.exec_("Select Class_id, Class_name FROM Class")
while self.class_query.next():
record = self.class_query.record()
self.id = str(record.value(0))
self.name = str(record.value(1))
self.idList.append(self.id)
self.removeClass.classComboBox.addItem(self.name)
self.removeClass.ok_btn.clicked.connect(self.submit)
self.removeClass.cancel_btn.clicked.connect(self.close)
