rake clean:sessions to delete old sessions

cleanup_tasks.rb

desc 'Cleanup tasks'
namespace :clean do
  desc 'Clean sessions table (pass DAYS=X default is 30 days)'
  task :sessions => :environment do
    days = ENV['DAYS'].to_i
    days = 30 if days <= 0

    result = ActiveRecord::Base.connection.execute("DELETE FROM sessions WHERE updated_at <= (CURRENT_DATE - INTERVAL '#{days} days')")
    affected_rows = result.cmd_tuples
    
    puts "#{affected_rows} rows were deleted"
  end
end