Repository files navigation

For one reason or another you will build an ORM on top of an existing database. The existing database maynot have referential integrity for all it's relationships.

You now have a database with an ORM and there is probably bad data in the database which does not conformto the relationships defined in the ORM.

This tool is intended for devleopment only.

Create a report by scanning every relationship defined in your ORM for datawhich is missing it's foreign key. Nullable relationships are not evaluated.

php index.php orm:data-validation:relationship --object-manager="doctrine.entitymanager.orm_default"

This will output TSV with the Count, Distinct Values, Child Field, Child Entity, Parent Entity, and the SQL to duplicate the results for all relationships where data is found in the child which references data not found in the parent.

composerrequire"api-skeletons/zf-doctrine-orm-data-validation":"^1.0"

Add toconfig/development.config.php.dist:

return array('modules' =>array('ZF\\Doctrine\\ORM\\DataValidation'        ...    ),

Enable development mode to copydevelopment.config.php.dist todevelopment.config.php