diff options
Diffstat (limited to 'flakes/etherpad-lite/etherpad_cleanup.sql')
-rw-r--r-- | flakes/etherpad-lite/etherpad_cleanup.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/flakes/etherpad-lite/etherpad_cleanup.sql b/flakes/etherpad-lite/etherpad_cleanup.sql new file mode 100644 index 0000000..4002715 --- /dev/null +++ b/flakes/etherpad-lite/etherpad_cleanup.sql | |||
@@ -0,0 +1,30 @@ | |||
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 | |||