src/utils/qa/genbankRun.csh 1.3

1.3 2009/09/08 17:47:26 kuhn
fixed updateTimes.csh to work with msyql v5.0 dumps. also simplified the way it works, removing some of the flexibily seldom used. changed call in genbankRun.csh to use new version.
Index: src/utils/qa/genbankRun.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/genbankRun.csh,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/utils/qa/genbankRun.csh	11 Apr 2009 00:37:03 -0000	1.2
+++ src/utils/qa/genbankRun.csh	8 Sep 2009 17:47:26 -0000	1.3
@@ -1,58 +1,59 @@
 #!/bin/tcsh
 source `which qaConfig.csh`
 
 ################################
 #  
 #  11-08-2005
 #  Ann Zweig
 #
 #  checks to see if genbank is running on the RR for a particular assembly
 #
 ################################
 
 set db=""
 set count=0
 set newCount=0
 set machine="hgw1"
 set tableName="gbCdnaInfo"
 
 if ( $#argv != 1 ) then
   # no arguments
   echo
   echo " checks to see if genbank is running on the RR for a given assembly." 
   echo " (should take less than one minute to run.)"
   echo
   echo "    usage: genbankRun.csh database_name"
   echo
   exit
 else
   set db=$argv[1]
 endif
 
 
 # check to see if the database exists
 set count = `getRRdatabases.csh $machine | grep -c -i $db`
 
 if ($count != 1) then
   echo "ERROR: the $db database does not exist on $machine.  Exiting."
   exit
 endif
 echo
 
 # check to see if the existing database has a $tableName table
 set newCount = `getAssemblies.csh $tableName $machine | grep -c -i $db`
 
 # if the $tableName is present in this $db on this $machine,
 # there will be 2 instances of $db in the output
 if ($newCount != 2) then
   echo "ERROR: the $db database does not have a $tableName table on $machine.  Exiting."
   exit
 endif
 
 
 # database is present, go ahead with the updateTimes script
 echo "This shows the last time the genbank $tableName table was updated"
 echo "for $db on hgwbeta (listed first) and on hgw1 (listed second):"
 
-updateTimes.csh $db $tableName hgwbeta $machine | grep '[0-9,4]'
+updateTimes.csh $db $tableName | grep '.' | tail -2
+