1  
   2  require "rubygems"
   3  require "active_record"
   4  require "active_support"
   5  
   6  ActiveRecord::Base.establish_connection(
   7  	:adapter => "sqlite3",
   8  	:database => "places.sqlite"
   9  )
  10  
  11  class MozHistoryvisit < ActiveRecord::Base
  12  	belongs_to :place, :class_name => "MozPlaces", :foreign_key => "place_id"
  13  end
  14  
  15  class MozPlaces < ActiveRecord::Base
  16  end
  17  
  18  p Time.now.yesterday
  19  from = Time.now.yesterday.to_i * 1000000
  20  
  21  MozHistoryvisit.find(:all, :conditions => ["visit_date > ?", from]).each do |h|
  22  	place = h.place
  23  	puts place.title
  24  	puts place.url
  25  	puts place.visit_count
  26  	puts
  27  end
  28