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