src/utils/qa/updateTimes.csh 1.28

1.28 2010/03/17 19:39:24 rhead
Added labels to the output lines!
Index: src/utils/qa/updateTimes.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/updateTimes.csh,v
retrieving revision 1.27
retrieving revision 1.28
diff -b -B -U 4 -r1.27 -r1.28
--- src/utils/qa/updateTimes.csh	16 Mar 2010 18:09:02 -0000	1.27
+++ src/utils/qa/updateTimes.csh	17 Mar 2010 19:39:24 -0000	1.28
@@ -55,39 +55,36 @@
   echo "============="
 
   set first=`hgsql -N -e 'SHOW TABLE STATUS LIKE "'$table'"' $db \
     | awk '{print $14, $15}'`
-  if ( $status ) then
-    echo "."
-    continue
+  if ( "$first" == ""  ) then # put some spaces in so labels line up
+      set first="                   "
   endif
 
   set second=`hgsql -h $sqlbeta -N -e 'SHOW TABLE STATUS LIKE "'$table'"' $db \
     | awk '{print $14, $15}'`
-  if ( $status ) then
-    echo "."
-    continue
+  if ( "$second" == "" ) then
+      set second="                   "
   endif
 
   if ( "$table" == "trackDb" ) then
     set third=`hgsql -h $sqlbeta -N -e 'SHOW TABLE STATUS LIKE "'trackDb_public'"' $db \
       | awk '{print $14, $15}'`
-    if ( $status ) then
-      echo "."
-      continue
+    if ( "$third" == "" ) then
+      set third="                   "
     endif
   endif
 
   set fourth=`getRRtableStatus.csh $db $table Update_time`
-  if ( $status ) then
-    set fourth=""
+  if ( $status ) then #check status here because contents could be error msg 
+    set fourth="                   "
   endif
 
-  echo "."$first
-  echo "."$second
+  echo ".$first $HOST"
+  echo ".$second $sqlbeta"
   if ( "$table" == "trackDb" ) then
-    echo "."$third "(trackDb_public)"
+    echo ".$third $sqlbeta (trackDb_public)"
   endif
   echo
-  echo "."$fourth
+  echo ".$fourth RR"
 end
 echo