src/utils/qa/backupCentral.csh 1.11
1.11 2009/05/03 01:54:56 kuhn
changed single quotes to double so sqlbeta variable can be interpreted
Index: src/utils/qa/backupCentral.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/backupCentral.csh,v
retrieving revision 1.10
retrieving revision 1.11
diff -b -B -U 1000000 -r1.10 -r1.11
--- src/utils/qa/backupCentral.csh 11 Apr 2009 00:37:01 -0000 1.10
+++ src/utils/qa/backupCentral.csh 3 May 2009 01:54:56 -0000 1.11
@@ -1,57 +1,57 @@
#!/bin/tcsh
source `which qaConfig.csh`
###############################################
#
# 04-09-07
# Robert Kuhn
#
# Grab hgcentral* tables from dev, beta, rr and store as files.
#
###############################################
set directory=""
set today=""
set dirPath=""
set urlPath=""
set devString=""
set betaString=""
set rrString=""
if ($#argv == 0 || $#argv > 1) then
# no command line args
echo
echo " grab hgcentral* tables from dev, beta, rr and store as files."
echo
echo " usage: go"
echo
exit
endif
if ( "$HOST" != "hgwdev" ) then
echo "\n error: you must run this script on dev!\n"
exit 1
endif
set directory="hgcentral"
# set file paths and URLs
set today=`date +%Y-%m-%d`
# set today="2008-05-05"
set dirPath="/usr/local/apache/htdocs/qa/test-results/$directory"
rm -rf $dirPath/$today/
mkdir -p $dirPath/$today
set urlPath="http://hgwdev.cse.ucsc.edu/qa/test-results/$directory/$today"
-set devString='hgcentraltest'
-set betaString='-h $sqlbeta hgcentralbeta'
-set rrString='-h genome-centdb hgcentral'
+set devString="hgcentraltest"
+set betaString="-h $sqlbeta hgcentralbeta"
+set rrString="-h genome-centdb hgcentral"
foreach table ( blatServers clade dbDb dbDbArch defaultDb gdbPdb genomeClade \
- liftOverChain namedSessionDb targetDb )
+ liftOverChain namedSessionDb targetDb)
hgsql $devString -N -e "SELECT * FROM $table" | sort >> $dirPath/$today/hgwdev.$table
hgsql $betaString -N -e "SELECT * FROM $table" | sort >> $dirPath/$today/hgwbeta.$table
hgsql $rrString -N -e "SELECT * FROM $table" | sort >> $dirPath/$today/rr.$table
end
echo $urlPath
chmod 640 $dirPath/$today/*.namedSessionDb