src/utils/qa/check_grp.csh 1.5

1.5 2009/04/11 00:37:02 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/check_grp.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/check_grp.csh,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -B -U 1000000 -r1.4 -r1.5
--- src/utils/qa/check_grp.csh	24 Mar 2009 19:10:44 -0000	1.4
+++ src/utils/qa/check_grp.csh	11 Apr 2009 00:37:02 -0000	1.5
@@ -1,46 +1,47 @@
 #!/bin/tcsh
+source `which qaConfig.csh`
 
 ###############################################
 # 
 #  03-21-04
 #  Checks grp table content on dev and beta, looking for changes
 #  Prints diffs
 #  Run this script on hgwdev
 # 
 #  29 April 2004 M. Chalup Added sort to dump files
 ###############################################
 
 set db_new=""
 set db_old=""
 set table_a="grp"
 
 
 if ($#argv != 2) then
   # no command line args
   echo
   echo "  Checks grp table content on dev and beta, looking for changes"
   echo "  prints diffs"
   echo
   echo "  usage:  command line args:  [dev_db_ver], [beta_db_ver]"
   echo
   exit
 else
   set db_new=$argv[1]
   set db_old=$argv[2]
 endif
 
 echo "Compare content of hgwdev grp table with previous on hgwbeta (shows diffs):"
 echo "using "$db_new" on hgwdev and "$db_old" on hgwbeta"
 
 # --------------------------------------------
 # compare description of grp table with previous (shows diffs):
 
 echo
 echo "                               hgwdev:hgwbeta"
 echo "   Name                Label         Priority"
 echo
-hgsql -h hgwbeta -N  -e "select * from $table_a" $db_old | sort  > $db_old.beta.$table_a.txt
+hgsql -h $sqlbeta -N  -e "select * from $table_a" $db_old | sort  > $db_old.beta.$table_a.txt
 hgsql -N  -e "select * from $table_a" $db_new | sort > $db_new.dev.$table_a.txt
 diff $db_new.dev.$table_a.txt $db_old.beta.$table_a.txt
 echo