src/utils/qa/getRRtableStatus.csh 1.12

1.12 2009/09/08 17:47:26 kuhn
fixed updateTimes.csh to work with msyql v5.0 dumps. also simplified the way it works, removing some of the flexibily seldom used. changed call in genbankRun.csh to use new version.
Index: src/utils/qa/getRRtableStatus.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/getRRtableStatus.csh,v
retrieving revision 1.11
retrieving revision 1.12
diff -b -B -U 4 -r1.11 -r1.12
--- src/utils/qa/getRRtableStatus.csh	11 Apr 2009 00:37:04 -0000	1.11
+++ src/utils/qa/getRRtableStatus.csh	8 Sep 2009 17:47:26 -0000	1.12
@@ -9,43 +9,33 @@
 #  Robert Kuhn
 ################################
 
 set db=""
-set machine="hgw1"
+set machine="hgnfs1"
 set table=""
 set field=""
 set dumpfile=""
 
-if ( $#argv < 3 | $#argv > 4 ) then
+if ( $#argv != 3 ) then
   echo
-  echo "  gets the status of any table from an RR database."
+  echo "  gets the status of any table from the RR database."
   echo "  using mark's genbank dumps."
   echo "    warning:  not in real time.  uses overnight dump."
   echo
-  echo "    usage: database table field [RRmachine] (defaults to hgw1)"
-  echo "    fields available: Name, Type, Row_format, Rows, Avg_row_length, "
-  echo "        Data_length, Max_data_length, Index_length, Data_free, "
-  echo "        Auto_increment, Create_time, Update_time, Check_time, "
-  echo "        Create_options, Comment"
+  echo "    usage: database table field "
+  echo "    fields available: Name, Engine, Version, Row_format, Rows, "
+  echo "        Avg_row_length, Data_length, Max_data_length, Index_length, "
+  echo "        Data_free, Auto_increment, Create_time, Update_time, "
+  echo "        Check_time, Create_options, Comment"
   echo
   exit
 else
   set db=$argv[1]
   set table=$argv[2]
   set field=$argv[3]
 endif
 
-if ( $#argv == 4 ) then
-  set machine=$argv[4]
-endif
-
-checkMachineName.csh $machine
-if ( $status ) then
-  echo
-  exit 1
-endif
-
-set dumpfile=`getRRdumpfile.csh $db $machine`
+set dumpfile=`getRRdumpfile.csh $db`
 if ( $status ) then
   echo
   echo "  database $db -- not found in status dumps"
   echo
@@ -90,9 +80,8 @@
   echo "field    = $field"
   echo "machine  = $machine"
   echo
   echo "machpath = $machpath"
-  echo "fullpath = $fullpath"
   echo "dumpfile = $dumpfile"
   echo "fieldval = $fieldval"
   echo
   # exit