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(); }