def __init__(self): QtGui.QMainWindow.__init__(self) self.ui = Ui_Enter_hours() self.ui.setupUi(self) self.conn() Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher") model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) self.ui.Search_btn.clicked.connect(self.search_teacher) self.ui.Hours_btn.setEnabled(False) self.ui.Hours_btn.clicked.connect(self.show_hours) self.ui.Teacher_listView.clicked.connect(self.select_teacher)
class Enter_hours_window(QtGui.QMainWindow): def __init__(self): QtGui.QMainWindow.__init__(self) self.ui = Ui_Enter_hours() self.ui.setupUi(self) self.conn() #get teacher's name Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher") model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) self.ui.Search_btn.clicked.connect(self.search_teacher) self.ui.Hours_btn.setEnabled(False) self.ui.Hours_btn.clicked.connect(self.show_hours) self.ui.Teacher_listView.clicked.connect(self.select_teacher) #show the current hour def show_hours(self): self.ui.show = show_hours_dialog(self.ui.name) self.ui.show.show() #get teacher name def select_teacher(self, index): self.ui.name = index.data() self.ui.Hours_btn.setEnabled(True) #search teacher at entry def search_teacher(self): input_teacher_name = self.ui.Teacher_lineEdit.text() Teacher_query = QSqlQuery() Teacher_query.exec_( "select Teacher_name from Teacher where Teacher_name like '%%%s%%'" % input_teacher_name) model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) 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 Enter_hours_window(QtGui.QMainWindow): def __init__(self): QtGui.QMainWindow.__init__(self) self.ui = Ui_Enter_hours() self.ui.setupUi(self) self.conn() #get teacher's name Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher") model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) self.ui.Search_btn.clicked.connect(self.search_teacher) self.ui.Hours_btn.setEnabled(False) self.ui.Hours_btn.clicked.connect(self.show_hours) self.ui.Teacher_listView.clicked.connect(self.select_teacher) #show the current hour def show_hours(self): self.ui.show = show_hours_dialog(self.ui.name) self.ui.show.show() #get teacher name def select_teacher(self, index): self.ui.name = index.data() self.ui.Hours_btn.setEnabled(True) #search teacher at entry def search_teacher(self): input_teacher_name = self.ui.Teacher_lineEdit.text() Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher where Teacher_name like '%%%s%%'" % input_teacher_name) model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) 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()