#!/bin/sh -e
DB=$1
if [ -z "$DB" ]; then
    echo "usage: `basename $0` db.gdb"
    echo "e.g.:  `basename $0` /u/cguard/bin/cg.gdb | tee cg.count"
    exit 2
fi

: ${ISQL:=/opt/firebird/bin/isql}
: ${DB_USER:=sysdba}
: ${DB_PASS:=sysdba}

echo "SHOW TABLES;" |
$ISQL -user "$DB_USER" -pass "$DB_PASS" "$DB" |
tr -s '\n ' '\n' |
grep -v '^$' |
sed "s/.*/SELECT '&', COUNT(*) FROM &;/" |
$ISQL -user "$DB_USER" -pass "$DB_PASS" "$DB" |
grep --line-buffered -v -e '^$' -e '^ ' -e '^=' |
sed -u 's/  *$//; s/  */\t/'