namespace :maintain do

  STALE_SESSION_DEADLINE = 2.days.ago
  STALE_PHANTOM_JOB_DEADLINE = 1.day.ago

  desc "Run all database maintainance tasks"
  task :maintain_database => :environment do
    Rake::Task['fintrans:maintain:remove_stale_phantoms'].invoke
    Rake::Task['fintrans:maintain:remove_stale_sessions'].invoke
  end

  desc "Remove stale phantoms"
  task :remove_stale_phantoms => :environment do
    Time.zone = "Bern"
    CGI::Session::ActiveRecordStore::Jobs.destroy_all( ['customer_id=NULL && updated_at<?', STALE_PHANTOM_JOB_DEADLINE] )
  end

  desc "Remove stale sessions"
  task :remove_stale_sessions => :environment do
    Time.zone = "Bern"
    CGI::Session::ActiveRecordStore::Session.destroy_all( ['updated_at<?', STALE_SESSION_DEADLINE] )
  end

end