src/utils/qa/getSplit.csh 1.8

1.8 2009/05/11 03:36:47 kuhn
adjusted so default is to dev and a few other cosmetic changes
Index: src/utils/qa/getSplit.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/getSplit.csh,v
retrieving revision 1.7
retrieving revision 1.8
diff -b -B -U 1000000 -r1.7 -r1.8
--- src/utils/qa/getSplit.csh	11 Apr 2009 00:37:04 -0000	1.7
+++ src/utils/qa/getSplit.csh	11 May 2009 03:36:47 -0000	1.8
@@ -1,92 +1,97 @@
 #!/bin/tcsh
 source `which qaConfig.csh`
 
 #######################
 #
 #  01-17-06
 #  determines if table is in split format and returns split name if so
 #  pulled out of getAssebmlies.csh
 #  Robert Kuhn
 #
 #######################
 
 set tablename=""
-set machine="hgwbeta"
-set host="-h $sqlbeta"
+set machine="hgwdev"
+set host=""
 set db=""
 
-if ($#argv < 2 || $#argv > 3) then
+if ( $#argv < 2 || $#argv > 3 ) then
   echo
   echo "  determines if table is in split format "
   echo "    and returns split name if so."
   echo
-  echo "    usage:  db tablename [hgwdev|hgwbeta]"
+  echo "    usage:  db tablename [hgwdev | hgwbeta]"
   echo
-  echo "      third argument accepts machine, defaults to beta"
+  echo "      third argument accepts machine, defaults to hgwdev"
   echo
   exit
 else
   set db=$argv[1]
   set tablename=$argv[2]
 endif
 
 if ( "$HOST" != "hgwdev" ) then
  echo "\n error: you must run this script from dev!\n"
  exit 1
 endif
 
 # assign command line arguments
-if ($#argv == 3) then
+if ( $#argv == 3 ) then
+  if ( $argv[3] == "hgwbeta" ) then
   set machine="$argv[3]"
-  set host="-h $argv[3]"
-  if ($argv[3] == "hgwdev") then
-    set host=""
+    set host="-h $sqlbeta"
+  else
+    if ( $argv[3] != "hgwdev" ) then
+      echo "only hgwdev and hgwbeta are allowed in $0."
+      exit 1
+    endif
   endif
 endif
 
 # echo "db = $db"
 # echo "tablename = $tablename"
 # echo "machine = $machine"
 # echo "host = $host"
 
 # check machine validity
 
 checkMachineName.csh $machine
 if ( $status ) then
   echo "${0}:"
   $0
   exit 1
 endif
 
 # -------------------------------------------------
 # get all assemblies containing $tablename
 
 set chrom=""
 set split=""
 set isChromInfo=0
-if ( $machine == hgwdev || $machine == hgwbeta ) then
-  # check for chromInfo table
-  set isChromInfo=`hgsql -N $host -e 'SHOW TABLES' $db | grep "chromInfo" \
+
+# check for chromInfo table
+set isChromInfo=`hgsql -N $host -e 'SHOW TABLES' $db | grep "chromInfo" \
      | wc -l`
-  if ( $isChromInfo > 0 ) then
+  if ( $status ) then
+    echo "$0 defaults to hgwbeta.  also check spelling of database"
+    echo
+    exit 1
+  endif
+if ( $isChromInfo > 0 ) then
     set chrom=`hgsql -N $host -e 'SELECT chrom FROM chromInfo LIMIT 1' $db`
 
     # check if split table
     set split=`hgsql -N $host -e 'SHOW TABLES LIKE "'${chrom}_$tablename'"' \
       $db | wc -l`
     if ( $split == 1 ) then
       echo "$chrom"
     else 
       echo "unsplit"
     endif
     exit 0
-  else
+else
     echo "no chromInfo table.  split irrelevant"
     exit 1
-  endif
-else   # not dev or beta
-  echo "\n  only works on dev and beta\n"
-  echo "${0}:"
-  $0
+endif
 echo