ExportOracleTestCase.php 811 Bytes
Newer Older
zYne's avatar
zYne committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
<?php
class Doctrine_Export_Oracle_TestCase extends Doctrine_Export_TestCase {
    public function __construct() {
        parent::__construct('oci');
    }
    public function testCreateSequenceExecutesSql() {
        $sequenceName = 'sequence';
        $start = 1;
        $query = 'CREATE SEQUENCE ' . $sequenceName . ' START WITH ' . $start . ' INCREMENT BY 1 NOCACHE';

        $this->export->createSequence($sequenceName, $start);
        
        $this->assertEqual($this->adapter->pop(), $query);
    }

    public function testDropSequenceExecutesSql() {
        $sequenceName = 'sequence';

        $query = 'DROP SEQUENCE ' . $sequenceName;;

        $this->export->dropSequence($sequenceName);
        
        $this->assertEqual($this->adapter->pop(), $query);
    }
}
?>