ban+delete CTE

ban_n_delete.md

with usr as (
  select 1111111 as id  -- <<< EDIT USER ID HERE!
), collections_d as (
  delete from collection
  where user_id in (select id from usr) returning id
), posts_d as (
  delete from post
  where user_id in (select id from usr) returning id
), comments_d as (
  delete from post_comment
  where user_id in (select id from usr) returning id
), ban as (
  update person set status = 'banned'
  where status <> 'banned' and id in (select id from usr) returning id
)
select
  (select count(*) from collections_d) as collections_deleted,
  (select count(*) from posts_d) as posts_deleted,
  (select count(*) from comments_d) as comments_deleted,
  (select count(*) from ban) as users_banned
;