edsu · August 29, 2015 13:57 · hugovk · Mar 30, 2014 · edsu · Apr 1, 2014
diff --git a/wikihist.py b/wikihist.py
 #!/usr/bin/env python

 """
 Print out a report of Wikipedia articles you've visited using your Google Chrome history database. 
 The output is in Markdown, and you'll need to shutdown Chrome before you run this or else the 
 database will be locked.
 """

 import os
 import re
 import sqlite3

 home = os.path.expanduser("~")
 dbfile = home + "/Library/Application Support/Google/Chrome/Default/History"
 db = sqlite3.connect(dbfile)

 q = """
    SELECT url, title, visit_count, datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime')
    FROM urls
    ORDER BY visit_count DESC
    """

 for url, title, visit_count, last_visit in db.execute(q):
    if re.match('http://(.+)\.wikipedia\.org/wiki', url):
        print ("* [%s](%s) - %s - %s" % (title, url, last_visit, visit_count)).encode('utf-8')

 db.close()
diff --git a/x.md b/x.md
	#!/usr/bin/env python

	"""
	Print out a report of Wikipedia articles you've visited using your Google Chrome history database.
	The output is in Markdown, and you'll need to shutdown Chrome before you run this or else the
	database will be locked.
	"""

	import os
	import re
	import sqlite3

	home = os.path.expanduser("~")
	dbfile = home + "/Library/Application Support/Google/Chrome/Default/History"
	db = sqlite3.connect(dbfile)

	q = """
	SELECT url, title, visit_count, datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime')
	FROM urls
	ORDER BY visit_count DESC
	"""

	for url, title, visit_count, last_visit in db.execute(q):
	if re.match('http://(.+)\.wikipedia\.org/wiki', url):
	print ("* [%s](%s) - %s - %s" % (title, url, last_visit, visit_count)).encode('utf-8')

	db.close()