def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need cathch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_("Select Class_name from Class")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_listView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def __init__(self, name=None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
#get list of class
Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
#populate classes to listview
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def __init__(self, name=None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_(
"Select Class_name from Class as C, Teacher_Class as\
TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
T.Teacher_id = (select Teacher_id from Account where User_name = \
'%s') and TC.Class_id = C.Class_id ORDER BY Class_name"
% name)
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
