dkforest

commit 1dbe1c2629986c93633a444549c7ed07b049139f
parent fab107141247347f167389448edc29aabc688a36
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Sat, 24 Jun 2023 11:37:52 -0700

much better query

Diffstat:
M
pkg/database/tableIgnoredUsers.go
 | 
3
++-

1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/pkg/database/tableIgnoredUsers.go b/pkg/database/tableIgnoredUsers.go
@@ -15,7 +15,8 @@ type IgnoredUser struct {
 }
 
 func (d *DkfDB) DeleteOldIgnoredUsers() {
-	if err := d.db.Exec(`DELETE FROM ignored_users WHERE ignored_user_id IN (SELECT u.id FROM users u WHERE u.last_seen_at < date('now', '-60 Day'))`).Error; err != nil {
+	if err := d.db.Exec(`DELETE FROM ignored_users WHERE ignored_user_id IN
+	(SELECT iu.ignored_user_id FROM ignored_users iu INNER JOIN users u ON u.id = iu.ignored_user_id WHERE u.last_seen_at < date('now', '-60 Day'))`).Error; err != nil {
 		logrus.Error(err)
 	}
 }