Python Ui_Clothing_Requirements Examples

Example #1

File: Clothing_Requirements_dialog.py Project: SDSMT-CSC/dancesoft

    def __init__(self):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Clothing_Requirements()
        self.ui.setupUi(self)
        self.setup_database()

        self.ui.submit.clicked.connect(self.modify_information)
        self.ui.cancel.clicked.connect(self.modify_information)

Example #2

File: Clothing_Requirements_dialog.py Project: SDSMT-CSC464-F15/dancesoft

class clothing_requirements(QtGui.QDialog):
    def __init__(self):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Clothing_Requirements()
        self.ui.setupUi(self)
        self.setup_database()

        self.ui.submit.clicked.connect(self.modify_information)
        self.ui.cancel.clicked.connect(self.modify_information)

        
        
    def setup_database(self):

        
        
        self.conn() #need catch exception

        self.ui.sel_teach = QSqlRelationalTableModel(db = self.db)
        self.ui.sel_teach.setTable("Class")

        self.id = 1

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

        query = QSqlQuery()
        query.exec_("Select Class_clothing FROM Class WHERE Class_id = '%s'" % self.id)
        while query.next():
            record = query.record()
            self.ui.clothing_entry_field.setText(str(record.value(0).toString()))
        
        
    def modify_information(self):

        self.updates = self.ui.clothing_entry_field.toPlainText()
        
        update_query = QSqlQuery()
        update_query.exec_("Update Class SET Class_clothing ='%s' WHERE Class_id = '%s'"\
                           % (self.updates, self.id))
        quit()
        
        
        
    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()

Example #3

File: Clothing_Requirements_dialog.py Project: SDSMT-CSC/dancesoft

class clothing_requirements(QtGui.QDialog):
    def __init__(self):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Clothing_Requirements()
        self.ui.setupUi(self)
        self.setup_database()

        self.ui.submit.clicked.connect(self.modify_information)
        self.ui.cancel.clicked.connect(self.modify_information)

    def setup_database(self):

        self.conn()  #need catch exception

        self.ui.sel_teach = QSqlRelationalTableModel(db=self.db)
        self.ui.sel_teach.setTable("Class")

        self.id = 1

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

        query = QSqlQuery()
        query.exec_("Select Class_clothing FROM Class WHERE Class_id = '%s'" %
                    self.id)
        while query.next():
            record = query.record()
            self.ui.clothing_entry_field.setText(
                str(record.value(0).toString()))

    def modify_information(self):

        self.updates = self.ui.clothing_entry_field.toPlainText()

        update_query = QSqlQuery()
        update_query.exec_("Update Class SET Class_clothing ='%s' WHERE Class_id = '%s'"\
                           % (self.updates, self.id))
        quit()

    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()

Example #4

File: Clothing_Requirements_dialog.py Project: SDSMT-CSC464-F15/dancesoft

    def __init__(self):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Clothing_Requirements()
        self.ui.setupUi(self)
        self.setup_database()

        self.ui.submit.clicked.connect(self.modify_information)
        self.ui.cancel.clicked.connect(self.modify_information)