Commit b2429b1
Eric Bower
·
2026-05-03 13:52:22 -0400 EDT
parent 483a3a2
fix: reap should look skip anyone that has pico+
1 files changed,
+3,
-1
+3,
-1
| ... | ... | @@ -1,5 +1,7 @@ | |
| 1 | + | -- find unused accounts | |
| 2 | + | SELECT count(*) FROM app_users u WHERE NOT EXISTS (SELECT 1 FROM posts WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM projects WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM access_logs WHERE user_id = u.id AND created_at > NOW() - INTERVAL '1 year') AND NOT EXISTS (SELECT 1 FROM feature_flags ff WHERE ff.user_id = u.id AND ff.name = 'plus'); | |
| 1 | 3 | -- delete unused accounts | |
| 2 | - | SELECT count(*) FROM app_users u WHERE NOT EXISTS (SELECT 1 FROM posts WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM projects WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM access_logs WHERE user_id = u.id AND created_at > NOW() - INTERVAL '1 year'); | |
| 4 | + | DELETE FROM app_users u WHERE NOT EXISTS (SELECT 1 FROM posts WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM projects WHERE user_id = u.id) AND NOT EXISTS (SELECT 1 FROM access_logs WHERE user_id = u.id AND created_at > NOW() - INTERVAL '1 year') AND NOT EXISTS (SELECT 1 FROM feature_flags ff WHERE ff.user_id = u.id AND ff.name = 'plus'); | |
| 3 | 5 | ||
| 4 | 6 | -- how many visits will be deleted | |
| 5 | 7 | SELECT count(*) FROM analytics_visits WHERE created_at < NOW() - INTERVAL '1 year'; |