From 2ec51a5552cff73c1c5d2ae8caaeeaf543730013 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Wed, 1 Apr 2020 09:31:45 +0200 Subject: Add dump-ff-history Signed-off-by: Florian Pritz --- dump-ff-history | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100755 dump-ff-history (limited to 'dump-ff-history') diff --git a/dump-ff-history b/dump-ff-history new file mode 100755 index 0000000..5f16837 --- /dev/null +++ b/dump-ff-history @@ -0,0 +1,11 @@ +#!/bin/bash + +TMPDIR="$(mktemp -d "/tmp/${0##*/}.XXXXXX")" +trap "rm -rf '${TMPDIR}'" EXIT TERM + +cp -n ~/.mozilla/firefox/*.default/places.sqlite* "$TMPDIR" + +sqlite3 "$TMPDIR/places.sqlite" "SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title +FROM moz_places, moz_historyvisits +WHERE moz_places.id = moz_historyvisits.place_id AND visit_date/1000000 > $(date +%s -d "${1:-2 months ago}") AND visit_date/1000000 < $(date +%s -d "${2:-now}") +ORDER BY visit_date" -- cgit v1.2.3-24-g4f1b