public function deleteMultipleItems(array $ids)
{
$builder = $this->conn->createQueryBuilder();
$pk = $this->getPrimaryColumn()->getExpr();
$expr = $builder->expr();
$builder->delete($this->tableName)->where($expr->in($pk, $ids));
LoggingHelper::logBuilder($builder);
$status = $builder->execute();
return $status;
}
public function setRow($id = null, $values = array())
{
$log = new LoggingHelper();
$log->vardump($values);
}
public function createItem($values)
{
$builder = $this->conn->createQueryBuilder();
$builder->insert($this->tableName);
foreach ($values as $formKey => $formValue) {
/** @var SQLColumn $col */
$col = null;
if (!isset($this->columns[$formKey])) {
throw new \Exception("Unknown column");
}
$col = $this->columns[$formKey];
$builder->setValue($col->getExpr(), $builder->createNamedParameter($values[$formKey]));
}
LoggingHelper::logBuilder($builder);
$builder->execute();
return $this->conn->lastInsertId();
}
