src/utils/qa/findNewTables.csh 1.8

1.8 2009/09/20 18:40:35 kuhn
adjusted to use create_time instead of update_time to eliminate genbank from output
Index: src/utils/qa/findNewTables.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/findNewTables.csh,v
retrieving revision 1.7
retrieving revision 1.8
diff -b -B -U 1000000 -r1.7 -r1.8
--- src/utils/qa/findNewTables.csh	20 Sep 2009 18:32:09 -0000	1.7
+++ src/utils/qa/findNewTables.csh	20 Sep 2009 18:40:35 -0000	1.8
@@ -1,49 +1,49 @@
 #!/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=2009-03-11
 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 -F"\t" '{print $1, $13}' | grep $yesterdate \
+  getTableStatus.csh  $db hgwdev | awk -F"\t" '{print $1, $12}' | grep $yesterdate \
     | awk '{print $1}' | egrep -v "trackDb|hgFindSpec|tableDescriptions"
   echo
 end