Ejemplo n.º 1
0
    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)