Contents

class LoginEvent < ActiveRecord::Base
  set_table_name 'login_events'

  validates_presence_of :ip_address, :latitude, :longitude
  validates_presence_of :city, :country_code, :region_name

  attr_accessible :ip_address, :latitude, :longitude
  attr_accessible :city, :country_code, :region_name

  def self.grouped_by_city(time_frame = 1.hour)
    select('COUNT(*) AS count, login_events.city').
    where('login_events.created_at >= ?', Time.now - time_frame).
    group('login_events.city')
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
devise_password_sharing_extension-0.0.6	app/models/login_event.rb
devise_password_sharing_extension-0.0.5	app/models/login_event.rb
devise_password_sharing_extension-0.0.4	app/models/login_event.rb
devise_password_sharing_extension-0.0.2	app/models/login_event.rb
devise_password_sharing_extension-0.0.1	app/models/login_event.rb