Graze\Morphism\Parse\IndexDefinitionTest

Complexity

Total Complexity

9

Size/Duplication

Total Lines	190
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	testBadParse()	0	8	1
A	badParseProvider()	0	12	1
A	parseProvider()	0	69	1
A	testCovers()	0	12	1
A	testParse()	0	11	2
A	providerColumns()	0	7	1
A	testColumns()	0	9	1
A	providerCovers()	0	7	1

<?php

namespace Graze\Morphism\Parse;

use Graze\Morphism\Test\Parse\TestCase;
use LogicException;
use RuntimeException;

class IndexDefinitionTest extends TestCase
{
    /**
     * @dataProvider parseProvider
     * @param string $type
     * @param string $text
     * @param string|null $constraint
     * @param string $expected
     */
    public function testParse($type, $text, $constraint, $expected)
    {
        $stream = $this->makeStream($text);

        $index = new IndexDefinition();
        $index->parse($stream, $type, $constraint);
        if (is_null($index->name)) {
            $index->name = 'k1';
        }

        $this->assertSame($expected, $index->toString());
    }

    /**
     * @return array
     */
    public function parseProvider()
    {
        return [
            // [ type, text, constraint, expected ]
            ["PRIMARY KEY", "(a)",       null, "PRIMARY KEY (`a`)"],

            ["UNIQUE KEY", "(a)",        null, "UNIQUE KEY `k1` (`a`)"],
            ["UNIQUE KEY", "k (a)",      null, "UNIQUE KEY `k` (`a`)"],
            ["UNIQUE KEY", "(a)",        'foo', "UNIQUE KEY `foo` (`a`)"],

            ["FULLTEXT KEY", "(a)",      null, "FULLTEXT KEY `k1` (`a`)"],
            ["FULLTEXT KEY", "k (a)",    null, "FULLTEXT KEY `k` (`a`)"],
            ["FULLTEXT KEY", "(a) WITH PARSER foo_parser", null, "FULLTEXT KEY `k1` (`a`) WITH PARSER foo_parser"],

            ["KEY", "(a)",               null, "KEY `k1` (`a`)"],
            ["KEY", "(a ASC)",           null, "KEY `k1` (`a`)"],
            ["KEY", "(a DESC)",          null, "KEY `k1` (`a`)"],
            ["KEY", "k (a)",             null, "KEY `k` (`a`)"],
            ["KEY", "(a,b,c)",           null, "KEY `k1` (`a`,`b`,`c`)"],
            ["KEY", "(a,b,c)",           null, "KEY `k1` (`a`,`b`,`c`)"],
            ["KEY", "(a(10))",           null, "KEY `k1` (`a`(10))"],
            ["KEY", "(a(10),b(12))",     null, "KEY `k1` (`a`(10),`b`(12))"],
            ["KEY", "USING BTREE (a)",   null, "KEY `k1` (`a`) USING BTREE"],
            ["KEY", "k USING BTREE (a)", null, "KEY `k` (`a`) USING BTREE"],
            ["KEY", "(a) USING BTREE",   null, "KEY `k1` (`a`) USING BTREE"],
            ["KEY", "(a) USING HASH",    null, "KEY `k1` (`a`) USING HASH"],
            ["KEY", "(a) KEY_BLOCK_SIZE 10", null, "KEY `k1` (`a`) KEY_BLOCK_SIZE=10"],
            ["KEY", "(a) KEY_BLOCK_SIZE=10", null, "KEY `k1` (`a`) KEY_BLOCK_SIZE=10"],
            ["KEY", "(a) KEY_BLOCK_SIZE=0",  null, "KEY `k1` (`a`)"],
            ["KEY", "(a) COMMENT 'foo'",     null, "KEY `k1` (`a`) COMMENT 'foo'"],
            ["KEY", "(a) COMMENT ''",        null, "KEY `k1` (`a`)"],
            ["KEY", "(a) COMMENT 'foo' USING BTREE KEY_BLOCK_SIZE=10", null,
                "KEY `k1` (`a`) USING BTREE KEY_BLOCK_SIZE=10 COMMENT 'foo'"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta)", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`)"],

            ["FOREIGN KEY",  "(a) REFERENCES foo.t(ta)", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `foo`.`t` (`ta`)"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta(10))", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`(10))"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON DELETE RESTRICT", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`)"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON DELETE CASCADE", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON DELETE CASCADE"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON DELETE NO ACTION", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON DELETE NO ACTION"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON DELETE SET NULL", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON DELETE SET NULL"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON UPDATE RESTRICT", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`)"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON UPDATE CASCADE", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON UPDATE CASCADE"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON UPDATE NO ACTION", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON UPDATE NO ACTION"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON UPDATE SET NULL", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON UPDATE SET NULL"],

            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON UPDATE NO ACTION ON DELETE NO ACTION", "c1",
                "CONSTRAINT `c1` FOREIGN KEY (`a`) REFERENCES `t` (`ta`) ON DELETE NO ACTION ON UPDATE NO ACTION"],

        ];
    }

    /**
     * @dataProvider badParseProvider
     * @param string $type
     * @param string $text
     * @param string $exception
     */
    public function testBadParse($type, $text, $exception)
    {
        $stream = $this->makeStream($text);

        $this->expectException($exception);

        $index = new IndexDefinition();
        $index->parse($stream, $type);
    }

    /**
     * @return array
     */
    public function badParseProvider()
    {
        return [
            // [ type, text ]
            // Invalid key type
            ["INVALID_INDEX_TYPE", "foo", LogicException::class],
            // Invalid tree type
            ["KEY", "USING FOOTREE (a)", RuntimeException::class],
            // Unsupported 'MATCH' keyword
            ["FOREIGN KEY",  "(a) REFERENCES t(ta) MATCH FULL", RuntimeException::class],
            // Unsupported reference action
            ["FOREIGN KEY",  "(a) REFERENCES t(ta) ON UPDATE FOO", RuntimeException::class],
        ];
    }

    /**
     * @dataProvider providerCovers
     * @param string $text
     * @param array $expected
     */
    public function testCovers($text, array $expected)
    {
        $stream = $this->makeStream($text);

        $index = new IndexDefinition();
        $index->parse($stream, 'KEY');
        $covers = $index->getCovers();

        sort($expected);
        sort($covers);

        $this->assertSame($covers, $expected);
    }

    /**
     * @return array
     */
    public function providerCovers()
    {
        return [
            [ '(x)',         [['x']] ],
            [ '(x,y)',       [['x'], ['x','y']] ],
            [ '(x,y,z)',     [['x'], ['x','y'], ['x','y','z']] ],
            [ '(x,y(10),z)', [['x'], ['x','y(10)'], ['x','y(10)','z']] ],
        ];
    }

    /**
     * @dataProvider providerColumns()
     * @param string $text
     * @param array $expected
     */
    public function testColumns($text, array $expected)
    {
        $stream = $this->makeStream($text);

        $index = new IndexDefinition();
        $index->parse($stream, 'KEY');
        $columns = $index->getColumns();

        $this->assertSame($columns, $expected);
    }

    /**
     * @return array
     */
    public function providerColumns()
    {
        return [
            [ '(x)',         ['x'] ],
            [ '(x,y)',       ['x','y'] ],
            [ '(x,y,z)',     ['x','y','z'] ],
            [ '(x,y(10),z)', ['x','y(10)','z'] ],
        ];
    }
}