src/utils/qa/proteins.csh 1.5

1.5 2009/04/11 00:37:04 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/proteins.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/proteins.csh,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -B -U 4 -r1.4 -r1.5
--- src/utils/qa/proteins.csh	24 Mar 2009 19:10:45 -0000	1.4
+++ src/utils/qa/proteins.csh	11 Apr 2009 00:37:04 -0000	1.5
@@ -1,5 +1,6 @@
 #!/bin/tcsh
+source `which qaConfig.csh`
 
 ############################
 # 
 #  03-31-04
@@ -65,9 +66,9 @@
   foreach table (`cat $dev.tables`)
     echo $table
     echo "============="
     hgsql -N -e "SELECT COUNT(*) FROM $table" $dev
-    hgsql -N -h hgwbeta -e "SELECT COUNT(*) FROM $table" $beta
+    hgsql -N -h $sqlbeta -e "SELECT COUNT(*) FROM $table" $beta
     echo
   end
   echo
 
@@ -80,9 +81,9 @@
   echo "compare description of all tables with previous \
          blank if the same:"
   foreach table (`cat $dev.tables`)
     echo $table
-    hgsql -h hgwbeta -N  -e "DESCRIBE $table" $beta >  $beta.beta.$table.desc
+    hgsql -h $sqlbeta -N  -e "DESCRIBE $table" $beta >  $beta.beta.$table.desc
     hgsql -N  -e "DESCRIBE $table" $dev > $dev.dev.$table.desc
     diff $beta.beta.$table.desc $dev.dev.$table.desc
     echo
   end
@@ -100,9 +101,9 @@
   rm -f xxIndexx
   foreach table (`cat $dev.tables`)
     set indexNumDev=`hgsql -N -e "SHOW INDEX FROM $table" $dev \
        | wc -l | gawk '{print $1}'`
-    set indexNumBeta=`hgsql -h hgwbeta -N -e "SHOW INDEX FROM $table" $beta \
+    set indexNumBeta=`hgsql -h $sqlbeta -N -e "SHOW INDEX FROM $table" $beta \
        | wc -l | gawk '{print $1}'`
     echo $table
     if ($indexNumDev != $indexNumBeta) then
       echo $table >> xxIndexx
@@ -113,9 +114,9 @@
       echo "on dev, ${dev}:"
       hgsql -t -e "SHOW INDEX FROM $table" $dev
       echo
       echo "on beta, ${beta}:"
-      hgsql -t -h hgwbeta -e "SHOW INDEX FROM $table" $beta
+      hgsql -t -h $sqlbeta -e "SHOW INDEX FROM $table" $beta
       echo
     endif
     echo
   end
@@ -126,9 +127,9 @@
   
   echo
 end
   
-hgsql -N -h hgwbeta -e "SHOW TABLES" go > go.tables.push
+hgsql -N -h $sqlbeta -e "SHOW TABLES" go > go.tables.push
 
   echo  "-------------------------------------------------"
   echo  "    list of go tables for pushing to beta is in file:  "
   echo  "       go.tables.push"