#!/bin/sh
PATH=/usr/local/sqlite3/bin:$PATH
db=${DB:-imoni.sq3}
query() {
  sqlite3 -cmd "PRAGMA foreign_keys=ON" $db "$@"
}

adddate() {
  case $1 in
    */*/*)	exit 1 ;;
    */*)	query "REPLACE INTO datelist VALUES('$1');" ;;
    *)		exit 1 ;;
  esac
}
listdate() {
  query "SELECT * FROM datelist;"
}
deldate() {
  query "DELETE FROM datelist WHERE date='$1';"
}

while getopts a:d:l f; do
  case $f in
    a)	adddate $OPTARG ;;
    d)	deldate $OPTARG ;;
    l)	listdate ;;
    \?)	exit 1 ;;
  esac
done
shift $((OPTIND-1))