CODEWITHSUNDEEP
mysqlsymfonydoctrine-ormfull-text-search
gremo
gremo

Reputation: 48909

Add a FULLTEXT index in Doctrine 2 using annotations?

I know that Doctrine 2 doesn't support FULLTEXT indexes. I'm actually using a result set mapping and native queries to FULLTEXT search innodb tables (MySQL 5.6). But I still need to mark one or more entity fields as part of the index.

Is there any way to add the index using annotations? It seems that @Index annotation doesn't specify the type of...

Upvotes: 30

Views: 16438

Answers (3)

long
long

Reputation: 4318

Since Doctrine 2.9 using PHP 8 attributes:

<?php
#[ORM\Index(columns: ['name'], name: 'name_idx', flags: ['fulltext'])]
#[ORM\Entity(repositoryClass: ItemRepository::class)]
class Item {
    #[ORM\Column(type: Types::TEXT)]
    private string $name;
}

Source: https://www.doctrine-project.org/projects/doctrine-orm/en/2.16/reference/attributes-reference.html#attrref_index

Upvotes: 5

dened
dened

Reputation: 4310

According to DDC-3014 in the issue tracker of Doctrine, the possibility to specify full-text indices using annotations was implemented on April 14 and will be available in release 2.5. If you don't like to wait, you could try to use the unstable, development version or to backport the commit implementing the feature.

Here is a usage example:

/**
* @Entity
* @Table(indexes={@Index(columns={"content"}, flags={"fulltext"})})
*/
class Comment
{
    /**
    * @Column(type="text")
    */
    private $content;

    ...
}

Upvotes: 60

Markus Liechti
Markus Liechti

Reputation: 39

Here is an example how to make a fulltext index with the yaml mapping driver.

Doctrine\Tests\ORM\Mapping\Comment:
    type: entity
    fields:
        content:
            type: text
    indexes:
        xy_fulltext:
            columns: ["name", "content", "keywords"]
            flags: fulltext

Upvotes: 3

Related Questions