Crack Open Firefox's New Places Sqlite Database With ActiveRecord
Join the DZone community and get the full member experience.Join For Free
require "rubygems" require "active_record" require "active_support" ActiveRecord::Base.establish_connection( :adapter => "sqlite3", :database => "places.sqlite" ) class MozHistoryvisit < ActiveRecord::Base belongs_to :place, :class_name => "MozPlaces", :foreign_key => "place_id" end class MozPlaces < ActiveRecord::Base end p Time.now.yesterday from = Time.now.yesterday.to_i * 1000000 MozHistoryvisit.find(:all, :conditions => ["visit_date > ?", from]).each do |h| place = h.place puts place.title puts place.url puts place.visit_count puts end
Crack (password software) SQLite Database
Opinions expressed by DZone contributors are their own.