huginn/app/models/event.rb

class Event < ActiveRecord::Base
  attr_accessible :lat, :lng, :payload, :user_id, :user, :expires_at

  acts_as_mappable

  serialize :payload

  belongs_to :user
  belongs_to :agent, :counter_cache => true

  before_save :symbolize_payload

  scope :recent, lambda { |timespan = 12.hours.ago|
    where("events.created_at > ?", timespan)
  }

  def symbolize_payload
    self.payload = payload.recursively_symbolize_keys if payload.is_a?(Hash)
  end

  def reemit!
    agent.create_event :payload => payload, :lat => lat, :lng => lng
  end

  def self.cleanup_expired!
    Event.where("expires_at IS NOT NULL AND expires_at < ?", Time.now).delete_all
  end
end