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;");
}
}