public function testValuesMultipleDifferent() { $insert = new Insert('foo'); $insert->values(array('name' => 'hello')); $insert->values(array('id' => 20)); list($sql, $params) = $insert->toQuery(); $this->assertEqualsSql('INSERT INTO foo (name,id) VALUES (:name_0,:id_0),(:name_1,:id_1)', $sql); $this->assertEquals(array(':name_0' => 'hello', ':id_0' => null, ':name_1' => null, ':id_1' => 20), $params); }
/** * Create a new insert query builder * * $h->table('users')->insert(['name' => 'Lucas', 'age' => 21]) * * @param array $values * @return Insert */ public function insert(array $values = array()) { $query = new Insert($this); return $query->values($values); }
/** * @covers Zend\Db\Sql\Insert::values */ public function testValues() { $this->insert->values(array('foo' => 'bar')); $this->assertEquals(array('foo'), $this->readAttribute($this->insert, 'columns')); $this->assertEquals(array('bar'), $this->readAttribute($this->insert, 'values')); }