src/utils/qa/countRows.csh 1.11
1.11 2009/09/16 21:09:55 kuhn
inproved usage and output
Index: src/utils/qa/countRows.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/countRows.csh,v
retrieving revision 1.10
retrieving revision 1.11
diff -b -B -U 1000000 -r1.10 -r1.11
--- src/utils/qa/countRows.csh 10 Sep 2009 22:55:50 -0000 1.10
+++ src/utils/qa/countRows.csh 16 Sep 2009 21:09:55 -0000 1.11
@@ -1,54 +1,54 @@
#!/bin/tcsh
source `which qaConfig.csh`
################################
# 05-19-04
# gets the rowcount for a list of tables.
#
################################
set db=""
set tablelist=""
set tables=""
set dev=""
set beta=""
set rr=""
if ($#argv != 2) then
echo
- echo " gets the rowcount for a list of tables from dev and beta."
+ echo " gets the rowcount for a list of tables from dev, beta and RR."
echo
echo " usage: database tablelist"
echo " tablelist can be just name of single table"
echo
echo " RR results not in real time, but from dumps"
echo
exit
else
set db=$argv[1]
set tablelist=$argv[2] # file of tablenames or single table name
endif
echo
if ( -e $tablelist ) then
echo "running countRows for tables:"
set tables=`cat $tablelist`
- echo "tables $tables"
+ echo "$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`
set rr=` getRRtableStatus.csh $db $table Rows`
echo $table
echo "============="
echo "."$dev
echo "."$beta
echo
echo "."$rr
echo
end