scheduled_report.rb

class ScheduledReport
  include Mongoid::Document
  include Mongoid::Timestamps

  field :key, :type => String
  index :key

  field :name, :type => String

  field :query, :type => String
  field :last_performed_at, :type => DateTime
  field :results, :type => Array

  def perform
    raise 'basic safety check failed' if query =~ /delete from/i or query =~ /update\s/i
    self.results = ActiveRecord::Base.connection.select_all(query)
    self.last_performed_at = Time.zone.now
    save
  end
end