Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 1 |
CRAP | |
0.00% |
0 / 20 |
Oracle | |
0.00% |
0 / 1 |
|
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 20 |
cleanup() | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 20 |
<?php | |
namespace Codeception\Util\Driver; | |
class Oracle extends Db | |
{ | |
public function cleanup() { | |
$this->dbh->exec("BEGIN | |
FOR i IN (SELECT trigger_name FROM user_triggers) | |
LOOP | |
EXECUTE IMMEDIATE('DROP TRIGGER ' || user || '.' || i.trigger_name); | |
END LOOP; | |
END;"); | |
$this->dbh->exec("BEGIN | |
FOR i IN (SELECT table_name FROM user_tables) | |
LOOP | |
EXECUTE IMMEDIATE('DROP TABLE ' || user || '.' || i.table_name || ' CASCADE CONSTRAINTS'); | |
END LOOP; | |
END;"); | |
$this->dbh->exec("BEGIN | |
FOR i IN (SELECT sequence_name FROM user_sequences) | |
LOOP | |
EXECUTE IMMEDIATE('DROP SEQUENCE ' || user || '.' || i.sequence_name); | |
END LOOP; | |
END;"); | |
} | |
} |