public function update(DeligatedUser $user)
{
if (!$user->getId()) {
throw new InvalidParameter("DeligatedUser must have an id before updating.");
}
Query::update('neuron_users_deligated', $this->getDataToSet($user), array('ud_id' => $user->getId()))->execute();
}
/**
* @test
*/
public function testQueryBuilderUpdate()
{
// And do the same with update
$expected = 'UPDATE `table` SET column1 = \'Value 1 \\\' \\" \\\\ dum dum dum.\', column2 = 98, column3 = FROM_UNIXTIME(1379289600) WHERE column_string = \'CatLab \\\' \\" \\\\ dum dum dum.\' AND column_id = 15 AND column_date = FROM_UNIXTIME(1379289600)';
$query = Query::update('table', array('column1' => array('Value 1 \' " \\ dum dum dum.', Query::PARAM_STR), 'column2' => array(98, Query::PARAM_NUMBER), 'column3' => array(gmmktime(0, 0, 0, 9, 16, 2013), Query::PARAM_DATE)), array('column_string' => array('CatLab \' " \\ dum dum dum.', Query::PARAM_STR), 'column_id' => array(15, Query::PARAM_NUMBER), 'column_date' => array(gmmktime(0, 0, 0, 9, 16, 2013), Query::PARAM_DATE)));
$sql = $query->getParsedQuery();
$this->assertEquals($expected, $sql);
// Mixed up update
$query = Query::update('table', array('column1' => 'Value 1 \' " \\ dum dum dum.', 'column2' => array(98, Query::PARAM_NUMBER), 'column3' => array(gmmktime(0, 0, 0, 9, 16, 2013), Query::PARAM_DATE)), array('column_string' => 'CatLab \' " \\ dum dum dum.', 'column_id' => array(15, Query::PARAM_NUMBER), 'column_date' => array(gmmktime(0, 0, 0, 9, 16, 2013), Query::PARAM_DATE)));
$sql = $query->getParsedQuery();
$this->assertEquals($expected, $sql);
}
/**
* @param User $user
* @return User
*/
public function update(User $user)
{
$data = $this->prepareFields($user);
Query::update($this->table_users, $data, array('u_id' => $user->getId()))->execute();
}
