src/utils/qa/findPushQLocks.csh 1.7

1.7 2009/04/11 00:37:03 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/findPushQLocks.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/findPushQLocks.csh,v
retrieving revision 1.6
retrieving revision 1.7
diff -b -B -U 4 -r1.6 -r1.7
--- src/utils/qa/findPushQLocks.csh	24 Mar 2009 19:10:44 -0000	1.6
+++ src/utils/qa/findPushQLocks.csh	11 Apr 2009 00:37:03 -0000	1.7
@@ -1,5 +1,6 @@
 #!/bin/tcsh
+source `which qaConfig.csh`
 
 ######################################
 #
 # Ann Zweig -- 3-20-2008
@@ -23,23 +24,23 @@
 else
   set run=$argv[1]
 endif
 
-set unlock=`hgsql -h hgwbeta -Ne "SELECT qid FROM pushQ \
+set unlock=`hgsql -h $sqlbeta -Ne "SELECT qid FROM pushQ \
   WHERE lockDateTime != '' or lockUser != ''" qapushq`
 if ( '' == "$unlock" ) then
   echo "\n no locks to unlock\n"  
   exit 0
 endif
 
 if ( 'go' == $run ) then
-  hgsql -h hgwbeta -e "SELECT qid, lockUser, lockDateTime FROM pushQ \
+  hgsql -h $sqlbeta -e "SELECT qid, lockUser, lockDateTime FROM pushQ \
   WHERE lockDateTime != '' or lockUser != ''" qapushq
   exit 0
 else 
   if ( 'real' == $run && '' != "$unlock" ) then
     foreach lock ( $unlock )
-      hgsql -h hgwbeta -e "UPDATE pushQ SET lockUser = '', lockDateTime = '' \
+      hgsql -h $sqlbeta -e "UPDATE pushQ SET lockUser = '', lockDateTime = '' \
       WHERE qid = '$lock'" qapushq
       echo "\nunlocking qid: $lock"
     end
   else