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