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