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