src/utils/qa/countRows.csh 1.9
1.9 2009/09/10 22:50:04 kuhn
removed some debugging statements
Index: src/utils/qa/countRows.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/countRows.csh,v
retrieving revision 1.8
retrieving revision 1.9
diff -b -B -U 1000000 -r1.8 -r1.9
--- src/utils/qa/countRows.csh 10 Sep 2009 22:30:55 -0000 1.8
+++ src/utils/qa/countRows.csh 10 Sep 2009 22:50:04 -0000 1.9
@@ -1,49 +1,46 @@
#!/bin/tcsh
source `which qaConfig.csh`
################################
# 05-19-04
# gets the rowcount for a list of tables.
#
################################
set db=""
set tablelist=""
set tables=""
if ($#argv != 2) then
echo
echo " gets the rowcount for a list of tables from dev and beta."
echo
echo " usage: database tablelist"
echo " tablelist can be just name of single table"
echo
exit
else
set db=$argv[1]
set tablelist=$argv[2] # file of tablenames or single table name
endif
-echo "database $db"
-echo "tablelist $tablelist"
-
echo
if ( -e $tablelist ) then
echo "running countRows for tables:"
set tables=`cat $tablelist`
echo "tables $tables"
echo
else
set tables=$tablelist
endif
foreach table ( $tables )
set dev=`hgsql -N -e "SELECT COUNT(*) FROM $table" $db`
set beta=`hgsql -h $sqlbeta -N -e "SELECT COUNT(*) FROM $table" $db`
echo $table
echo "============="
echo "."$dev
echo "."$beta
echo
end