Extract Safari history

safari_history.py

import sqlite3
from typing import NamedTuple
from datetime import datetime
HISTORY_EPOCH = 978307200


class Visit(NamedTuple):
    date: datetime
    title: str
    url: str


def history(path):
    '''
    Extract visit times from Safari browser history.
    
    This is typically stored at ~/Library/Safari/History.db
    '''
    cnx = sqlite3.connect(path)
    cur = cnx.cursor()
    cur.execute('''
    SELECT visit_time, title, url
    FROM history_items INNER JOIN history_visits
        ON history_visits.history_item = history_items.id;
    ''')
    data = cur.fetchall()
    cur.close()
    cnx.close()
    for date, title, url in data:
        date = datetime.fromtimestamp(HISTORY_EPOCH + date)
        yield Visit(date, title, url)