How to use an existing Database with Symfony 6 and Doctrine

Question

I want to use an existing MariaDB with a new Symfony 6 project and Doctrine.

Unfortunately, I don't understand how to create the entities and repository from an existing database. The database is very complex and has a lot of relations. Is there an importer for this?

The following command seems to be deprecated. It works, but only creates the entities (but probably not completely correct).

symfony console doctrine:mapping:import "App\Entity" annotation --path=src/Entity

Thanks for your help.

Did you try to use the maker bundle: symfony.com/doc/current/doctrine/reverse_engineering.html ? — Mohameth
– Mohameth, Commented Oct 4, 2022 at 12:04
Thats what i tried right but the relations and factories are not produced. — Hannes
– Hannes, Commented Oct 4, 2022 at 15:43
@Hannes In general Doctrine ORM is intended to be developed within an application by using an Entity first approach. There are a great deal of things that will be broken when relying on mapping out the entities from a database because of limitations imposed by the ORM. For example DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP and other expressions. While it may be possible, if you are not intimately familiar with the ORM you will run into problems. — Will B.
– Will B., Commented Nov 1, 2022 at 22:02

Hadrien Delphin · Accepted Answer · 2022-10-04 12:42:05Z

2

You can use this kind of command :

symfony console doctrine:mapping:import "App\Entity" annotation --path=src/Entity

But be aware that this solution is deprecated.

What Symfony's team recommend is to create you entities yourself using the maker bundle.

Keep in mind that the maker only generate PHP classes, so you shall be able to reproduce your entities this way. It's gonna take you some time, but it's the best way to do actually.

Just be careful with the naming of your relations (especially with the many to many pivot tables) wich may not be as generic as what the maker bundle generate

answered Oct 4, 2022 at 12:42

Hadrien Delphin

6201 gold badge7 silver badges19 bronze badges

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

1 Comment

Hannes Over a year ago

I had already tried that. But it also means that I can't create the relations or the factories with it. I have to do that manually... is that correct or is there an automatism for that?

Collectives™ on Stack Overflow

How to use an existing Database with Symfony 6 and Doctrine

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related