src/utils/qa/countRows.csh 1.10
1.10 2009/09/10 22:55:50 kuhn
added RR results, though not in real time
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 4 -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
@@ -9,16 +9,21 @@
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
@@ -36,11 +41,14 @@
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