QString GetSetClause(MSqlBindings &bindings) const override // SimpleStorage { bindings.insert(":SETPLAYERID", m_id.Value()); bindings.insert(":SETCOLUMN", m_user->GetDBValue()); return QString("gameplayerid = :SETPLAYERID, " "%2 = :SETCOLUMN").arg(GetColumnName()); }
QString GenericDBStorage::GetSetClause(MSqlBindings &bindings) const { QString keycolumnTag = ":SETKEY" + keycolumn.toUpper(); QString columnTag = ":SETCOL" + GetColumnName().toUpper(); bindings.insert(keycolumnTag, keyvalue); bindings.insert(columnTag, user->GetDBValue()); return keycolumn + " = " + keycolumnTag + ", " + GetColumnName() + " = " + columnTag; }
QString MuxDBStorage::GetSetClause(MSqlBindings &bindings) const { QString muxTag = ":SET" + mplexid->GetColumnName().toUpper(); QString nameTag = ":SET" + GetColumnName().toUpper(); bindings.insert(muxTag, mplexid->getValue()); bindings.insert(nameTag, user->GetDBValue()); // return query return (mplexid->GetColumnName() + " = " + muxTag + ", " + GetColumnName() + " = " + nameTag); }
QString GlobalDBStorage::setClause(MSqlBindings &bindings) { QString valueTag(":SETVALUE"); QString dataTag(":SETDATA"); QString clause("value = " + valueTag + ", data = " + dataTag); bindings.insert(valueTag, setting->getName()); bindings.insert(dataTag, setting->getValue().utf8()); return clause; }
QString GlobalDBStorage::GetSetClause(MSqlBindings &bindings) const { QString valueTag(":SETVALUE"); QString dataTag(":SETDATA"); QString clause("value = " + valueTag + ", data = " + dataTag); bindings.insert(valueTag, settingname); bindings.insert(dataTag, user->GetDBValue()); return clause; }
QString ChannelDBStorage::setClause(MSqlBindings &bindings) { QString fieldTag = (":SET" + id.getField().upper()); QString nameTag = (":SET" + setting->getName().upper()); QString query(id.getField() + " = " + fieldTag + ", " + setting->getName() + " = " + nameTag); bindings.insert(fieldTag, id.getValue()); bindings.insert(nameTag, setting->getValue()); return query; }
QString ChannelDBStorage::GetSetClause(MSqlBindings &bindings) const { QString fieldTag = (":SET" + id.getField().toUpper()); QString nameTag = (":SET" + GetColumnName().toUpper()); QString query(id.getField() + " = " + fieldTag + ", " + GetColumnName() + " = " + nameTag); bindings.insert(fieldTag, id.getValue()); bindings.insert(nameTag, user->GetDBValue()); return query; }
QString ProfileGroupStorage::GetSetClause(MSqlBindings &bindings) const { QString idTag(":SETID"); QString colTag(":SET" + GetColumnName().toUpper()); QString query("id = " + idTag + ", " + GetColumnName() + " = " + colTag); bindings.insert(idTag, m_parent.getProfileNum()); bindings.insert(colTag, user->GetDBValue()); return query; }
QString GameDBStorage::GetSetClause(MSqlBindings &bindings) const { QString playerID(":SETPLAYERID"); QString colTag(":SET" + GetColumnName().toUpper()); QString query("gameplayerid = " + playerID + ", " + GetColumnName() + " = " + colTag); bindings.insert(playerID, parent.getGamePlayerID()); bindings.insert(colTag, user->GetDBValue()); return query; }
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; }
QString GenericDBStorage::GetWhereClause(MSqlBindings &bindings) const { QString keycolumnTag = ":WHERE" + keycolumn.toUpper(); bindings.insert(keycolumnTag, keyvalue); return keycolumn + " = " + keycolumnTag; }
void MSqlAddMoreBindings(MSqlBindings &output, MSqlBindings &addfrom) { MSqlBindings::Iterator it; for (it = addfrom.begin(); it != addfrom.end(); ++it) { output.insert(it.key(), it.value()); } }
QString GlobalDBStorage::GetWhereClause(MSqlBindings &bindings) const { QString valueTag(":WHEREVALUE"); QString clause("value = " + valueTag); bindings.insert(valueTag, settingname); return clause; }
// Player Settings QString GameDBStorage::GetWhereClause(MSqlBindings &bindings) const { QString playerId(":PLAYERID"); QString query("gameplayerid = " + playerId); bindings.insert(playerId, parent.getGamePlayerID()); return query; }
QString SimpleDBStorage::setClause(MSqlBindings &bindings) { QString tagname(":SET" + column.upper()); QString clause(column + " = " + tagname); bindings.insert(tagname, setting->getValue().utf8()); return clause; }
QString MuxDBStorage::GetWhereClause(MSqlBindings &bindings) const { QString muxTag = ":WHERE" + mplexid->GetColumnName().toUpper(); bindings.insert(muxTag, mplexid->getValue()); // return query return mplexid->GetColumnName() + " = " + muxTag; }
QString ProfileGroupStorage::GetWhereClause(MSqlBindings &bindings) const { QString idTag(":WHEREID"); QString query("id = " + idTag); bindings.insert(idTag, m_parent.getProfileNum()); return query; }
QString ChannelDBStorage::GetWhereClause(MSqlBindings &bindings) const { QString fieldTag = (":WHERE" + id.getField().toUpper()); QString query(id.getField() + " = " + fieldTag); bindings.insert(fieldTag, id.getValue()); return query; }
QString GlobalDBStorage::whereClause(MSqlBindings &bindings) { QString valueTag(":WHEREVALUE"); QString clause("value = " + valueTag); bindings.insert(valueTag, setting->getName()); return clause; }
QString PlayGroupDBStorage::GetWhereClause(MSqlBindings &bindings) const { QString nameTag(":WHERENAME"); QString query("name = " + nameTag); bindings.insert(nameTag, parent.getName()); return query; }
QString SimpleDBStorage::GetSetClause(MSqlBindings &bindings) const { QString tagname(":SET" + GetColumnName().toUpper()); QString clause(GetColumnName() + " = " + tagname); bindings.insert(tagname, user->GetDBValue()); return clause; }
QString GetWhereClause(MSqlBindings &bindings) const override // SimpleStorage { bindings.insert(":PLAYERID", m_id.Value()); return "gameplayerid = :PLAYERID"; }