commit 2740d1037255216f410f7871e1a949811b2e1ba3 parent 6439af17217b5ca593f484bb00900446de33eb26 Author: Kyle Milz <kyle@getaddrinfo.net> Date: Tue, 5 May 2015 21:45:49 -0600 stats.sh: add Diffstat:
A | stats.sh | | | 12 | ++++++++++++ |
1 file changed, 12 insertions(+), 0 deletions(-)
diff --git a/stats.sh b/stats.sh @@ -0,0 +1,12 @@ +#!/bin/sh + +sql_cmd="sqlite3 /var/db/pricesloth/db" + +echo -n "prices: " +$sql_cmd "select count(*) from prices;" +echo -n "products: " +$sql_cmd "select count(*) from products;" +echo -n "descriptions: " +$sql_cmd "select count(*) from descriptions;" +echo -n "retailers: " +$sql_cmd "select count(*) from retailers;"