diff options
| -rwxr-xr-x | dump-ff-history | 22 |
1 files changed, 20 insertions, 2 deletions
diff --git a/dump-ff-history b/dump-ff-history index 33cf7f0..c171aa3 100755 --- a/dump-ff-history +++ b/dump-ff-history @@ -5,7 +5,25 @@ trap "rm -rf '${TMPDIR}'" EXIT TERM cp -n ~/.mozilla/firefox/*.default/places.sqlite* "$TMPDIR" -sqlite3 "$TMPDIR/places.sqlite" "SELECT datetime(visit_date/1000000,'unixepoch', 'localtime') AS visit_date, url, title +sqlite_opts=() + +case $MODE in + zsh-history-compat) + select_fields="visit_date/1000000 AS visit_date, url, title" + sqlite_opts=(-separator ' | ') + ;; + *) select_fields="datetime(visit_date/1000000,'unixepoch', 'localtime') AS visit_date, url, title";; +esac + +output_filter() { + if [[ $MODE == 'zsh-history-compat' ]]; then + sed -r 's#^([0-9]+) \| (.*)$#: \1:0;\2#' + else + cat + fi +} + +sqlite3 "${sqlite_opts[@]}" "$TMPDIR/places.sqlite" "SELECT $select_fields 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" +ORDER BY visit_date" | output_filter |