Exemple #1
0
    def __init__(self):
        QtGui.QDialog.__init__(self)
        self.removeAd = Ui_removeAdminDialog()
        self.removeAd.setupUi(self)

        self.conn()

        self.removeAd.sel_ad = QSqlRelationalTableModel(db = self.db)
        self.removeAd.sel_ad.setTable("Admin")

        if not self.conn():
            QtGui.QMessageBox.warning(
                self, 'Error', 'database contecting error')

        self.ad_query = QSqlQuery()
        self.ad_query.exec_("Select Admin_name FROM Admin")
        while self.ad_query.next():
            record = self.ad_query.record()
            self.name = str(record.value(0))
            self.removeAd.adminComboBox.addItem(self.name)
            
        self.removeAd.ok_btn.clicked.connect(self.submit)

        self.removeAd.cancel_btn.clicked.connect(self.close)