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 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'storage/session.go') 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 { -- cgit v1.2.3