From: Nathan Wagner <nw@hydaspes.if.org>
Date: Mon, 2 Mar 2015 23:41:33 +0000 (+0000)
Subject: use default sequence if none
X-Git-Tag: v0.1.6~216
X-Git-Url: https://pd.if.org/git/?p=zpackage;a=commitdiff_plain;h=d31433e36c0363474337c6839c7fca64f89794b5

use default sequence if none
---

diff --git a/zpm-sequence b/zpm-sequence
index 2e0f997..768d3f7 100755
--- a/zpm-sequence
+++ b/zpm-sequence
@@ -2,28 +2,36 @@
 
 set -e
 
-SPOOL=${SPOOL:-/var/lib/admin/notes}
-DB=$SPOOL/.sequence.db
+ZPMSPOOL=${ZPMSPOOL:-/var/lib/admin/notes}
+DB=$ZPMSPOOL/.sequence.db
 SQL="sqlite3 -bail $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);
+insert into sequence (sequence) values ('default');
 EOS
 }
 
+# -c create named sequence
+# -d delete named sequence
+# -v current value
+# -l list all
+# -s set value
+# -n next (optional)
+# -p prepare db, but do nothing
 case $1 in
 	-c)
-		$SQL "insert into sequence (sequence) values ('$2')"
+		$SQL "insert into sequence (sequence) values ('${2:-default}')"
 		exit 0
 		;;
 	-d)
-		$SQL "delete from sequence where sequence = '$2'"
+		$SQL "delete from sequence where sequence = '${2:-default}'"
 		exit 0
 		;;
 	-v)
-		val=$($SQL "select val from sequence where sequence = '$2'")
+		val=$($SQL "select val from sequence where sequence = '${2:-default}'")
 		echo $val
 		exit 0
 		;;
@@ -32,15 +40,18 @@ case $1 in
 		exit 0
 		;;
 	-s)
-		$SQL "begin;update sequence set val = $3 where sequence = '$seq'; commit;"
+		$SQL "begin;update sequence set val = $2 where sequence = '${3:-default}'; commit;"
 		exit 0
 		;;
 	-n)
 		shift
 		;;
+	-p)
+		exit 0
+		;;
 esac
 
-seq=$1
+seq=${1:-default}
 
 num=$(sqlite3 $DB "begin; update sequence set val = val + 1 where sequence = '$seq'; commit;select val from sequence where sequence = '$seq';")