Given source and target Firefox profiles, merge the cookie exceptions (whitelist) of the source into the target

cookie-exceptions-merge.sh

#! /bin/bash
source=$1
target=$2

sqlite3 $source ".dump moz_hosts" | sed -e 's/moz_hosts/moz_hosts_src/g' | sqlite3 $target

printf "hosts already in target, not merged:\n"
sqlite3 $target "select host
    from moz_hosts_src
    where type='cookie'
    intersect
    select host from moz_hosts
    where type='cookie'"

printf "\nmerging hosts:\n"
sqlite3 $target "select host
	from moz_hosts_src
    where type='cookie'
    except
    select host from moz_hosts
    where type='cookie';"
sqlite3 $target "insert into moz_hosts (host, type, permission, expireType, expireTime, appId, isInBrowserElement)
select host, type, permission, 0, 0, 0, 0
from moz_hosts_src
where type='cookie'
and host in (select host
	from moz_hosts_src
	where type='cookie'
	except
	select host from moz_hosts
	where type='cookie');
drop table moz_hosts_src;"