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"