/**
* Update some registry in database
*
* @param string $container
* @param array $data
* @param array $where
*/
public function update($container, array $data, array $where)
{
$dataVars = array();
$whereVars = array();
foreach ($data as $column => $value) {
$dataVars[$column] = sprintf(':%s_data', $column);
}
foreach ($where as $column => $value) {
$whereVars[$column] = sprintf(':%s_where', $column);
}
$sql = $this->sqlGenerator->update($container, $dataVars, $whereVars);
$stmt = $this->connector->getStatement($sql);
$stmt = $this->bindAllParams($stmt, $data, '_data');
$stmt = $this->bindAllParams($stmt, $where, '_where');
return $stmt;
}
/**
* Create SQL select statement
*
* @param string $container
* @param string|array $data
*/
public function create($container, $data = '*')
{
$this->sql = $this->sqlGenerator->select($container, $data);
$this->defineStmt($this->sql);
return $this;
}
