public function getInTagPartialClause(TagPartial $tagPartial, Element $myElement, DatabaseInterface $db, $table)
{
$clause = '';
foreach (array('element', 'slug', 'role', 'value') as $key) {
$partialKey = 'Tag' . ucfirst($key);
if (empty($tagPartial->{$partialKey})) {
continue;
}
if (!empty($clause)) {
$clause .= ' AND';
}
if ($key == 'element') {
$element = $this->ElementService->getBySlug($tagPartial->TagElement);
$clause .= " {$table}.ElementID = {$db->quote($element->ElementID)}";
} else {
$val = $tagPartial->{$partialKey};
$clause .= ' ' . $table . '.' . $key . " = " . $db->quote($val) . " ";
}
}
return $clause;
}
public function deprecateMeta(DatabaseInterface $db, NodeRef $originNodeRef, $metaID, $datatype)
{
$table = $db->quoteIdentifier($this->NodeDBMeta->getMetaTable($originNodeRef, $datatype));
$affectedRows = $db->write("DELETE FROM {$table} WHERE Name = {$db->quote($metaID)}", DatabaseInterface::AFFECTED_ROWS);
return $affectedRows;
}
