QString HostDBStorage::GetSetClause(MSqlBindings &bindings) const { QString valueTag(":SETVALUE"); QString dataTag(":SETDATA"); QString hostnameTag(":SETHOSTNAME"); QString clause("value = " + valueTag + ", data = " + dataTag + ", hostname = " + hostnameTag); bindings.insert(valueTag, settingname); bindings.insert(dataTag, user->GetDBValue()); bindings.insert(hostnameTag, MythDB::getMythDB()->GetHostName()); return clause; }
QString HostDBStorage::setClause(MSqlBindings &bindings) { QString valueTag(":SETVALUE"); QString dataTag(":SETDATA"); QString hostnameTag(":SETHOSTNAME"); QString clause("value = " + valueTag + ", data = " + dataTag + ", hostname = " + hostnameTag); bindings.insert(valueTag, setting->getName()); bindings.insert(dataTag, setting->getValue().utf8()); bindings.insert(hostnameTag, gContext->GetHostName()); return clause; }
QString HostDBStorage::GetWhereClause(MSqlBindings &bindings) const { /* Returns a where clause of the form: * "value = :VALUE AND hostname = :HOSTNAME" * The necessary bindings are added to the MSQLBindings& */ QString valueTag(":WHEREVALUE"); QString hostnameTag(":WHEREHOSTNAME"); QString clause("value = " + valueTag + " AND hostname = " + hostnameTag); bindings.insert(valueTag, settingname); bindings.insert(hostnameTag, MythDB::getMythDB()->GetHostName()); return clause; }