dump mozilla sqlite3 cookies to netscape format

sql2cookie.sh

#
# Dumps data from a Mozilla sqlite cookie jar into Netscape cookie format.
#
# Useful if you want to run curl with your browser's cookies.
#

#!/bin/sh
SQLITE=sqlite3
MOZ_PROFILE=$1
MOZ_COOKIE_JAR="$MOZ_PROFILE/cookies.sqlite"
QUERY="select host, path, isSecure, expiry, name, value from moz_cookies;"

HEADER=$(cat <<EOF
# Netscape HTTP Cookie File
# http://www.netscape.com/newsref/std/cookie_spec.html
# This is a generated file!  Do not edit.
EOF
)

INPUT=$($SQLITE -separator ' ' "$MOZ_COOKIE_JAR" "$QUERY") &&
  echo "$HEADER" &&
  echo "$INPUT" | awk '
  {
    F1 = $1 ~ /^\./ ? "TRUE" : "FALSE";

    # is secure?
    F2 = $3 == "0" ? "FALSE" : "TRUE";
    # hmm, we could have used with a join() here, but we are lazy...
    printf("%s\t%s\t%s\t%s\t%s\t%s\t%s\n",
    $1, F1, $2, F2, $4, $5, $6);
  }
'