Doctrine\Tests\DBAL\Schema\IndexTest

Complexity

Total Complexity

14

Size/Duplication

Total Lines	169
Duplicated Lines	27.22 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

14 Methods

Rating	Name	Duplication	Size	Complexity
A	createIndex()	0	4	1
A	testCreateIndex()	0	10	1
A	testCreatePrimary()	0	6	1
A	testCreateUnique()	0	6	1
A	testFulfilledByUnique()	9	9	1
A	testFulfilledByPrimary()	9	9	1
A	testFulfilledByIndex()	0	11	1
A	testCompoundedPrimaryKeyDoesNotFullfillSingleUniqueIndex()	0	8	1
A	testFulfilledWithPartial()	14	14	1
A	testFulfilledByCompounded()	0	8	1
A	testOverrulesWithPartial()	14	14	1
A	testFlags()	0	15	1
A	testIndexQuotes()	0	11	1
A	testOptions()	0	13	1

<?php

namespace Doctrine\Tests\DBAL\Schema;

use Doctrine\DBAL\Schema\Index;

class IndexTest extends \PHPUnit_Framework_TestCase
{
    public function createIndex($unique = false, $primary = false, $options = array())
    {
        return new Index("foo", array("bar", "baz"), $unique, $primary, array(), $options);
    }

    public function testCreateIndex()
    {
        $idx = $this->createIndex();
        $this->assertEquals("foo", $idx->getName());
        $columns = $idx->getColumns();
        $this->assertEquals(2, count($columns));
        $this->assertEquals(array("bar", "baz"), $columns);
        $this->assertFalse($idx->isUnique());
        $this->assertFalse($idx->isPrimary());
    }

    public function testCreatePrimary()
    {
        $idx = $this->createIndex(false, true);
        $this->assertTrue($idx->isUnique());
        $this->assertTrue($idx->isPrimary());
    }

    public function testCreateUnique()
    {
        $idx = $this->createIndex(true, false);
        $this->assertTrue($idx->isUnique());
        $this->assertFalse($idx->isPrimary());
    }

    /**
     * @group DBAL-50
     */
    public function testFulfilledByUnique()

This method seems to be duplicated in your project.

    {
        $idx1 = $this->createIndex(true, false);
        $idx2 = $this->createIndex(true, false);
        $idx3 = $this->createIndex();

        $this->assertTrue($idx1->isFullfilledBy($idx2));
        $this->assertFalse($idx1->isFullfilledBy($idx3));
    }

    /**
     * @group DBAL-50
     */
    public function testFulfilledByPrimary()

This method seems to be duplicated in your project.

    {
        $idx1 = $this->createIndex(true, true);
        $idx2 = $this->createIndex(true, true);
        $idx3 = $this->createIndex(true, false);

        $this->assertTrue($idx1->isFullfilledBy($idx2));
        $this->assertFalse($idx1->isFullfilledBy($idx3));
    }

    /**
     * @group DBAL-50
     */
    public function testFulfilledByIndex()
    {
        $idx1 = $this->createIndex();
        $idx2 = $this->createIndex();
        $pri = $this->createIndex(true, true);
        $uniq = $this->createIndex(true);

        $this->assertTrue($idx1->isFullfilledBy($idx2));
        $this->assertTrue($idx1->isFullfilledBy($pri));
        $this->assertTrue($idx1->isFullfilledBy($uniq));
    }

    public function testCompoundedPrimaryKeyDoesNotFullfillSingleUniqueIndex()
    {
        $primary = new Index("the_primary", array("foo", "bar"), true, true);
        $unique = new Index("uniq_foo", array("foo"), true, false);

        self::assertFalse($primary->isFullfilledBy($unique));
        self::assertFalse($unique->isFullfilledBy($primary));
    }

    public function testFulfilledWithPartial()

This method seems to be duplicated in your project.

    {
        $without = new Index('without', array('col1', 'col2'), true, false, array(), array());
        $partial = new Index('partial', array('col1', 'col2'), true, false, array(), array('where' => 'col1 IS NULL'));
        $another = new Index('another', array('col1', 'col2'), true, false, array(), array('where' => 'col1 IS NULL'));

        $this->assertFalse($partial->isFullfilledBy($without));
        $this->assertFalse($without->isFullfilledBy($partial));

        $this->assertTrue($partial->isFullfilledBy($partial));

        $this->assertTrue($partial->isFullfilledBy($another));
        $this->assertTrue($another->isFullfilledBy($partial));
    }

    public function testFulfilledByCompounded()
    {
        $compounded = new Index('compounded', array('col1', 'col2'), true, false, array(), array());
        $single = new Index('single', array('col1'), true, false, array(), array());

        self::assertTrue($single->isFullfilledBy($compounded));
        self::assertFalse($compounded->isFullfilledBy($single));
    }

    public function testOverrulesWithPartial()

This method seems to be duplicated in your project.

    {
        $without = new Index('without', array('col1', 'col2'), true, false, array(), array());
        $partial = new Index('partial', array('col1', 'col2'), true, false, array(), array('where' => 'col1 IS NULL'));
        $another = new Index('another', array('col1', 'col2'), true, false, array(), array('where' => 'col1 IS NULL'));

        $this->assertFalse($partial->overrules($without));
        $this->assertFalse($without->overrules($partial));

        $this->assertTrue($partial->overrules($partial));

        $this->assertTrue($partial->overrules($another));
        $this->assertTrue($another->overrules($partial));
    }

    /**
     * @group DBAL-220
     */
    public function testFlags()
    {
        $idx1 = $this->createIndex();
        $this->assertFalse($idx1->hasFlag('clustered'));
        $this->assertEmpty($idx1->getFlags());

        $idx1->addFlag('clustered');
        $this->assertTrue($idx1->hasFlag('clustered'));
        $this->assertTrue($idx1->hasFlag('CLUSTERED'));
        $this->assertSame(array('clustered'), $idx1->getFlags());

        $idx1->removeFlag('clustered');
        $this->assertFalse($idx1->hasFlag('clustered'));
        $this->assertEmpty($idx1->getFlags());
    }

    /**
     * @group DBAL-285
     */
    public function testIndexQuotes()
    {
        $index = new Index("foo", array("`bar`", "`baz`"));

        $this->assertTrue($index->spansColumns(array("bar", "baz")));
        $this->assertTrue($index->hasColumnAtPosition("bar", 0));
        $this->assertTrue($index->hasColumnAtPosition("baz", 1));

        $this->assertFalse($index->hasColumnAtPosition("bar", 1));
        $this->assertFalse($index->hasColumnAtPosition("baz", 0));
    }

    public function testOptions()
    {
        $idx1 = $this->createIndex();
        $this->assertFalse($idx1->hasOption('where'));
        $this->assertEmpty($idx1->getOptions());

        $idx2 = $this->createIndex(false, false, array('where' => 'name IS NULL'));
        $this->assertTrue($idx2->hasOption('where'));
        $this->assertTrue($idx2->hasOption('WHERE'));
        $this->assertSame('name IS NULL', $idx2->getOption('where'));
        $this->assertSame('name IS NULL', $idx2->getOption('WHERE'));
        $this->assertSame(array('where' => 'name IS NULL'), $idx2->getOptions());
    }
}