src/utils/qa/countRows.csh 1.10

Index: src/utils/qa/countRows.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/countRows.csh,v
retrieving revision 1.9
retrieving revision 1.10
diff -b -B -U 1000000 -r1.9 -r1.10
--- src/utils/qa/countRows.csh	10 Sep 2009 22:50:04 -0000	1.9
+++ src/utils/qa/countRows.csh	10 Sep 2009 22:55:50 -0000	1.10
@@ -1,46 +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
   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
 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