blob: 01ba4584fe16566d23649257042cb69d109f30e5 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
#!/bin/sh
set -eu
usage() {
cat <<-'EOF'
Usage:
archiveit
archiveit -h
EOF
}
help() {
cat <<-'EOF'
Options:
-h, --help show this message
Grab all bookmarks from Firefox that contains tags and archive
them with ArchiveBox.
Examples:
Just run it:
$ archiveit
EOF
}
for flag in "$@"; do
case "$flag" in
(--)
break
;;
(--help)
usage
help
exit
;;
(*)
;;
esac
done
while getopts 'h' flag; do
case "$flag" in
(h)
usage
help
exit
;;
(*)
usage >&2
exit 2
;;
esac
done
shift $((OPTIND - 1))
# Derived from ArchiveBox:
# https://github.com/pirate/ArchiveBox/blob/db1f6efc934bbcdf53377bf51a064c6fd0fc5b1d/bin/archivebox-export-browser-history#L23-L37
QUERY="$(
cat <<-'EOF'
SELECT json_object('timestamp', dateAdded, 'description', title, 'href', url)
FROM (
SELECT b.dateAdded, b.title, p.url
FROM moz_bookmarks AS b
JOIN moz_places AS p
ON b.fk = p.id
WHERE b.fk IN (
SELECT DISTINCT(fk) FROM moz_bookmarks
WHERE parent IN (
-- get all tags
SELECT id FROM moz_bookmarks
WHERE parent = 4
)
)
AND b.title IS NOT NULL
ORDER BY
b.dateAdded ASC,
b.title ASC,
p.url
)
EOF
)"
# Copy the database because it is locked.
DB="$(mkstemp)"
trap 'rm -f "$DB"' EXIT
cp ~/.mozilla/firefox/*.default/places.sqlite "$DB"
cd ~/Documents/Archive/
sqlite3 "$DB" "$QUERY" | archivebox add
archivebox update
|
