Unable to delete a dashboard ( 3.0.0rc3)

[raghulprashath]

Unable to delete a role-assigned dashboard in 3.0.0rc3

How to reproduce the bug

1. Create a custom role with CRUD dashboard permissions.
2. Make sure the DASHBOARD_RBAC feature is on.
3. Create a dashboard and assign a role to the dashboard.
4. Delete the dashboard - Throws error

Expected results

The dashboard is to be deleted

Actual results

This error is thrown:

sqlalchemy.exc.IntegrityError: (psycopg2.errors.ForeignKeyViolation) update or delete on table "dashboards" violates foreign key constraint "dashboard_roles_dashboard_id_fkey" on table "dashboard_roles" superset_app | DETAIL: Key (id)=(1) is still referenced from table "dashboard_roles".

Screenshots

If applicable, add screenshots to help explain your problem.

Environment

(please complete the following information):

• browser type and version: Chrome (latest version)
• superset version: 3.0.0rc3
• python version: 3.9
• node.js version: 16
• any feature flags active: DASHBOARD_RBAC

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

[john-bodley]

@raghulprashath per my PR description I'm unsure as to why the referenced existing test didn't capture this. Would you mind manually testing my change to see if it remedies your issue?