php - Doctrine fails to persist on record delete -


when user want's delete record (language in case) want prevent deletion of record (language) if it's referenced in other table in system.

problem language (record) in case gets deleted if it's referenced in other table. checked relationships in mysql workbench , says on delete , on update restrict action reason doctrine/symfony allows delete of same field.

does knows problem?

here entity setup:

/**      *  many drivers have many langauges (owning side)      *      * @orm\manytomany(targetentity="language", inversedby="language", cascade={"persist"})      * @orm\jointable(name="bus_drivers_languages",      *     joincolumns={@orm\joincolumn(name="bus_driver_id", referencedcolumnname="id")},      *     inversejoincolumns={@orm\joincolumn(name="languages_id", referencedcolumnname="id")}      * )      **/      private $languages;    /**      * @var arraycollection      *      * @orm\manytomany(targetentity="busdriver", mappedby="languages", cascade={"persist"})      */      protected $language; 

you can enforce @ database level (that way maintain consistency throughout application)...

alter table `table_name` add constraint `constraint_name` foreign key (`column_list`) references `referenced_table` (`referenced_column_list`); 

Comments

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

angular - password and confirm password field validation angular2 reactive forms -

php - Permission denied. Laravel linux server -