[rsync-backup] / update-bkp-index.in

#! @BASH@
###
### Backup script
###
### (c) 2012 Mark Wooding
###

###----- Licensing notice ---------------------------------------------------
###
### This file is part of the `rsync-backup' program.
###
### rsync-backup is free software; you can redistribute it and/or modify
### it under the terms of the GNU General Public License as published by
### the Free Software Foundation; either version 2 of the License, or
### (at your option) any later version.
###
### rsync-backup is distributed in the hope that it will be useful,
### but WITHOUT ANY WARRANTY; without even the implied warranty of
### MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
### GNU General Public License for more details.
###
### You should have received a copy of the GNU General Public License
### along with rsync-backup; if not, write to the Free Software Foundation,
### Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

set -e

mkdir -p @pkglocalstatedir@
INDEXDB=@pkglocalstatedir@/index.db
: ${STOREDIR=@mntbkpdir@/store}
: ${METADIR=@mntbkpdir@/meta}

if [ ! -f $STOREDIR/.rsync-backup-store ]; then
  echo >&2 "$quis: no backup volume mounted"
  exit 15
fi
: ${VOLUME=$(cat $METADIR/volume)}

## If the database exists then we're OK.  (This will turn into a version
## check and upgrade if the schema changes.)
if [ ! -f "$INDEXDB" ]; then

  ## Create the database.
  rm -f "$INDEXDB.new"
  sqlite3 "$INDEXDB.new" <<EOF
CREATE TABLE meta (
	version INTEGER NOT NULL);
INSERT INTO meta (version) VALUES (0);

CREATE TABLE idx (
	host TEXT NOT NULL,
	fs TEXT NOT NULL,
	date TEXT NOT NULL,
	vol TEXT NOT NULL,
	PRIMARY KEY (host, fs, vol, date));
CREATE INDEX idx_byhostfsdate ON idx (host, fs, date);
CREATE INDEX idx_byvol ON idx (vol);
EOF

  ## Done.
  mv "$INDEXDB.new" "$INDEXDB"
fi

{
  ## Do everything in a single transaction.  SQLite is pretty good at this,
  ## and also it'll avoid updating the database until it sees a `COMMIT'
  ## command, so if we fail halfway through we're still OK.  So it's safe to
  ## start by removing all of the current records referring to this volume.
  cat <<EOF
BEGIN;
DELETE FROM idx WHERE vol = '$VOLUME';
EOF

  ## Now work through the various filesystems.  This is a slightly cheesy way
  ## of finding them.
  for i in $STOREDIR/*/*/last; do

    ## Parse out the host and filesystem names.
    i=${i%/*}
    fs=${i##*/} i=${i%/*}
    host=${i##*/} i=${i%/*}

    ## And work through the date list.
    for j in $STOREDIR/$host/$fs/*; do
      if [ -L "$j" ] || [ ! -d "$j" ]; then continue; fi
      j=${j%/}
      date=${j##*/}
      cat <<EOF
INSERT INTO idx (host, fs, date, vol)
	VALUES ('$host', '$fs', '$date', '$VOLUME');
EOF
    done
  done

  ## Done.
  cat <<EOF
COMMIT;
EOF
} | sqlite3 "$INDEXDB"

###----- That's all, folks --------------------------------------------------
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));
3c6aedd9 MW	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 --------------------------------------------------