Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

ruby sqlite

require 'sqlite3'​# Browser history db = SQLite3::Database.new "places.sqlite"​# List all tables db.execute  "SELECT * FROM sqlite_master where type='table'"​# List all visited URLs (History)db.execute  "SELECT url FROM moz_places"# List all bookmarksdb.execute  "SELECT title FROM moz_bookmarks"​# List all Cookiesdb = SQLite3::Database.new "cookies.sqlite"db.execute  "SELECT baseDomain, name, host, path, value FROM moz_cookies"​# List all form historydb = SQLite3::Database.new "formhistory.sqlite"db.execute  "SELECT fieldname, value FROM moz_formhistory"
Source by rubyfu.net #
 
PREVIOUS NEXT
Tagged: #ruby #sqlite
ADD COMMENT
Topic
Name
1+3 =