src/utils/qa/backupCentral.csh 1.9
1.9 2009/03/24 19:10:43 rhead
Reverting to -h hgwbeta.
Index: src/utils/qa/backupCentral.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/backupCentral.csh,v
retrieving revision 1.8
retrieving revision 1.9
diff -b -B -U 1000000 -r1.8 -r1.9
--- src/utils/qa/backupCentral.csh 20 Mar 2009 23:46:19 -0000 1.8
+++ src/utils/qa/backupCentral.csh 24 Mar 2009 19:10:43 -0000 1.9
@@ -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 hgofbeta hgcentralbeta'
+set betaString='-h hgwbeta 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