Over a million developers have joined DZone.

Convert Sqlite DB To TXT Cookies Format

·

#!/bin/bash
set -e

# Replace a column field for each line in stdin
replace_column_value() {
    awk "BEGIN{OFS=FS=\"$1\"} {\$$2 = ((\$$2==\"$3\")?\"$4\":\"$5\"); print}"
}

# Convert a Mozilla sqlite cookie file to the old txt format
mozilla_cookies_sqlite2txt() {
    echo "# Netscape HTTP Cookie File"
    echo ".mode tabs
          SELECT host, (host GLOB '.*'), path, 'FALSE', expiry, name, value
          FROM moz_cookies;" | sqlite3 "$1" | \
          replace_column_value "\t" 2 "1" "TRUE" "FALSE" | \
          recode iso8859-1..utf-8 | tr -d '[áéíóúàèìòù]'
}

FILE=$1
mozilla_cookies_sqlite2txt "$FILE"
Topics:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}