aboutsummaryrefslogtreecommitdiffhomepage
path: root/storage
diff options
context:
space:
mode:
authorGravatar Ty Cobb <ty.cobb.m@gmail.com>2019-09-11 22:10:34 -0500
committerGravatar Frédéric Guillot <fred@miniflux.net>2019-09-11 20:10:33 -0700
commit3a60abbac07bd342f261fccb46bfd5b0039b3f74 (patch)
tree2c1608b4918f83493f9a8e1a8482ce21d793690d /storage
parent8d8f78241d303381abf6879cc007ca9cbc2a12e2 (diff)
Make configurable the number of days to remove old sessions
Diffstat (limited to 'storage')
-rw-r--r--storage/session.go8
-rw-r--r--storage/user_session.go8
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 {