diff options
author | Ty Cobb <ty.cobb.m@gmail.com> | 2019-09-11 22:10:34 -0500 |
---|---|---|
committer | Frédéric Guillot <fred@miniflux.net> | 2019-09-11 20:10:33 -0700 |
commit | 3a60abbac07bd342f261fccb46bfd5b0039b3f74 (patch) | |
tree | 2c1608b4918f83493f9a8e1a8482ce21d793690d /storage | |
parent | 8d8f78241d303381abf6879cc007ca9cbc2a12e2 (diff) |
Make configurable the number of days to remove old sessions
Diffstat (limited to 'storage')
-rw-r--r-- | storage/session.go | 8 | ||||
-rw-r--r-- | storage/user_session.go | 8 |
2 files changed, 8 insertions, 8 deletions
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 { |