user-tools/moz_bookmarks

   1 #!/bin/bash
   2
   3 true <<EOF
   4 =pod
   5
   6 =head1 NAME
   7
   8 moz_bookmarks - Read Mozilla bookmarks database and display titles and URLs line-by-line
   9
  10 =cut
  11
  12 EOF
  13
  14
  15 set -e
  16 set -o pipefail
  17 set -u
  18
  19 indent()
  20 {
  21         sed -e 's/^/    /'
  22 }
  23
  24
  25 cd ~/.moonchild\ productions/pale\ moon/
  26 cd *.default
  27 dbfile=places.sqlite
  28
  29
  30 sqlite3 -list "$dbfile" "SELECT 'bookmark', id, parent, fk, title FROM moz_bookmarks;
  31 SELECT 'place', NULL, NULL, id, url FROM moz_places;
  32 SELECT 'feed', item_id, NULL, NULL, content FROM moz_items_annos WHERE anno_attribute_id=(SELECT id FROM moz_anno_attributes WHERE name='livemark/feedURI')" |\
  33 {
  34         declare -A place_ids
  35         declare -A parent_ids
  36         declare -A titles
  37         declare -A urls
  38         declare -A bm_urls
  39
  40         while read -r type bookmark_id parent_id place_id content
  41         do
  42                 case "$type" in
  43                 bookmark)
  44                         place_ids[$bookmark_id]=$place_id
  45                         parent_ids[$bookmark_id]=$parent_id
  46                         titles[$bookmark_id]=$content
  47                         ;;
  48                 place)
  49                         urls[$place_id]=$content
  50                         ;;
  51                 feed)
  52                         bm_urls[$bookmark_id]=$content
  53                         ;;
  54                 esac
  55         done
  56
  57         show_bookmarks()
  58         {
  59                 local parent_id=$1
  60                 local place_id
  61                 local bookmark_id
  62                 local title
  63                 local url
  64
  65                 for bookmark_id in "${!parent_ids[@]}"
  66                 do
  67                         if [ ${parent_ids[$bookmark_id]} = $parent_id ]
  68                         then
  69                                 title=${titles[$bookmark_id]}
  70                                 echo "${title:-(no title)}"
  71
  72                                 set +u
  73                                 url=${bm_urls[$bookmark_id]}
  74                                 set -u
  75                                 if [ -z "$url" ]
  76                                 then
  77                                         place_id=${place_ids[$bookmark_id]}
  78                                         if [ "$place_id" != NULL ]
  79                                         then
  80                                                 url=${urls[$place_id]}
  81                                         fi
  82                                 fi
  83                                 if [ -n "$url" ]
  84                                 then
  85                                         echo "$url"
  86                                 fi
  87
  88                                 show_bookmarks $bookmark_id | indent
  89
  90                                 echo
  91                         fi
  92                 done
  93         }
  94
  95         parent_id=0
  96         show_bookmarks $parent_id
  97 }