src/utils/qa/updateTimes.csh 1.27

Index: src/utils/qa/updateTimes.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/updateTimes.csh,v
retrieving revision 1.26
retrieving revision 1.27
diff -b -B -U 4 -r1.26 -r1.27
--- src/utils/qa/updateTimes.csh	8 Sep 2009 18:55:20 -0000	1.26
+++ src/utils/qa/updateTimes.csh	16 Mar 2010 18:09:02 -0000	1.27
@@ -14,12 +14,14 @@
 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
@@ -65,15 +67,27 @@
     echo "."
     continue
   endif
 
-  set third=`getRRtableStatus.csh $db $table Update_time`
+  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
+    endif
+  endif
+
+  set fourth=`getRRtableStatus.csh $db $table Update_time`
   if ( $status ) then
-    set third=""
+    set fourth=""
   endif
 
   echo "."$first
   echo "."$second
+  if ( "$table" == "trackDb" ) then
+    echo "."$third "(trackDb_public)"
+  endif
   echo
-  echo "."$third
+  echo "."$fourth
 end
 echo