Firefox browsing history polling

From XPUB & Lens-Based wiki
Revision as of 18:36, 4 March 2013 by Roelroscama (talk | contribs) (Created page with "<source lang='python'> import sqlite3, time, datetime t = datetime.datetime.today() mn = datetime.datetime(t.year,t.month, t.day) ts = time.mktime(mn.timetuple()) ts = long(...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
import sqlite3, time, datetime

t = datetime.datetime.today()
mn = datetime.datetime(t.year,t.month, t.day)
ts = time.mktime(mn.timetuple())

ts = long(time.time()*1000000)
print ts

conn = sqlite3.connect('/Users/ARRA/Library/Application Support/Firefox/Profiles/x39c3q8q.default/places.sqlite')
c = conn.cursor()

while True:
	print "checking"
	for row in c.execute('select url, last_visit_date from moz_places WHERE last_visit_date > ? ORDER BY last_visit_date', (ts,)):
		print row
		ts = row[1]

	time.sleep(2)