stats.sh (390B)
1 #!/bin/ksh 2 3 if [ $# -ne 1 ]; then 4 echo "usage: ${0} <db>" 5 exit 1 6 fi 7 8 sql_cmd="sqlite3 ${1}" 9 10 printf "products: %i\n" $($sql_cmd "select count(*) from products;") 11 printf "prices: %i\n" $($sql_cmd "select count(*) from prices;") 12 printf "descriptions: %i\n" $($sql_cmd "select count(*) from descriptions;") 13 printf "retailers: %i\n" $($sql_cmd "select count(*) from retailers;")