How to make Doctrine Migrations adding quotes to table names?

Asked Apr 15 '20 at 18:46

Active Apr 15 '20 at 18:46

Viewed 228 times

I want to use Doctrine Migrations with existing database. Table names in this database has a dash, for example: calendar-history

I use doctrine:mapping:import command to create entities from database and it works well. Then I want to create first migration, so I use doctrine:migrations:diff. And then I have a problem because it creates queries without quotes, like:

ALTER TABLE calendar-history DROP FOREIGN KEY calendar-history_ibfk_2

I've tried to:

Add quotes to entity definition: @ORM\Table(name="`calendar-history`",
Add a custom QuoteStrategy class

... and it works only with queries in down() method. The queries in up() method in the migration still are without quotes.

Any help?

asked Apr 15 '20 at 18:46

tnx

Have you tried escaping the backticks? – Amelia Magee Apr 15 '20 at 19:01
@AmeliaMagee yes but it doesn't help. – tnx Apr 15 '20 at 19:12
Doctrine does not support back ticking table names. It was a basic design choice. For all intents and purposes, you will need to use a schema that does not require back ticks or use a different ORM. – Cerad Apr 16 '20 at 00:09

How to make Doctrine Migrations adding quotes to table names?

0 Answers0