ZPMSPOOL=${ZPMSPOOL:-/var/lib/admin/notes}
DB=$ZPMSPOOL/.sequence.db
-SQL="sqlite3 -bail $DB"
+SQL="zpm shell -bail $DB"
#rm -f $DB
test -f $DB || {
-sqlite3 $DB <<EOS
+zpm shell $DB <<EOS
create table sequence ( sequence text not null primary key, val integer not null default 0);
insert into sequence (sequence) values ('default');
EOS
seq=${1:-default}
-num=$(sqlite3 $DB "begin; update sequence set val = val + 1 where sequence = '$seq'; commit;select val from sequence where sequence = '$seq';")
+num=$(zpm shell $DB "begin; update sequence set val = val + 1 where sequence = '$seq'; commit;select val from sequence where sequence = '$seq';")
echo $num