]>
Commit | Line | Data |
---|---|---|
1f1c7c69 IB |
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 |