src/utils/qa/updateTimes.csh 1.29

Index: src/utils/qa/updateTimes.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/updateTimes.csh,v
retrieving revision 1.28
retrieving revision 1.29
diff -b -B -U 1000000 -r1.28 -r1.29
--- src/utils/qa/updateTimes.csh	17 Mar 2010 19:39:24 -0000	1.28
+++ src/utils/qa/updateTimes.csh	17 Mar 2010 23:53:21 -0000	1.29
@@ -1,90 +1,93 @@
 #!/bin/tcsh
 source `which qaConfig.csh`
 
 ################################
 #  
 #  04-08-04
 #  Robert Kuhn
 #
 #  gets update times from any two machines for tables in list
 #
 ################################
 
 set tablelist=""
 set db=""
 set first=""
 set second=""
 set third=""
 set fourth=""
 
 if ( $#argv != 2 ) then
   echo
   echo "  gets update times for three machines for tables in list." 
   echo "  if table is trackDb, trackDb_public will also be checked."
   echo "  warning:  not in real time for RR.  uses overnight dump." 
   echo
   echo "    usage:  database tablelist "
   echo
   echo "            reports on dev, beta and RR"
   echo "            tablelist will accept single table"
   echo
   exit
 else
   set db=$argv[1]
   set tablelist=$argv[2]
 endif
 # cat $tablelist
 
 if ( "$HOST" != "hgwdev" ) then
  echo "\n error: you must run this script on dev!\n"
  exit 1
 endif
 
 
 # check if it is a file or a tablename
 file $tablelist | egrep -q "ASCII text"
 if (! $status) then
   set tables=`cat $tablelist`
 else
   set tables=$tablelist
 endif
 
 foreach table ($tables)
   echo
   echo $table
   echo "============="
 
   set first=`hgsql -N -e 'SHOW TABLE STATUS LIKE "'$table'"' $db \
     | awk '{print $14, $15}'`
-  if ( "$first" == ""  ) then # put some spaces in so labels line up
-      set first="                   "
+  if ( $status ) then
+    echo "."
+    continue
   endif
 
   set second=`hgsql -h $sqlbeta -N -e 'SHOW TABLE STATUS LIKE "'$table'"' $db \
     | awk '{print $14, $15}'`
-  if ( "$second" == "" ) then
-      set second="                   "
+  if ( $status ) then
+    echo "."
+    continue
   endif
 
   if ( "$table" == "trackDb" ) then
     set third=`hgsql -h $sqlbeta -N -e 'SHOW TABLE STATUS LIKE "'trackDb_public'"' $db \
       | awk '{print $14, $15}'`
-    if ( "$third" == "" ) then
-      set third="                   "
+    if ( $status ) then
+      echo "."
+      continue
     endif
   endif
 
   set fourth=`getRRtableStatus.csh $db $table Update_time`
-  if ( $status ) then #check status here because contents could be error msg 
-    set fourth="                   "
+  if ( $status ) then
+    set fourth=""
   endif
 
-  echo ".$first $HOST"
-  echo ".$second $sqlbeta"
+  echo "."$first
+  echo "."$second
   if ( "$table" == "trackDb" ) then
-    echo ".$third $sqlbeta (trackDb_public)"
+    echo "."$third "(trackDb_public)"
   endif
   echo
-  echo ".$fourth RR"
+  echo "."$fourth
 end
 echo