flakes/etherpad-lite/etherpad_cleanup.sql

   1 DO $$
   2   DECLARE todelete record;
   3   BEGIN
   4     FOR todelete IN
   5       select split_part(key, ':', 4) as k from store where key like 'mypads:jobqueue:deletePad:%'
   6     LOOP
   7       select * from store where key in (select 'readonly2pad:' || split_part(value, '"', 2) from store where key = 'pad2readonly:' || todelete.k);
   8       select * from store where key = 'pad2readonly:' || todelete.k;
   9       select * from store where key like 'pad:' || todelete.k || ':revs:%';
  10       select * from store where key like 'pad:' || todelete.k || ':chats:%';
  11     END LOOP;
  12   END $$
  13
  14 -- /nix/store/1i77431p6996lbyflpkb803zsiaj24kx-etherpad-lite-1.8.3/node_modules/ep_mypads/scripts/mypads-jobqueue-minion.js
  15 for toDelete in
  16   select split_part(key, ':', 4) from store where key like 'mypads:jobqueue:deletePad:%'
  17 loop
  18   select * from store where key in (select 'readonly2pad:' || split_part(value, '"', 2) from store where key = 'pad2readonly:' || toDelete);
  19   select * from store where key = 'pad2readonly:' || toDelete;
  20   select * from store where key like 'pad:' || toDelete || ':revs:%';
  21   select * from store where key like 'pad:' || toDelete || ':chats:%';
  22 end loop
  23 --select * from store where key in (select 'pad2readonly:' || split_part(key, ':', 4) from store where key like 'mypads:jobqueue:deletePad:%');
  24 --
  25 --delete from store where key in (select 'readonly2pad:' || split_part(value, '"', 2) from store where key in (select 'pad2readonly:' || split_part(key, ':', 4) from store where key like 'mypads:jobqueue:deletePad:%'))
  26 --delete from store where key in (select 'pad2readonly:' || split_part(key, ':', 4) from store where key like 'mypads:jobqueue:deletePad:%');
  27 --delete from store where key like any(select 'pad:' || split_part(key, ':', 4) || ':revs:%' from store where key like 'mypads:jobqueue:deletePad:%');
  28 --delete from store where key like any(select 'pad:' || split_part(key, ':', 4) || ':chats:%' from store where key like 'mypads:jobqueue:deletePad:%');
  29 --delete from store where key like 'mypads:jobqueue:deletePad:%';
  30