diff options
| -rw-r--r-- | internal/storage/entry.go | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/internal/storage/entry.go b/internal/storage/entry.go index 64486f12..d79f899a 100644 --- a/internal/storage/entry.go +++ b/internal/storage/entry.go @@ -342,13 +342,13 @@ func (s *Storage) ArchiveEntries(status string, days, limit int) (int64, error) status=$2 AND starred is false AND share_code='' AND - created_at < now () - '%d days'::interval + created_at < now () - $3::interval ORDER BY - created_at ASC LIMIT %d + created_at ASC LIMIT $4 ) ` - result, err := s.db.Exec(fmt.Sprintf(query, days, limit), model.EntryStatusRemoved, status) + result, err := s.db.Exec(query, model.EntryStatusRemoved, status, fmt.Sprintf("%d days", days), limit) if err != nil { return 0, fmt.Errorf(`store: unable to archive %s entries: %v`, status, err) } |