src/utils/qa/getSplit.csh 1.11
1.11 2009/05/12 23:49:32 kuhn
dropped declaration of varialbe no longer used
Index: src/utils/qa/getSplit.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/getSplit.csh,v
retrieving revision 1.10
retrieving revision 1.11
diff -b -B -U 1000000 -r1.10 -r1.11
--- src/utils/qa/getSplit.csh 12 May 2009 23:48:03 -0000 1.10
+++ src/utils/qa/getSplit.csh 12 May 2009 23:49:32 -0000 1.11
@@ -1,97 +1,96 @@
#!/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="hgwdev"
set host=""
set db=""
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 | hgsqlbeta]"
echo
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] == "hgsqlbeta" ) then
set machine="$argv[3]"
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=""
# check for chromInfo table
hgsql -N $host -e 'SHOW TABLES' $db | grep -qw "chromInfo"
if ( ! $status ) then
set chrom=`hgsql -N $host -e 'SELECT chrom FROM chromInfo LIMIT 1' $db`
# check if split table
hgsql -N $host -e 'SHOW TABLES' $db | grep -qw $tablename
if ( ! $status ) then
echo "unsplit"
else
hgsql -N $host -e 'SHOW TABLES' $db | grep -qw ${chrom}_$tablename
if ( ! $status ) then
echo "$chrom"
else
echo
echo " no such table $tablename or ${chrom}_$tablename."
echo
exit 1
endif
endif
exit 0
else
echo
echo "no chromInfo table for $db on ${machine}."
echo
exit 1
endif