#!/bin/sh

# thorsum - script for running sthorman to obtain content summary

if [ $# -lt 1 -o $# -gt 2 ]; then
  echo 'Syntax: thorsum [server] database'
  exit 1
elif [ $# -eq 1 ]; then
  HOST=`hostname`
  DB=$1
elif [ $# -eq 2 ]; then
  HOST=$1
  DB=$2
fi


date

echo "hostname: $HOST"

echo ''

cat $HOME/admin/thorsum.sscript \
  | sed -e "s/SERVER/${HOST}/" \
  | sed -e "s#DATABASE#${DB}#" > $HOME/admin/z.sscript
sthorman -input $HOME/admin/z.sscript \
  | sed -n -e "/^Database/,/total all datatypes/p" \
  | egrep -v '(^\.|Working)'

rm $HOME/admin/z.sscript