#!/usr/bin/env bash
#
# Export Mozilla Firefox bookmarks.
# Based on https://github.com/pirate/ArchiveBox/blob/master/bin/export_browser_history.sh
#

# Base folder to work on
BASEDIR="$HOME/.mozilla"

# There might be many places.sqlite on many profiles
find $BASEDIR -name places.sqlite | while read file; do \
  sqlite3 $file "SELECT \"[\" || group_concat(json_object('timestamp', b.dateAdded, 'description', b.title, 'href', f.url)) || \"]\" FROM moz_bookmarks AS b JOIN moz_places AS f ON f.id = b.fk"
done