public function testUpdateMultiple() { $update = new Update('foo'); $update->set('name', 'hello'); $update->set('title', 'world'); $update->whereEquals('id', 1); $update->limit(10); list($sql, $params) = $update->toQuery(); $this->assertEqualsSql('UPDATE foo SET name = ?, title=? WHERE id=:id LIMIT 10', $sql); $this->assertEquals(array('hello', 'world', 1), $params); }
/** * Create a new update query builder * * $h->table('users')->update(['age' => 25])->where('name', 'Johanna') * * @param array $values * @return Update */ public function update(array $values = array()) { $query = new Update($this); return $query->set($values); }
/** * @covers Zend\Db\Sql\Update::set */ public function testSet() { $this->update->set(array('foo' => 'bar')); $this->assertEquals(array('foo' => 'bar'), $this->readAttribute($this->update, 'set')); }