mastofe

commit: 67559361e8db437ffee29af9a4fc4ea9e2daf51f
parent: 4a73615193bae27001c1441a131c0f0961a421b9
Author: sdukhovni <dukhovni@mit.edu>
Date:   Thu, 14 Sep 2017 16:26:38 -0400

Add scheduled worker to purge old user IPs (#4951)

* Add scheduled worker to purge old user IPs

* Use ruby 1.9 hash syntax

Diffstat:
A
app/workers/scheduler/ip_cleanup_scheduler.rb
12
++++++++++++
M
config/sidekiq.yml
3
+++

2 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/app/workers/scheduler/ip_cleanup_scheduler.rb b/app/workers/scheduler/ip_cleanup_scheduler.rb
@@ -0,0 +1,12 @@
+# frozen_string_literal: true
+require 'sidekiq-scheduler'
+
+class Scheduler::IpCleanupScheduler
+  include Sidekiq::Worker
+
+  def perform
+    time_ago = 5.years.ago
+    SessionActivation.where('updated_at < ?', time_ago).destroy_all
+    User.where('last_sign_in_at < ?', time_ago).update_all(last_sign_in_ip: nil)
+  end
+end
diff --git a/config/sidekiq.yml b/config/sidekiq.yml
@@ -24,3 +24,6 @@
   subscriptions_cleanup_scheduler:
     cron: '2 2 * * 0'
     class: Scheduler::SubscriptionsCleanupScheduler
+  ip_cleanup_scheduler:
+    cron: '0 4 * * *'
+    class: Scheduler::IpCleanupScheduler