GitHub user dosubot[bot] added a comment to the discussion: How to allow the
deletion of users with associated objects
<!-- Answer -->
To allow the deletion of users who have associated objects, you can remove
foreign key constraints that prevent the deletion. In the context of Apache
Superset, the `upgrade()` function in a migration script removes foreign key
constraints for the `sl_dataset_users` table and then drops the table itself.
This action allows users to be deleted even if they have associated objects in
the `sl_dataset_users` table. Here's a code snippet illustrating this:
```python
def upgrade():
if has_table(table_name):
drop_fks_for_table(table_name)
op.drop_table(table_name)
```
This code checks if the `sl_dataset_users` table exists, removes its foreign
key constraints using `drop_fks_for_table`, and then drops the table, thus
allowing the deletion of users with associated objects
<sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2024-08-13_15-27_e53fd48cc078_remove_sl_dataset_users.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great
Response](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=great_response)
| [Irrelevant
Answer](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=irrelevant_answer)
| [Incorrect
Sources](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=incorrect_sources)
| [Too
Verbose](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=hallucination)
| [Bug
Report](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/d9cc5c0b-00b9-4e0b-a99c-239b39a881ac?feedback_type=other)</sup>
GitHub link:
https://github.com/apache/superset/discussions/32807#discussioncomment-12590964
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to:
notifications-unsubscr...@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
