aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--internal/storage/session.go4
-rw-r--r--internal/storage/user_session.go4
2 files changed, 4 insertions, 4 deletions
diff --git a/internal/storage/session.go b/internal/storage/session.go
index 1144f3ff..acb60e34 100644
--- a/internal/storage/session.go
+++ b/internal/storage/session.go
@@ -128,9 +128,9 @@ func (s *Storage) CleanOldSessions(days int) int64 {
DELETE FROM
sessions
WHERE
- created_at < now() - interval '%d days'
+ created_at < now() - $1::interval
`
- result, err := s.db.Exec(fmt.Sprintf(query, days))
+ result, err := s.db.Exec(query, fmt.Sprintf("%d days", days))
if err != nil {
return 0
}
diff --git a/internal/storage/user_session.go b/internal/storage/user_session.go
index c0339873..3661d852 100644
--- a/internal/storage/user_session.go
+++ b/internal/storage/user_session.go
@@ -170,9 +170,9 @@ func (s *Storage) CleanOldUserSessions(days int) int64 {
DELETE FROM
user_sessions
WHERE
- created_at < now() - interval '%d days'
+ created_at < now() - $1::interval
`
- result, err := s.db.Exec(fmt.Sprintf(query, days))
+ result, err := s.db.Exec(query, fmt.Sprintf("%d days", days))
if err != nil {
return 0
}