src/utils/qa/findNewTables.csh 1.6
1.6 2009/04/11 00:37:03 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/findNewTables.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/findNewTables.csh,v
retrieving revision 1.5
retrieving revision 1.6
diff -b -B -U 1000000 -r1.5 -r1.6
--- src/utils/qa/findNewTables.csh 5 Jun 2008 17:00:28 -0000 1.5
+++ src/utils/qa/findNewTables.csh 11 Apr 2009 00:37:03 -0000 1.6
@@ -1,47 +1,48 @@
#!/bin/tcsh
+source `which qaConfig.csh`
###############################################
#
# 05-23-08
# Robert Kuhn
#
# finds any tables made since yesterday
#
###############################################
set dbs=""
set yesterDate=""
if ($#argv == 0 || $#argv > 1) then
# no command line args
echo
echo " finds any tables made yesterday."
echo
echo " usage: database(s) "
echo
echo ' will take comma-separated list: "hg18,mm9"'
echo
exit
else
set dbs=`echo $argv[1] | sed "s/,/ /g"`
endif
if ( "$HOST" != "hgwdev" ) then
echo "\n error: you must run this script on dev!\n"
exit 1
endif
set yesterDate=`date +%Y-%m-%d --date='1 day ago'`
echo
echo $yesterDate "new or updated tables"
echo
foreach db ( $dbs )
echo $db
getTableStatus.csh $db hgwdev | awk '{print $1, $11}' | grep $yesterDate \
| awk '{print $1}' | egrep -v "trackDb|hgFindSpec|tableDescriptions"
echo
end