/** * 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; }