def __init__(self): QtGui.QDialog.__init__(self) self.ui = Ui_class_search() self.ui.setupUi(self) self.conn() Class_query = QSqlQuery() #display the list of class Class_query.exec_("select Class_name from Class ORDER BY Class_name") model = QSqlQueryModel() model.setQuery(Class_query) self.ui.class_listView.setModel(model) self.ui.class_listView.clicked.connect(self.show_student) self.ui.student_listView.clicked.connect(self.select_student) self.ui.approve_btn.setEnabled(False) self.ui.reject_btn.setEnabled(False) self.ui.approve_btn.clicked.connect(partial(self.update_satus, index = 1)) self.ui.reject_btn.clicked.connect(partial(self.update_satus, index = -1)) self.ui.cancel_btn.clicked.connect(self.close)
def __init__(self): QtGui.QDialog.__init__(self) self.ui = Ui_class_search() self.ui.setupUi(self) self.conn() Class_query = QSqlQuery() Class_query.exec_("select Class_name from Class") model = QSqlQueryModel() model.setQuery(Class_query) self.ui.class_listView.setModel(model) self.ui.class_listView.clicked.connect(self.show_student) self.ui.student_listView.clicked.connect(self.select_student) self.ui.approve_btn.setEnabled(False) self.ui.reject_btn.setEnabled(False) self.ui.approve_btn.clicked.connect(partial(self.update_satus, index=1)) self.ui.reject_btn.clicked.connect(partial(self.update_satus, index=-1))
class class_search_dialog(QtGui.QDialog): def __init__(self): QtGui.QDialog.__init__(self) self.ui = Ui_class_search() self.ui.setupUi(self) self.conn() Class_query = QSqlQuery() Class_query.exec_("select Class_name from Class") model = QSqlQueryModel() model.setQuery(Class_query) self.ui.class_listView.setModel(model) self.ui.class_listView.clicked.connect(self.show_student) self.ui.student_listView.clicked.connect(self.select_student) self.ui.approve_btn.setEnabled(False) self.ui.reject_btn.setEnabled(False) self.ui.approve_btn.clicked.connect(partial(self.update_satus, index=1)) self.ui.reject_btn.clicked.connect(partial(self.update_satus, index=-1)) def update_satus(self, index): update_query = QSqlQuery() message = "" if index == 1: message = "approve" else: message = "reject" if update_query.exec( "Update Student_Class Set Class_approval = %d Where\ Student_id = (Select Student_id from Student Where Student_name = \ '%s') and Class_id = (Select Class_id from Class where \ Class_name = '%s')" % (index, self.stu_name, self.class_name) ): QtGui.QMessageBox.information(self, "Success", "%s student successfully" % message) self.ui.student_listView.setRowHidden(self.selected_row, True) def show_student(self, index): self.ui.approve_btn.setEnabled(False) self.ui.reject_btn.setEnabled(False) Student_query = QSqlQuery() Student_query.exec_( "Select S.Student_name from Student_Class as SC,Student as S where\ SC.Class_id = (Select Class_id from Class where Class_name = '%s') \ and SC.Student_id = S.Student_id and SC.Class_finished <> 1 and \ SC.Class_approval = 0" % index.data() ) self.class_name = index.data() model = QSqlQueryModel() model.setQuery(Student_query) self.ui.student_listView.setModel(model) def select_student(self, index): self.ui.approve_btn.setEnabled(True) self.ui.reject_btn.setEnabled(True) self.stu_name = index.data() self.selected_row = index.row() 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 class_reg_dialog(QtGui.QDialog): def __init__(self): QtGui.QDialog.__init__(self) self.ui = Ui_class_search() self.ui.setupUi(self) self.conn() Class_query = QSqlQuery() #display the list of class Class_query.exec_("select Class_name from Class ORDER BY Class_name") model = QSqlQueryModel() model.setQuery(Class_query) self.ui.class_listView.setModel(model) self.ui.class_listView.clicked.connect(self.show_student) self.ui.student_listView.clicked.connect(self.select_student) self.ui.approve_btn.setEnabled(False) self.ui.reject_btn.setEnabled(False) self.ui.approve_btn.clicked.connect(partial(self.update_satus, index = 1)) self.ui.reject_btn.clicked.connect(partial(self.update_satus, index = -1)) self.ui.cancel_btn.clicked.connect(self.close) def update_satus(self, index): update_query = QSqlQuery() message = '' if index == 1: message = 'approve' else: message = 'reject' if update_query.exec("Update Student_Class Set Class_approval = %d Where\ Student_id = (Select Student_id from Student Where Student_name = \ '%s') and Class_id = (Select Class_id from Class where \ Class_name = '%s')" % (index, self.stu_name, self.class_name)): QtGui.QMessageBox.information( self, 'Success', '%s student successfully' % message) self.ui.student_listView.setRowHidden(self.selected_row, True) def show_student(self, index): self.ui.approve_btn.setEnabled(False) self.ui.reject_btn.setEnabled(False) Student_query = QSqlQuery() Student_query.exec_("Select S.Student_name from Student_Class as SC,Student as S where\ SC.Class_id = (Select Class_id from Class where Class_name = '%s') \ and SC.Student_id = S.Student_id and SC.Class_finished <> 1 and \ SC.Class_approval = 0 ORDER BY S.Student_name" % index.data()) self.class_name = index.data() model = QSqlQueryModel() model.setQuery(Student_query) self.ui.student_listView.setModel(model) def select_student(self, index): self.ui.approve_btn.setEnabled(True) self.ui.reject_btn.setEnabled(True) self.stu_name = index.data() self.selected_row = index.row() 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()