How to generate entities from database schema using doctrine-orm-module and zf2

doctrine-orm zend-framework2
Developer picture Developer · Aug 27, 2013 · Viewed 33.4k times · Source

I am using "doctrine/doctrine-orm-module": "0.7.0" with ZF2.

Once I create Entities I usually run following commands to sync and generate database automatically according to my entities. 

./vendor/bin/doctrine-module orm:validate-schema
./vendor/bin/doctrine-module orm:schema-tool:create

Is there a way to make this process reverse? I mean, Can I generate entities from existing database in mysql?

Answer

cptnk picture cptnk · Aug 27, 2013

We use a batch script:

@ECHO OFF

mkdir EXPORT
call .\vendor\bin\doctrine-module orm:convert-mapping --force --from-database annotation ./EXPORT/
call .\vendor\bin\doctrine-module orm:generate-entities ./EXPORT/ --generate-annotations=true

pause

orm:convert-mapping and orm:generate-entities is probably what you are looking for.

Related questions

How to do left join in Doctrine?

This is my function where I'm trying to show the User history. For this I need to display the user's current credits along with his credit history. This is what I am trying to do: public function getHistory($users) { $qb = $…

Read More
Join subquery with doctrine 2 DBAL

I'm refactoring a Zend Framework 2 application to use doctrine 2.5 DBAL instead of Zend_DB (ZF1). I have the following Zend_Db query: $subSelect = $db->select() ->from('user_survey_status_entries', array('userSurveyID', 'timestamp' => 'MIN(timestamp)')) …

Read More
Best way to convert Doctrine 2 entity persistent collection to array with Zend Framework 2

What is best way (easy) to convert Doctrine 2 entity persistent collection to array with Zend Framework 2? I want convert to array and later output it with JsonView. I can write function which use get_object_var but it is a …

Read More