def DB_push_mf_userVal(self): db = db_functions.db_variable(self) query = QtSql.QSqlQuery(db) query.prepare( "UPDATE mf_inputs SET user_val = :UP1 WHERE parNames = 'ss'") query.bindValue(":UP1", self.lineEdit_ss_single.text()) query.exec_()
def DB_resetTodefaultVal(self): msgBox = QMessageBox() msgBox.setWindowIcon(QtGui.QIcon(':/QSWATMOD2/pics/sm_icon.png')) response = msgBox.question( self, 'Set to default?', "Are you sure you want to reset the current aquifer property settings to the default values?", QMessageBox.Yes | QMessageBox.No, QMessageBox.No) if response == QMessageBox.Yes: db = db_functions.db_variable(self) query = QtSql.QSqlQuery(db) query.exec_( "SELECT default_val FROM mf_inputs WHERE parNames = 'ss' ") LK = str(query.first()) self.lineEdit_ss_single.setText(str(query.value(0))) self.DB_push_mf_userVal()
def DB_Pull_mf_inputs(self): db = db_functions.db_variable(self) query = QtSql.QSqlQuery(db) query.exec_("SELECT user_val FROM mf_inputs WHERE parNames = 'ss' ") LK = str(query.first()) # What does LK do? self.lineEdit_ss_single.setText(str(query.value(0)))