Contao\CoreBundle\Test\Doctrine\Schema\DcaSchemaProviderTest::testTableOptions PHP Method

testTableOptions() public method

Test the table options.
public testTableOptions ( )
    public function testTableOptions()
    {
        $provider = $this->getProvider(['tl_member' => ['TABLE_OPTIONS' => 'ENGINE=MyISAM DEFAULT CHARSET=utf8']]);
        $schema = $provider->createSchema();
        $this->assertCount(1, $schema->getTableNames());
        $this->assertTrue($schema->hasTable('tl_member'));
        $this->assertEquals('MyISAM', $schema->getTable('tl_member')->getOption('engine'));
        $this->assertEquals('utf8', $schema->getTable('tl_member')->getOption('charset'));
        $provider = $this->getProvider([], ['tl_member' => ['TABLE_OPTIONS' => 'ENGINE=MyISAM DEFAULT CHARSET=utf8']]);
        $schema = $provider->createSchema();
        $this->assertCount(1, $schema->getTableNames());
        $this->assertTrue($schema->hasTable('tl_member'));
        $this->assertEquals('MyISAM', $schema->getTable('tl_member')->getOption('engine'));
        $this->assertEquals('utf8', $schema->getTable('tl_member')->getOption('charset'));
        $provider = $this->getProvider(['tl_member' => ['TABLE_OPTIONS' => 'ENGINE=InnoDB DEFAULT CHARSET=Latin1']]);
        $schema = $provider->createSchema();
        $this->assertCount(1, $schema->getTableNames());
        $this->assertTrue($schema->hasTable('tl_member'));
        $this->assertEquals('InnoDB', $schema->getTable('tl_member')->getOption('engine'));
        $this->assertEquals('Latin1', $schema->getTable('tl_member')->getOption('charset'));
    }