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

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -