/**
* Test number of rows inserted is corrected. All columns type supported.
*/
public function test1()
{
$data[] = ['field1' => 1, 'field2' => 1, 'field3' => 1, 'field4' => 1, 'field5' => 1, 'field6' => 2000, 'field7' => 0.1, 'field8' => 0.1, 'field9' => 0.1, 'field10' => 1010, 'field11' => 1010, 'field12' => 'abc', 'field13' => 'abc', 'field14' => '10:00:00', 'field15' => 2102101, 'field16' => '2000-01-01', 'field17' => '2000-01-01 10:00:00', 'field18' => 'a', 'field19' => 'a', 'field20' => 1010];
// bit(4),
$data[] = ['field1' => 2, 'field2' => 2, 'field3' => 2, 'field4' => 2, 'field5' => 2, 'field6' => 2001, 'field7' => 0.2, 'field8' => 0.2, 'field9' => 0.2, 'field10' => 1010, 'field11' => 1010, 'field12' => 'abc', 'field13' => 'abc', 'field14' => '10:00:10', 'field15' => 2102101, 'field16' => '2001-01-01', 'field17' => '2001-01-01 10:00:10', 'field18' => 'b', 'field19' => 'b', 'field20' => 1010];
// bit(4),
$data[] = ['field1' => 3, 'field2' => 3, 'field3' => 3, 'field4' => 3, 'field5' => 3, 'field6' => 2002, 'field7' => 0.3, 'field8' => 0.3, 'field9' => 0.3, 'field10' => 1010, 'field11' => 1010, 'field12' => 'abc', 'field13' => 'abc', 'field14' => '10:00:20', 'field15' => 2102101, 'field16' => '2002-01-01', 'field17' => '2002-01-01 10:00:20', 'field18' => 'c', 'field19' => 'c', 'field20' => 1010];
// bit(4),
$data[] = ['field1' => 4, 'field2' => 1, 'field3' => 1, 'field4' => 1, 'field5' => 1, 'field6' => 2000, 'field7' => 0.1, 'field8' => 0.1, 'field9' => 0.1, 'field10' => 1010, 'field11' => 1010, 'field12' => 'abc', 'field13' => 'abc', 'field14' => '10:00:00', 'field15' => 2102101, 'field16' => '2000-01-01', 'field17' => '2000-01-01 10:00:00', 'field18' => 'c', 'field19' => 'a,b', 'field20' => 1010];
// bit(4),
DataLayer::testBulkInsert01($data);
$query = 'SELECT count(*) FROM `TST_TEMPO`';
$ret = DataLayer::executeSingleton1($query);
$this->assertEquals(4, $ret);
}
