public function testListSequences() { if(!$this->_conn->getDatabasePlatform()->supportsSequences()) { $this->markTestSkipped($this->_conn->getDriver()->getName().' does not support sequences.'); } $sequence = new \Doctrine\DBAL\Schema\Sequence('list_sequences_test_seq', 20, 10); $this->_sm->createSequence($sequence); $sequences = $this->_sm->listSequences(); $this->assertType('array', $sequences, 'listSequences() should return an array.'); $foundSequence = null; foreach($sequences AS $sequence) { $this->assertType('Doctrine\DBAL\Schema\Sequence', $sequence, 'Array elements of listSequences() should be Sequence instances.'); if(strtolower($sequence->getName()) == 'list_sequences_test_seq') { $foundSequence = $sequence; } } $this->assertNotNull($foundSequence, "Sequence with name 'list_sequences_test_seq' was not found."); $this->assertEquals(20, $foundSequence->getAllocationSize(), "Allocation Size is expected to be 20."); $this->assertEquals(10, $foundSequence->getInitialValue(), "Initial Value is expected to be 10."); }