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
+