/**
* Test getTriggerDefinition($trigger)
* @dataProvider provider
*/
public function testGetTriggerDefinition($ci)
{
$this->manualSetUp($ci);
//setup
$trigger_name = 'test_trigger';
if (!$this->nonstd) {
$this->markTestSkipped('No Nonstandard Helper for this phptype.');
}
$action = 'create trigger';
$result = $this->nonstd->createTrigger($trigger_name, $this->table);
if (MDB2::isError($result)) {
if ($result->getCode() == MDB2_ERROR_NO_PERMISSION || $result->getCode() == MDB2_ERROR_ACCESS_VIOLATION) {
$this->markTestSkipped("Test user lacks permission to {$action}");
}
$this->fail("Could not {$action}: " . $result->getUserInfo());
}
//test
$def = $this->db->reverse->getTriggerDefinition($trigger_name);
if (MDB2::isError($def)) {
$this->fail('getTriggerDefinition: ' . $def->getUserInfo());
} else {
$this->nonstd->checkTrigger($trigger_name, $this->table, $def);
}
//cleanup
$result = $this->nonstd->dropTrigger($trigger_name, $this->table);
if (MDB2::isError($result)) {
$this->fail('Error dropping the trigger: ' . $result->getUserInfo());
}
}
public function checkTrigger($trigger_name, $table_name, $def)
{
parent::checkTrigger($trigger_name, $table_name, $def);
$this->test->assertEquals($this->trigger_body, $def['trigger_body']);
echo '<pre>';
var_dump($this->trigger_body);
var_dump($def['trigger_body']);
}
public function checkTrigger($trigger_name, $table_name, $def)
{
parent::checkTrigger($trigger_name, $table_name, $def);
$this->test->assertEquals($this->trigger_body, $def['trigger_body']);
}
