src/utils/qa/compareWholeColumn.csh 1.8

1.8 2009/03/24 19:10:44 rhead
Reverting to -h hgwbeta.
Index: src/utils/qa/compareWholeColumn.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/compareWholeColumn.csh,v
retrieving revision 1.7
retrieving revision 1.8
diff -b -B -U 1000000 -r1.7 -r1.8
--- src/utils/qa/compareWholeColumn.csh	21 Mar 2009 00:29:24 -0000	1.7
+++ src/utils/qa/compareWholeColumn.csh	24 Mar 2009 19:10:44 -0000	1.8
@@ -1,52 +1,52 @@
 #!/bin/tcsh
 
 ###############################################
 # 
 #  07-14-04
 #  Robert Kuhn
 #
 #  Gets a column from a table on dev and beta and checks diffs
 # 
 ###############################################
 
 set db=""
 set db2=""
 set table=""
 set column=""
 
 
 if ($#argv < 3 || $#argv > 4) then
   # no command line args
   echo
   echo "  gets a column from a table on dev and beta and checks diffs."
   echo "  reports numbers of rows unique to each and common."
   echo "  can compare to older database."
   echo "  writes files of everything."
   echo
   echo "    usage:  database, table, column, [db2] "
   echo
   exit
 else
   set db=$argv[1]
   set table=$argv[2]
   set column=$argv[3]
   set db2=$db
 endif
 
 if ($#argv == 4) then
   set db2=$argv[4]
 endif 
 
 # --------------------------------------------
 #  get files of tables and compare:
 
 hgsql -N -e "SELECT $column FROM $table" $db | sort  > $db.$table.$column.dev
-hgsql -N -h hgofbeta -e "SELECT $column FROM $table" $db2 | sort  > $db2.$table.$column.beta
+hgsql -N -h hgwbeta -e "SELECT $column FROM $table" $db2 | sort  > $db2.$table.$column.beta
 comm -23 $db.$table.$column.dev $db2.$table.$column.beta >$db.$table.$column.devOnly
 comm -13 $db.$table.$column.dev $db2.$table.$column.beta >$db2.$table.$column.betaOnly
 comm -12 $db.$table.$column.dev $db2.$table.$column.beta >$db.$table.$column.common
 echo
 wc -l $db.$table.$column.devOnly $db2.$table.$column.betaOnly \
   $db.$table.$column.common | grep -v "total"
 echo