Weird Random names in constrains generated by Doctrine2 (Symfony2)

Question

For some reason when I generate migration using

php app/console doctrine:migrations:diff

I get weird names for constrains & indexes like FK_FFE561C6BE3BD8D4 & IDX_FFE561C6BE3BD8D4:

$this->addSql("ALTER TABLE agent_task ADD agentConfig_id INT UNSIGNED DEFAULT NULL, DROP agent_id");
$this->addSql("ALTER TABLE agent_task ADD CONSTRAINT FK_FFE561C6BE3BD8D4 FOREIGN KEY (agentConfig_id) REFERENCES agent_config (id)");
$this->addSql("CREATE INDEX IDX_FFE561C6BE3BD8D4 ON agent_task (agentConfig_id)");

The entity code snippet:

    /**
     * @var AgentConfig
     *
     * @ORM\ManyToOne(targetEntity="AgentConfig",inversedBy="agentTasks")
     * @ORM\JoinColumn(name="agent_config_id", referencedColumnName="id")
     */
    private $agentConfig;

Is there any way to define the names for those?

UPDATE

I tried indexes, but it didn't help.

/**
 * AgentTaskConfig
 *
 * @ORM\Table(name="agent_task_config", indexes={@ORM\index(name="agent_task_config_task_id", columns={"task_id"})})
 * @ORM\Entity
 */
class AgentTaskConfig

Still happening:

$this->addSql("ALTER TABLE agent_task_config DROP FOREIGN KEY fk_agent_task_id");
$this->addSql("ALTER TABLE agent_task_config ADD CONSTRAINT FK_7FEDF0EF8DB60186 FOREIGN KEY (task_id) REFERENCES agent_task (id)");

vladykx · Accepted Answer · 2013-09-30 12:21:30Z

8

Having more time I investigated doctrine's (v2.4.x) SchemaTool.php that does the generation. It looks like they are using method:

Table#addUnnamedForeignKeyConstraint($foreignTable, array $localColumnNames, array $foreignColumnNames, array $options=array())

which speaks for itself. It is marked as deprecated with link to:

Table#addForeignKeyConstraint($foreignTable, array $localColumnNames, array $foreignColumnNames, array $options=array(), $constraintName = null)

This method has argument $constraintName, which is not used as of now. I guess the only way is to edit the Schema tool to use the latter method passing your own $constraintName.

The constraint name generation looks like this:

protected function _generateIdentifierName($columnNames, $prefix='', $maxSize=30)
{
    $hash = implode("", array_map(function($column) {
        return dechex(crc32($column));
    }, $columnNames));

    return substr(strtoupper($prefix . "_" . $hash), 0, $maxSize);
}

answered Sep 30, 2013 at 12:21

vladykx

3403 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user4271704 Over a year ago

Please advice how is index generation? The same as above? with exception IDX_ instead of prefix?

Thomas K · Accepted Answer · 2013-09-20 12:08:17Z

5

You can define the indexes yourself on your entities

/**
 *
 * @ORM\Table(name="company", indexes={@ORM\Index(name="model_partner_idx", columns={"partner"})} )
 * @ORM\Entity
 */
class Company

answered Sep 20, 2013 at 12:08

Thomas K

6,2165 gold badges42 silver badges56 bronze badges

2 Comments

vladykx Over a year ago

yes, but this creates the new ones, but doesn't change names of auto generated indexes

Thomas K Over a year ago

You can use the above annotation to overwrite the auto generated indexes

Collectives™ on Stack Overflow

Weird Random names in constrains generated by Doctrine2 (Symfony2)

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related