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