src/utils/qa/activeGenbank.csh 1.7

Index: src/utils/qa/activeGenbank.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/activeGenbank.csh,v
retrieving revision 1.6
retrieving revision 1.7
diff -b -B -U 1000000 -r1.6 -r1.7
--- src/utils/qa/activeGenbank.csh	11 Apr 2009 00:37:01 -0000	1.6
+++ src/utils/qa/activeGenbank.csh	5 May 2009 23:13:25 -0000	1.7
@@ -1,45 +1,45 @@
 #!/bin/tcsh
 source `which qaConfig.csh`
 
 ################################
 #
 # Compare the list of active assemblies on the RR with the list
 # of the assemblies on the RR genbank update list.
 #
 ################################
 
 # these are assemblies that are too old for nightly genbank updates
 set exceptions='ce1|hg15|rn2|mm5|mm6'
 
 # usage statement
 if ( $argv != go ) then
   echo
   echo " Finds diffs between active DBs and DBs getting genbank updates."
   echo " Only works for RR databases."
   echo
   echo "  usage: activeGenbank.csh go"
   echo
   exit
 endif
 
 # run this only on hgwdev
   if ( "$HOST" != "hgwdev" ) then
    echo "\n error: you must run this script on dev!\n"
    exit 1
   endif
 
 # this is the list of DBs on the RR getting genbank updates
 cat ~/kent/src/hg/makeDb/genbank/etc/rr.dbs | sort | sed -e '/^#/ d' \
 > XXgenbankDbsXX
 
 # this is the list of active DBs on the RR
-hgsql -N -h genome-centdb hgcentral -e "SELECT name FROM dbDb \
+hgsql -N -h $sqlrr hgcentral -e "SELECT name FROM dbDb \
 WHERE active = 1 ORDER BY name;" > XXactiveDbsXX
 
 # find out what's active and not getting a genbank update
 # disregard those assemblies that are too old for updates
 comm -13 XXgenbankDbsXX XXactiveDbsXX | egrep -v $exceptions
 
 # clean-up
 rm XXgenbankDbsXX
 rm XXactiveDbsXX