[GitHub] [superset] C-monC commented on issue #13345: cannot delete user "Associated data exists, please delete them first"

[GitBox <gi...@apache.org>]

C-monC commented on issue #13345:
URL: https://github.com/apache/superset/issues/13345#issuecomment-1285604683

   This script has worked for without problems ad I continue to use it. 
   It was written quickly so test it first.
   You probably don't want to search by last_name.
   
   ```
   delete from favstar where user_id in (select id from ab_user where last_name != 'users-lastname');
   delete from key_value where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   delete from key_value where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   delete from logs where user_id in (select id from ab_user where last_name != 'users-lastname');
   delete from ab_user_role where user_id in (select id from ab_user where last_name != 'users-lastname');
   update ab_user set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update ab_user set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update tables set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update tables set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   delete from sql_metrics where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update table_columns set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update table_columns set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update sqlatable_user set user_id=null  where user_id in (select id from ab_user where last_name != 'users-lastname');
   update sl_datasets set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update sl_datasets set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update sl_columns set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update sl_columns set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   
   delete from sl_dataset_users where user_id in (select id from ab_user where last_name != 'users-lastname');
   update dashboards set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update dashboards set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   
   update slices set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update slices set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   delete from dashboard_user where user_id in (select id from ab_user where last_name != 'users-lastname');
   delete from slice_user where user_id in (select id from ab_user where last_name != 'users-lastname');
   update slices set last_saved_by_fk=null  where last_saved_by_fk in (select id from ab_user where last_name != 'users-lastname');
   
   update sl_tables set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update sl_tables set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   
   update annotation_layer set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update annotation_layer set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   
   update tab_state set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update tab_state set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   delete from tab_state where user_id in (select id from ab_user where last_name != 'users-lastname');
   
   update dbs set created_by_fk=null  where created_by_fk in (select id from ab_user where last_name != 'users-lastname');
   update dbs set changed_by_fk=null  where changed_by_fk in (select id from ab_user where last_name != 'users-lastname');
   delete from query where user_id in (select id from ab_user where last_name != 'users-lastname');
   
   delete from ab_user where id in (select id from ab_user where last_name != 'users-lastname');
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org