graze / morphism

     * @param string $expected

     * @dataProvider diffProvider

     */

    public function testDiff($firstTableText, $secondTableText, $expected)

    {

        $collation = new CollationInfo();

        $firstStream = $this->makeStream($firstTableText);

        $firstTable = new CreateTable($collation);

        $firstTable->setDefaultEngine('InnoDB');

        $firstTable->parse($firstStream);

        $secondStream = $this->makeStream($secondTableText);

        $secondTable = new CreateTable($collation);

        $secondTable->setDefaultEngine('InnoDB');

        $secondTable->parse($secondStream);

        $diff = $firstTable->diff($secondTable);

        $this->assertEquals($expected == "" ? [] : [$expected], $diff);

    }

    /**

     * @return array

     * @param array $flags

     * @param string $expected

     */

    public function testAlterEngineDiff(array $flags, $expected)

    {

        $sql = 'create table t (a int)';

        $collation = new CollationInfo();

        $firstStream = $this->makeStream($sql);

        $firstTable = new CreateTable($collation);

        $firstTable->setDefaultEngine('InnoDb');

        $firstTable->parse($firstStream);

        $secondStream = $this->makeStream($sql);

        $secondTable = new CreateTable($collation);

        $secondTable->setDefaultEngine('MyISAM');

        $secondTable->parse($secondStream);

        $diff = $firstTable->diff($secondTable, $flags);

        $this->assertEquals($expected, $diff);

    }

    /**

     * @return array