Symfony2 Import entities from existing database with Doctrine

Question

I am a beginner with symfony. I have tried to follow the official documentation http://symfony.com/doc/current/cookbook/doctrine/reverse_engineering.html to import a entities from MySQL to a symfony2 project in a Debian testing box. but I didn't succeeded.

Then searching here and there I have found this Generating a single Entity from existing database using symfony2 and doctrine here, but I cant make it work, my console: "ask Doctrine to introspect the database and generate the corresponding metadata files"

root@khs01wxl001:/var/www/organizer$ php app/console doctrine:mapping:import --force organizerscheduleBundle php
Importing mapping information from "default" entity manager
  > writing /var/www/organizer/src/organizer/scheduleBundle/Resources/config/doctrine/Dept.orm.php
  > writing /var/www/organizer/src/organizer/scheduleBundle/Resources/config/doctrine/Desg.orm.php
  > writing /var/www/organizer/src/organizer/scheduleBundle/Resources/config/doctrine/Dir.orm.php
  > writing /var/www/organizer/src/organizer/scheduleBundle/Resources/config/doctrine/Schedule.orm.php
  > writing /var/www/organizer/src/organizer/scheduleBundle/Resources/config/doctrine/Username.orm.php
  > writing /var/www/organizer/src/organizer/scheduleBundle/Resources/config/doctrine/Userrole.orm.php
root@khs01wxl001:/var/www/organizer$

So far so good, but now "you can ask Doctrine to build related entity classes by executing the following two commands.

$ php app/console doctrine:mapping:convert annotation ./src
$ php app/console doctrine:generate:entities AcmeBlogBundle

but when I do it the first one doesn't work for me:

root@khs01wxl001:/var/www/organizer$ php app/console doctrine:mapping:convert annotation ./src/organizer/scheduleBundle/Resources/config/doctrine/
No Metadata Classes to process.
root@khs01wxl001:/var/www/organizer$

Any suggestion?

M. Foti · Accepted Answer · 2013-09-06 10:24:26Z

6

Try with:

# write the structure to annotation file (I prefear to use YML instead annotation but should be the same) 
$ php app/console doctrine:mapping:convert annotation ./src/organizer/scheduleBundle/Resources/config/doctrine/metadata/orm --from-database --force

# Import the structure
$ php app/console doctrine:mapping:import organizerscheduleBundle annotation

# Generate Entities file class
$ php app/console doctrine:generate:entities organizerscheduleBundle

More docs here:

http://docs.doctrine-project.org/en/2.0.x/reference/tools.html#reverse-engineering

Not all will be imported (the doc says 70-80% but in my opinion is less).

PS. A best pratice is to call the bundle OrganizerScheduleBundle (look uppercase letters) with organizer as company name, so inside the developer/company name folder there will be all the bundles.

answered Sep 6, 2013 at 10:24

M. Foti

3,1922 gold badges18 silver badges14 bronze badges

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

1 Comment

Abel Over a year ago

Hi; I have solved it a while ago, but the true now is that I do not really remember how! The next time I ask I will be more accountable for interaction with the community Thank you guys and I am sorry about forgetting about this post, it will not happen again.

Johan Alexis Duque Cadena · Accepted Answer · 2016-02-23 08:13:59Z

1

If you are using symfony 3 and wanna use the annotations, i used this:

php bin/console doctrine:mapping:import --force AcmeBlogBundle annotation

This generate all you need, without needing the doctrine:mapping:convert

answered Feb 23, 2016 at 8:13

Johan Alexis Duque Cadena

5378 silver badges22 bronze badges

Collectives™ on Stack Overflow

Symfony2 Import entities from existing database with Doctrine

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related