Zend Certified Engineer (PHP5, ZF), Web Programming, LINUX

I always use Bisna library to integrate Doctrine 2.X with Zend Framework 1.X. This library is created by Guilherme Blanco an Open Source Evangelist and Software Engineer in Yahoo!.

The important thing in Doctrine 2 ORM is the entity. It is just PHP class, that act as the mapper from table in database. For small project with a few tables, make entity manually is not difficult. But in big project with many tables with complicated relation, make entities manually is not easy. It will be easy if we design the tables with tools like MySQL Workbench, create the tables from it, then make the entities with reverse engineering by use Doctrine Console.

Bisna library has prepare Doctrine Console bin/doctrine.php. Based on Bisna configuration on application/configs/application.ini, the driver used is Annotation (see line 124). To make reverse engineering please use this command

$ php doctrine orm:convert-mapping --from-database annotation /path/to/mapping-path-converted-to-annotation

/path/to/mapping-path-converted-to-annotation must same with mappingDirs in application/configs/application.ini (see line 126)

Doctrine Console will generate some PHP files. On each file contain a class with property as mapper from database. Those class have ready to use as entities for Doctrine 2 ORM. But those class still don't have getter and setter. They can be added automatically with this command

$ php doctrine orm:generate-entities --generate-annotations=1 /path/to/entity

/path/to/entity must same with mappingNamespace in application/configs/application.ini (see line 125)

Doctrine Console usage above are enough to get entities by reverse engineering. And if you want get mapper in another type like xml or yaml, just change the type from the type used in convert-mapping.

$ php doctrine orm:convert-mapping --from-database xml /path/to/mapping-path-converted-to-xml

$ php doctrine orm:convert-mapping --from-database yaml /path/to/mapping-path-converted-to-yaml

And to generate entities from those mapping so, please change the driver used in application/configs/application.ini (see line 124). Change it with

"Doctrine\ORM\Mapping\Driver\XmlDriver"

or

"Doctrine\ORM\Mapping\Driver\YamlDriver"

Then use Doctrine Console again

$ php doctrine orm:generate-entities --generate-annotations=1 /path/to/entity