function test_default()
{
$query = new SQL_Query_Insert('table');
$query->addValues(array('name' => 'cain'));
$query->resetValues();
$this->assertEquals(array(), $query->getValues());
}
function test_insertSimple()
{
$query = new SQL_Query_Insert('city', 'insert');
$query->addSelect('no matter what');
$query->addValues(array('country_id' => 1, 'name' => '"cain"', 'phonePrefix' => '"0049"'), array('country_id' => 2, 'name' => '"foo"', 'phonePrefix' => '"0034"'));
$ren = new $this->_renderer($query);
$this->assertStringEquals('INSERT INTO city (country_id,name,phonePrefix) ' . 'VALUES (1,"cain","0049") , (2,"foo","0034")', $ren->render());
}
function test_multiple()
{
$query = new SQL_Query_Insert('table');
$query->addValues(array('name' => 'cain', 'surname' => 'Doodi'), array('name' => 'foo', 'surname' => 'bar'));
$query->addValues(array('name' => 'foo1', 'surname' => 'bar1'));
$expected = array(array('name' => 'cain', 'surname' => 'Doodi'), array('name' => 'foo', 'surname' => 'bar'), array('name' => 'foo1', 'surname' => 'bar1'));
$this->assertEquals($expected, $query->getValues());
}
function test_missingCols()
{
$insert = new SQL_Query_Insert('table');
$values = array(array('name' => '"cain"', 'surname' => '"none"'), array('name' => '"foo"'));
$insert->addValues($values[0]);
$insert->addValues($values[1]);
$renderer = new $this->_renderer($insert);
$this->assertStringEquals('( name , surname ) VALUES ' . '( "cain" , "none" ) , ( "foo" , NULL )', $renderer->renderValues());
}
