/**
* @covers PSDB::insert
*/
public function testInsert()
{
$table = 'ps_test_data_load';
PSDB::update("delete from {$table}");
$this->assertEquals(PSDB::getRec("select count(1) as cnt from {$table}"), array('cnt' => 0));
PSDB::insert("insert into {$table} (v_key, v_value) values (?, ?)", array('key1', 'val1'));
$rec = PSDB::getRec("select v_key, v_value from {$table}");
$this->assertEquals($rec, array('v_key' => 'key1', 'v_value' => 'val1'));
PSDB::insert("insert into {$table} (v_key, v_value) values (?, ?)", array('key2', 'val2'));
$rec = PSDB::getRec("select v_key, v_value from {$table} where v_key=?", 'key2');
$this->assertEquals($rec, array('v_key' => 'key2', 'v_value' => 'val2'));
try {
PSDB::insert("insert into {$table} (v_key, v_value) values (?, ?)", array('key1', 'val1'));
$this->brakeNoException();
} catch (Exception $ex) {
$this->assertTrue($ex instanceof DBException);
$this->assertEquals($ex->getCode(), DBException::ERROR_DUPLICATE_ENTRY);
}
}
/**
* insert
*/
private function executeInsert($query)
{
return PSDB::insert($query);
}
protected function insert($query, $inputarr = false)
{
return PSDB::insert($query, $inputarr);
}
