/**
* Check if getTriggerDefinition() returns the correct definition for the trigger
*/
public function checkTrigger($trigger_name, $table_name, $def)
{
$this->test->assertEquals(strtoupper($trigger_name), strtoupper($def['trigger_name']), 'Error getting trigger definition (name)');
$this->test->assertEquals(strtoupper($table_name), strtoupper($def['table_name']), 'Error getting trigger definition (table)');
$this->test->assertEquals('AFTER', $def['trigger_type'], 'Error getting trigger definition (type)');
$this->test->assertEquals('UPDATE', $def['trigger_event'], 'Error getting trigger definition (event)');
$this->test->assertTrue(is_string($def['trigger_body']), 'Error getting trigger definition (body)');
$this->test->assertTrue($def['trigger_enabled'], 'Error getting trigger definition (enabled)');
//$this->test->assertTrue(empty($def['trigger_comment']), 'Error getting trigger definition (comment)');
}
public static function setUpBeforeClass()
{
$dsns = unserialize(MDB2_TEST_SERIALIZED_DSNS);
self::$dsns = $dsns;
}
public function tearDown()
{
if (!$this->db || MDB2::isError($this->db)) {
return;
}
if ($this->tableExists($this->table2)) {
$this->db->manager->dropTable($this->table2);
}
if ($this->tableExists($this->table)) {
$this->db->manager->dropTable($this->table);
}
parent::tearDown();
}
/**
* Can not use setUp() because we are using a dataProvider to get multiple
* MDB2 objects per test.
*
* @param array $ci an associative array with two elements. The "dsn"
* element must contain an array of DSN information.
* The "options" element must be an array of connection
* options.
*/
protected function manualSetUp($ci)
{
parent::manualSetUp($ci);
$this->db->loadModule('Function', null, true);
}
