newset

#!/bin/bash
SET="$1"

source ./config
RESULTPSQL="psql -h $RESULTHOST -U $RESULTUSER -p $RESULTPORT -d $RESULTDB"

if [ -z "$SET" ] ; then
  echo Usage:  $0 \"description\"
  echo Run without any parameters for help and to display existing sets
  echo
  $RESULTPSQL -c "SELECT * FROM testset ORDER BY server,set"
  exit 1
fi

$RESULTPSQL -c "INSERT INTO testset(info,server) VALUES('$SET','${SERVERNAME}');"
$RESULTPSQL -c "SELECT * FROM testset ORDER BY server,set"