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";
}