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 1000000 -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,53 +1,54 @@
#!/bin/tcsh
+source `which qaConfig.csh`
######################################
#
# Ann Zweig -- 3-20-2008
#
# find locks in the pushQ on hgwbeta
# run with 'real' to unlock them all
#
######################################
set unlock=''
if ($#argv != 1 ) then
echo
echo " find all locks in the pushQ on hgwbeta"
echo
echo " usage: go|real"
echo " run with 'go' to see a list of locks"
echo " run with 'real' to unlock all the locks"
echo
exit
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
echo "\n not a valid argument\n"
echo "${0}:"
$0
exit 1
endif
endif
exit 0