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

testFulltextIndex() public method

Tests adding a fulltext index.
public testFulltextIndex ( )
    public function testFulltextIndex()
    {
        $provider = $this->getProvider(['tl_search' => ['TABLE_FIELDS' => ['text' => '`text` mediumtext NULL'], 'TABLE_CREATE_DEFINITIONS' => ['text' => 'FULLTEXT KEY `text` (`text`)']]]);
        $schema = $provider->createSchema();
        $this->assertCount(1, $schema->getTableNames());
        $this->assertTrue($schema->hasTable('tl_search'));
        $table = $schema->getTable('tl_search');
        $this->assertTrue($table->hasColumn('text'));
        $this->assertEquals('text', $table->getColumn('text')->getType()->getName());
        $this->assertEquals(false, $table->getColumn('text')->getNotnull());
        $this->assertEquals(false, $table->getColumn('text')->getFixed());
        $this->assertEquals(MySqlPlatform::LENGTH_LIMIT_MEDIUMTEXT, $table->getColumn('text')->getLength());
        $this->assertTrue($table->hasIndex('text'));
        $this->assertFalse($table->getIndex('text')->isUnique());
        $this->assertEquals(['fulltext'], $table->getIndex('text')->getFlags());
    }