/**
* @param $sets
* @param $where
* @return int
*/
public function update($sets, $where)
{
DBTable::clearCache();
$sets = $this->objToRel($sets);
// This allows for dummy columns to be part of the object without the
// DAO automatically accessing them in the queries.
if ($this->ignoreCols != null) {
foreach ($this->ignoreCols as $ignoreCol) {
unset($sets[$ignoreCol]);
}
}
$params = [];
$sql = 'UPDATE ' . $this->tableName . ' ' . 'SET ' . join('=?, ', array_keys($sets)) . '=? ' . $this->toWhere($where, $params);
return DB::exec($this->db, $sql, array_merge(array_values($sets), $params));
}
