pricecharts

track prices of consumer electronics
Log | Files | Refs | README

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;")