src/utils/qa/backupCentral.csh 1.8
1.8 2009/03/20 23:46:19 rhead
Changed host hgwbeta to host hgofbeta.
Index: src/utils/qa/backupCentral.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/backupCentral.csh,v
retrieving revision 1.7
retrieving revision 1.8
diff -b -B -U 1000000 -r1.7 -r1.8
--- src/utils/qa/backupCentral.csh 3 Dec 2008 18:54:41 -0000 1.7
+++ src/utils/qa/backupCentral.csh 20 Mar 2009 23:46:19 -0000 1.8
@@ -1,56 +1,56 @@
#!/bin/tcsh
###############################################
#
# 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 hgwbeta hgcentralbeta'
+set betaString='-h hgofbeta hgcentralbeta'
set rrString='-h genome-centdb hgcentral'
foreach table ( blatServers clade dbDb dbDbArch defaultDb gdbPdb genomeClade \
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