README

A Symfony bundle that enhances Doctrine ORM with automatic index management.

Features

• Automatically adds indexes to specified entity properties
• Supports regular, fulltext, and unique indexes
• Smart index naming strategy, automatically handles long table names
• Attribute-based configuration (PHP 8 attributes), no extra config files
• Zero configuration required, works out-of-the-box

Requirements

• PHP 8.1 or higher
• Symfony 6.4 or higher
• Doctrine Bundle 2.13 or higher

Installation

composer require tourze/doctrine-indexed-bundle

Usage

1. Register the bundle in config/bundles.php:

return [
    // ...
    Tourze\DoctrineIndexedBundle\DoctrineIndexedBundle::class => ['all' => true],
];

1. Use attributes to mark entity fields that require indexes:

use Tourze\DoctrineIndexedBundle\Attribute\IndexColumn;
use Tourze\DoctrineIndexedBundle\Attribute\FulltextColumn;
use Tourze\DoctrineIndexedBundle\Attribute\UniqueColumn;

class YourEntity
{
    #[ORM\Column]
    #[IndexColumn] // Regular index
    private string $name;

    #[ORM\Column(type: 'text')]
    #[FulltextColumn] // Fulltext index
    private string $description;

    #[ORM\Column]
    #[UniqueColumn] // Unique index
    private string $email;
}

Index Naming Convention

The bundle automatically generates index names as follows:

• Regular index: {table_name}_idx_{column_name}
• Fulltext index: {table_name}_fulltext_{column_name}
• Unique index: {table_name}_unique_{column_name}

If the generated name exceeds the maximum length (64 characters), the bundle will use MD5 hashing to create a shorter name while maintaining uniqueness.

How It Works

• Listens to Doctrine's loadClassMetadata event and scans entity properties.
• Checks for IndexColumn, FulltextColumn, or UniqueColumn attributes on properties.
• Automatically adds the corresponding index to the entity field.
• Naming strategy ensures compatibility with DBMS index name length limits.

Contributing

Feel free to submit issues and pull requests to help improve this bundle.

License

MIT License