src/utils/qa/GS1.csh 1.4
1.4 2009/03/24 19:10:43 rhead
Reverting to -h hgwbeta.
Index: src/utils/qa/GS1.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/GS1.csh,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 4 -r1.3 -r1.4
--- src/utils/qa/GS1.csh 21 Mar 2009 00:29:24 -0000 1.3
+++ src/utils/qa/GS1.csh 24 Mar 2009 19:10:43 -0000 1.4
@@ -73,9 +73,9 @@
echo
echo $table
echo "================="
rm -f junk
- set old=`hgsql -h hgofbeta -N -e "SELECT COUNT(*) FROM $table" $betaDb`
+ set old=`hgsql -h hgwbeta -N -e "SELECT COUNT(*) FROM $table" $betaDb`
set new=`hgsql -N -e "SELECT COUNT(*) FROM $table" $db`
if ($old != "") then
set newRows=`expr $new - $old`
set percent=`echo $newRows $old | awk '{printf "%.2f\n", ($1/$2)*100}'`
@@ -95,9 +95,9 @@
echo
echo "compare description of all tables with previous (shows diffs):"
foreach table (`cat $tablelist`)
echo $table
- hgsql -h hgofbeta -N -e "DESCRIBE $table" $betaDb > $betaDb.beta.$table.desc
+ hgsql -h hgwbeta -N -e "DESCRIBE $table" $betaDb > $betaDb.beta.$table.desc
hgsql -N -e "DESCRIBE $table" $db > $db.dev.$table.desc
diff $betaDb.beta.$table.desc $db.dev.$table.desc
echo
end
@@ -159,14 +159,14 @@
echo
echo
echo "check that there are more in new release:"
-hgsql -h hgofbeta -N -e "SELECT name FROM knownGene" $betaDb \
+hgsql -h hgwbeta -N -e "SELECT name FROM knownGene" $betaDb \
> beta.$betaDb.KG.name
sort beta.$betaDb.KG.name | uniq > beta.$betaDb.KG.name.uniq
-hgsql -h hgofbeta -N -e "SELECT transcript FROM knownCanonical" $betaDb \
+hgsql -h hgwbeta -N -e "SELECT transcript FROM knownCanonical" $betaDb \
> beta.$betaDb.knCanonical.transcript
-hgsql -h hgofbeta -N -e "SELECT transcript FROM knownIsoforms" $betaDb \
+hgsql -h hgwbeta -N -e "SELECT transcript FROM knownIsoforms" $betaDb \
> beta.$betaDb.knIsoforms.transcript
sort beta.$betaDb.knCanonical.transcript | uniq \
> beta.$betaDb.knCanonical.transcript.uniq
sort beta.$betaDb.knIsoforms.transcript | uniq \
@@ -280,13 +280,13 @@
echo "one record:"
hgsql -t -e "SELECT * FROM $table LIMIT 1" $db
if ($table == "knownToSuper") then
# ?? they are the same -- where were you going with this?
- set old=`hgsql -h hgofbeta -N -e "SELECT gene FROM $table" $betaDb \
+ set old=`hgsql -h hgwbeta -N -e "SELECT gene FROM $table" $betaDb \
| sort | uniq | wc -l`
set this=`hgsql -N -e "SELECT gene FROM $table" $db | sort | uniq | wc -l`
else
- set old=`hgsql -h hgofbeta -N -e "SELECT name FROM $table" $betaDb \
+ set old=`hgsql -h hgwbeta -N -e "SELECT name FROM $table" $betaDb \
| sort | uniq | wc -l`
set this=`hgsql -N -e "SELECT name FROM $table" $db | sort | uniq | wc -l`
endif
set kgNames=`hgsql -N -e 'SELECT name FROM knownGene' $db \