moz_find

#! /bin/sh
# moz_find (Bourne shell script) -- Free-text search on bookmark names or URLs

if [ "$1" = -u ] ; then
  shift
  sql="SELECT parent, moz_bookmarks.title, url
         FROM moz_places
         INNER JOIN moz_bookmarks ON moz_places.id=moz_bookmarks.fk
         WHERE type=1 AND url LIKE '%$1%';"
else
  sql="SELECT parent, moz_bookmarks.title, url
         FROM moz_places
         INNER JOIN moz_bookmarks ON moz_places.id=moz_bookmarks.fk
         WHERE type=1 AND moz_bookmarks.title LIKE '%$1%';"
fi

file=${2:-~/Transfer.incoming/tarantula/places.sqlite}
echo "$sql" | sqlite3 $file
  ## Transfer.incoming/decrux/places.sqlite

# -- Type codes --
# 1: bookmark
# 2: submenu/root
# 3: separator