def __init__(self):
QtGui.QDialog.__init__(self)
self.removeStu = Ui_removeStudentDialog()
self.removeStu.setupUi(self)
self.model = QtGui.QStandardItemModel()
self.conn()
self.removeStu.sel_student = QSqlRelationalTableModel(db=self.db)
self.removeStu.sel_student.setTable("Student")
if not self.conn():
QtGui.QMessageBox.warning(self, 'Error',
'database contecting error')
# get student name
self.student_query = QSqlQuery()
self.student_query.exec_("Select Student_name FROM Student")
while self.student_query.next():
record = self.student_query.record()
item = QtGui.QStandardItem()
self.name = str(record.value(0))
item.setText(self.name)
self.model.appendRow(item)
# set up list view model
self.removeStu.studentListView.setModel(self.model)
self.removeStu.studentListView.setSelectionMode(
QtGui.QAbstractItemView.ExtendedSelection)
self.removeStu.ok_btn.clicked.connect(self.submit)
self.removeStu.cancel_btn.clicked.connect(self.close)
self.removeStu.Search_btn.clicked.connect(self.search)
