#!/bin/sh

set -e

SPOOL=${SPOOL:-/var/spool/admin/notes}
DB=$SPOOL/.sequence.db
SQL="sqlite3 -bail -echo $DB"

#rm -f $DB
test -f $DB || {
sqlite3 $DB <<EOS
create table sequence ( sequence text not null primary key, val integer not null default 0);
EOS
}

case $1 in
	-c)
		$SQL "insert into sequence (sequence) values ('$2')"
		exit 0
		;;
	-d)
		$SQL "delete from sequence where sequence = '$2'"
		exit 0
		;;
	-v)
		val=$($SQL "select val from sequence where sequence = '$2'")
		echo $val
		exit 0
		;;
	-l)
		$SQL 'select * from sequence'
		exit 0
		;;
	-s)
		$SQL "begin;update sequence set val = $3 where sequence = '$seq'; commit;"
		exit 0
		;;
	-n)
		shift
		;;
esac

seq=$1

num=$(sqlite3 $DB "begin; update sequence set val = val + 1 where sequence = '$seq'; commit;select val from sequence where sequence = '$seq';")

echo $num