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