src/utils/qa/findNewTables.csh 1.7
1.7 2009/09/20 18:32:09 kuhn
fixed to deal with MySQL 5.0 status diff
Index: src/utils/qa/findNewTables.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/findNewTables.csh,v
retrieving revision 1.6
retrieving revision 1.7
diff -b -B -U 4 -r1.6 -r1.7
--- src/utils/qa/findNewTables.csh 11 Apr 2009 00:37:03 -0000 1.6
+++ src/utils/qa/findNewTables.csh 20 Sep 2009 18:32:09 -0000 1.7
@@ -10,9 +10,9 @@
#
###############################################
set dbs=""
-set yesterDate=""
+set yesterdate=""
if ($#argv == 0 || $#argv > 1) then
# no command line args
echo
@@ -31,17 +31,18 @@
echo "\n error: you must run this script on dev!\n"
exit 1
endif
-set yesterDate=`date +%Y-%m-%d --date='1 day ago'`
+# set yesterdate=2009-03-11
+set yesterdate=`date +%Y-%m-%d --date='1 day ago'`
echo
-echo $yesterDate "new or updated tables"
+echo $yesterdate "new or updated tables"
echo
foreach db ( $dbs )
echo $db
- getTableStatus.csh $db hgwdev | awk '{print $1, $11}' | grep $yesterDate \
+ getTableStatus.csh $db hgwdev | awk -F"\t" '{print $1, $13}' | grep $yesterdate \
| awk '{print $1}' | egrep -v "trackDb|hgFindSpec|tableDescriptions"
echo
end