src/utils/qa/findKgTableSet.csh 1.1

Index: src/utils/qa/findKgTableSet.csh
===================================================================
RCS file: src/utils/qa/findKgTableSet.csh
diff -N src/utils/qa/findKgTableSet.csh
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/utils/qa/findKgTableSet.csh	11 Oct 2009 04:42:10 -0000	1.1
@@ -0,0 +1,64 @@
+#!/bin/tcsh
+
+################################
+#  03-25-04
+#  updated to take command line only
+#
+#  Runs through set of all tables ever used in KG, FB and PB.
+#  Expects kgTables, fbTables and pbTables up one directory level
+#  Checks dev for which of those tables are used in this assembly.
+#  Makes files called kgTables$db, fbTables$db and pbTables$db 
+#      for each of the input tablelists
+#  Checks update times on dev and beta for table in *Tables$db
+#      to see if table has been updated.
+# 
+################################
+
+set db=""
+set tablePath="/cluster/bin/scripts"
+set curr_dir=$cwd
+
+
+if ($1 == "") then
+  # no command line args
+  echo
+  echo "  gets set of relevant tables for KG, FB, PB from master list."
+  echo "  expects lists kgTables, fbTables and pbTables up one directory."
+  echo "  makes files xxTables$db for current assembly."
+  echo "  does not detect if list is incomplete."
+  echo "  compares update times dev to beta."
+  echo
+  echo "    usage:  database"
+  echo
+  exit
+else
+  set db=$argv[1]
+endif
+
+cp $tablePath/kgTables .
+cp $tablePath/gsTables .
+cp $tablePath/pbTables .
+
+# --------------------------------------------
+# run through table list for KG and FB and pull out tables that have
+#  tables on dev for this assembly:
+
+echo
+foreach tableList  ( kgTables gsTables pbTables )
+  if ( ! -e $tableList ) then
+    echo "$tablelist needed locally"
+    exit 1
+  endif
+  hgsql -N -e 'SHOW TABLES' $db | grep -w -f $tableList > $db.$tableList 
+end
+
+foreach tableList  ( kgTables gsTables pbTables )
+  echo
+  echo "$tableList tables not in ${db}:"
+  echo
+  cat $tableList | grep -w -v -f $db.$tableList 
+end
+echo
+
+exit
+