src/utils/qa/checkSyncAll.csh 1.3

1.3 2009/04/11 00:37:02 rhead
Sourced new qaConfig file at the top. Changed -h hgwbeta lines to look for sql host stored in a variable, specified in the new qaConfig file.
Index: src/utils/qa/checkSyncAll.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/checkSyncAll.csh,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/utils/qa/checkSyncAll.csh	21 Dec 2006 18:56:16 -0000	1.2
+++ src/utils/qa/checkSyncAll.csh	11 Apr 2009 00:37:02 -0000	1.3
@@ -1,90 +1,91 @@
 #!/bin/tcsh
+source `which qaConfig.csh`
 
 ################################
 #  
 #  11-17-06
 #  Robert Kuhn
 #
 #  checks all dbs between two nodes in realTime
 #
 ################################
 
 set mach1="hgwbeta"
 set mach2="hgw1"
 set databases=""
 set times=""
 
 if ( $#argv < 1 || $#argv > 4 ) then
   echo
   echo "  checks table match for all dbs between two nodes in realTime"
   echo "  ignores genbank tables"
   echo "  uses db list from first machine"
   echo "  optionally reports if update times do not match."
   echo
   echo "    usage:  go [machine1 machine2] [times]"
   echo "              defaults to beta and hgw1"
   echo
   exit
 else
   if ( "go" != $argv[1] ) then
     echo
     echo ' the first argument must be "go"\n'
     echo ${0}:
     $0
     exit 1
   endif
 endif
 
 if ( "$HOST" != "hgwdev" ) then
  echo "\n error: you must run this script on dev!\n"
  exit 1
 endif
 
 
 if ( $#argv == 2 ) then
   if ( $argv[2] == "times" ) then
     set times="times"
   else
     echo
     echo " you must specify two machines if you specify one"
     echo
     echo ${0}:
     $0
     exit 1
   endif
 endif
 
 if ( $#argv == 3 || $#argv == 4 ) then
   set mach1=$argv[2]
   set mach2=$argv[3]
 endif
 
 checkMachineName.csh $mach1 $mach2
 if ($status) then
   exit 1
 endif
 
 if ( $#argv == 4 ) then
   if ( $argv[4] == "times" ) then
     set times="times"
   else
     echo
     echo ' the fourth argument must be "times"\n'
     echo ${0}:
     $0
     exit 1
   endif
 endif
 
 
 set databases=`ssh -x qateam@$mach1 mysql -A -N \
   -e '"'SHOW DATABASES'"'`
 
 foreach db ( $databases )
   echo $db
   echo
   checkSync.csh $db $mach1 $mach2 $times
   echo "=========================="
   echo
 end