Show Database Association Incompatibilities

[umer936]

Description

A few times now I have had where the belongsToManys don't match up and I get the error about it.

e.g. this using the join table was wrong due to foreign key mismatches.

        $this->belongsToMany('Roles', [
            'joinTable' => 'download_layouts_roles',
            'foreignKey' => 'download_layout_id',
            'targetForeignKey' => 'id',
            'dependent' => true,
        ]);

        $this->belongsToMany('DownloadLayouts', [
            'foreignKey' => 'role_id',
            'targetForeignKey' => 'download_layout_id',
            'joinTable' => 'download_layouts_roles',
        ]);

My solution has been to rebake the Models using bin/cake bake model --update and compare with git diff.
But given that there's a check routes, maybe there could be a database check as well? Would be helpful to run as like a CI command when running the PHP testing tools and to be told what to fix.

Unsure if this exists in other frameworks.

CakePHP Version

4.5.0

[LordSimal]

Refs: cakephp/bake#592

[dereuromark]

Should we close this given that this seems to be more a sattelite issue (plugins or custom solutions?)