From 3a60abbac07bd342f261fccb46bfd5b0039b3f74 Mon Sep 17 00:00:00 2001 From: Ty Cobb Date: Wed, 11 Sep 2019 22:10:34 -0500 Subject: Make configurable the number of days to remove old sessions --- storage/session.go | 8 ++++---- storage/user_session.go | 8 ++++---- 2 files changed, 8 insertions(+), 8 deletions(-) (limited to 'storage') diff --git a/storage/session.go b/storage/session.go index 8c1f615..f57d2eb 100644 --- a/storage/session.go +++ b/storage/session.go @@ -100,10 +100,10 @@ func (s *Storage) FlushAllSessions() (err error) { return nil } -// CleanOldSessions removes sessions older than 30 days. -func (s *Storage) CleanOldSessions() int64 { - query := `DELETE FROM sessions - WHERE id IN (SELECT id FROM sessions WHERE created_at < now() - interval '30 days')` +// CleanOldSessions removes sessions older than specified days. +func (s *Storage) CleanOldSessions(days int) int64 { + query := fmt.Sprintf(`DELETE FROM sessions + WHERE id IN (SELECT id FROM sessions WHERE created_at < now() - interval '%d days')`, days) result, err := s.db.Exec(query) if err != nil { diff --git a/storage/user_session.go b/storage/user_session.go index 9c1381e..5fa0f0a 100644 --- a/storage/user_session.go +++ b/storage/user_session.go @@ -124,10 +124,10 @@ func (s *Storage) RemoveUserSessionByID(userID, sessionID int64) error { return nil } -// CleanOldUserSessions removes user sessions older than 30 days. -func (s *Storage) CleanOldUserSessions() int64 { - query := `DELETE FROM user_sessions - WHERE id IN (SELECT id FROM user_sessions WHERE created_at < now() - interval '30 days')` +// CleanOldUserSessions removes user sessions older than specified days. +func (s *Storage) CleanOldUserSessions(days int) int64 { + query := fmt.Sprintf(`DELETE FROM user_sessions + WHERE id IN (SELECT id FROM user_sessions WHERE created_at < now() - interval '%d days')`, days) result, err := s.db.Exec(query) if err != nil { -- cgit v1.2.3