Commit | Line | Data |
---|---|---|
a8447303 MW |
1 | #! @BASH@ |
2 | ### | |
3 | ### Backup script | |
4 | ### | |
5 | ### (c) 2012 Mark Wooding | |
6 | ### | |
7 | ||
8 | ###----- Licensing notice --------------------------------------------------- | |
9 | ### | |
10 | ### This file is part of the `rsync-backup' program. | |
11 | ### | |
12 | ### rsync-backup is free software; you can redistribute it and/or modify | |
13 | ### it under the terms of the GNU General Public License as published by | |
14 | ### the Free Software Foundation; either version 2 of the License, or | |
15 | ### (at your option) any later version. | |
16 | ### | |
17 | ### rsync-backup is distributed in the hope that it will be useful, | |
18 | ### but WITHOUT ANY WARRANTY; without even the implied warranty of | |
19 | ### MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
20 | ### GNU General Public License for more details. | |
21 | ### | |
22 | ### You should have received a copy of the GNU General Public License | |
23 | ### along with rsync-backup; if not, write to the Free Software Foundation, | |
24 | ### Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. | |
25 | ||
26 | set -e | |
27 | ||
28 | mkdir -p @pkglocalstatedir@ | |
29 | INDEXDB=@pkglocalstatedir@/index.db | |
30 | : ${STOREDIR=@mntbkpdir@/store} | |
31 | : ${METADIR=@mntbkpdir@/meta} | |
32 | ||
33 | if [ ! -f $STOREDIR/.rsync-backup-store ]; then | |
34 | echo >&2 "$quis: no backup volume mounted" | |
35 | exit 15 | |
36 | fi | |
37 | : ${VOLUME=$(cat $METADIR/volume)} | |
38 | ||
39 | ## If the database exists then we're OK. (This will turn into a version | |
40 | ## check and upgrade if the schema changes.) | |
41 | if [ ! -f "$INDEXDB" ]; then | |
42 | ||
43 | ## Create the database. | |
44 | rm -f "$INDEXDB.new" | |
45 | sqlite3 "$INDEXDB.new" <<EOF | |
46 | CREATE TABLE meta ( | |
47 | version INTEGER NOT NULL); | |
48 | INSERT INTO meta (version) VALUES (0); | |
49 | ||
50 | CREATE TABLE idx ( | |
51 | host TEXT NOT NULL, | |
52 | fs TEXT NOT NULL, | |
53 | date TEXT NOT NULL, | |
54 | vol TEXT NOT NULL, | |
3c6aedd9 MW |
55 | PRIMARY KEY (host, fs, vol, date)); |
56 | CREATE INDEX idx_byhostfsdate ON idx (host, fs, date); | |
a8447303 MW |
57 | CREATE INDEX idx_byvol ON idx (vol); |
58 | EOF | |
59 | ||
60 | ## Done. | |
61 | mv "$INDEXDB.new" "$INDEXDB" | |
62 | fi | |
63 | ||
64 | { | |
65 | ## Do everything in a single transaction. SQLite is pretty good at this, | |
66 | ## and also it'll avoid updating the database until it sees a `COMMIT' | |
67 | ## command, so if we fail halfway through we're still OK. So it's safe to | |
68 | ## start by removing all of the current records referring to this volume. | |
69 | cat <<EOF | |
70 | BEGIN; | |
71 | DELETE FROM idx WHERE vol = '$VOLUME'; | |
72 | EOF | |
73 | ||
74 | ## Now work through the various filesystems. This is a slightly cheesy way | |
75 | ## of finding them. | |
76 | for i in $STOREDIR/*/*/last; do | |
77 | ||
78 | ## Parse out the host and filesystem names. | |
79 | i=${i%/*} | |
80 | fs=${i##*/} i=${i%/*} | |
81 | host=${i##*/} i=${i%/*} | |
82 | ||
83 | ## And work through the date list. | |
84 | for j in $STOREDIR/$host/$fs/*; do | |
85 | if [ -L "$j" ] || [ ! -d "$j" ]; then continue; fi | |
86 | j=${j%/} | |
87 | date=${j##*/} | |
88 | cat <<EOF | |
89 | INSERT INTO idx (host, fs, date, vol) | |
90 | VALUES ('$host', '$fs', '$date', '$VOLUME'); | |
91 | EOF | |
92 | done | |
93 | done | |
94 | ||
95 | ## Done. | |
96 | cat <<EOF | |
97 | COMMIT; | |
98 | EOF | |
99 | } | sqlite3 "$INDEXDB" | |
100 | ||
101 | ###----- That's all, folks -------------------------------------------------- |