45337f0f68ec7ec4e44183884dde67e81163ec67 jcasper Mon Aug 26 16:07:20 2024 -0700 More updates for soe hostname deprecation, no ticket diff --git src/hg/makeDb/hgLoadWiggle/chkWiggleTable.sh src/hg/makeDb/hgLoadWiggle/chkWiggleTable.sh index dd5a432..8972c94 100755 --- src/hg/makeDb/hgLoadWiggle/chkWiggleTable.sh +++ src/hg/makeDb/hgLoadWiggle/chkWiggleTable.sh @@ -20,75 +20,75 @@ fi UNAME=`uname -n` if [ "${UNAME}" != "kolossus" ]; then echo "ERROR: must be run on kolossus to handle the largest chromosomes" usage exit 255 fi DB=$1 TABLE=$2 echo "Checking Table: ${DB}.${TABLE}" -C=`hgsql -N --host=hgwdev.soe.ucsc.edu --user=hguser --password=hguserstuff \ +C=`hgsql -N --host=hgwdev.gi.ucsc.edu --user=hguser --password=hguserstuff \ -e "describe ${TABLE};" ${DB} | \ egrep "chromStart|span|dataRange|sumSquares" | wc -l` if [ "${C}" -ne 4 ]; then echo "ERROR: table ${DB}.${TABLE} does not appear to be a wiggle table ?" - hgsql --host=hgwdev.soe.ucsc.edu --user=hguser --password=hguserstuff \ + hgsql --host=hgwdev.gi.ucsc.edu --user=hguser --password=hguserstuff \ -e "describe ${TABLE};" ${DB} usage exit 255 fi # A temporary file to save chromInfo results CI=/tmp/chkWig_chromInfo.$$ -hgsql -N --host=hgwdev.soe.ucsc.edu --user=hguser --password=hguserstuff \ +hgsql -N --host=hgwdev.gi.ucsc.edu --user=hguser --password=hguserstuff \ -e "select * from chromInfo;" ${DB} > "${CI}" # A temporary file to construct the bed intersection file BF=/tmp/chkWig_$$.bed # Create two bed lines for each chrom # chrN 0 10 # chrN <chromEnd-10> <chromEnd> awk ' { printf "%s\t0\t10\t%s_0\n", $1, $1 printf "%s\t%d\t%d\t%s_1\n", $1, $2-10, $2, $1 } ' "${CI}" > "${BF}" WC=`cat "${BF}" | wc -l` if [ "${WC}" -lt 2 ]; then echo "ERROR: having trouble constructing the test bed file ?" echo "have the following chromInfo: (should not be empty)" cat "${CI}" fi RF=/tmp/chkWig_${DB}.${TABLE}.$$ HGDB_CONF=/tmp/chkWig_hg.conf.$$ export HGDB_CONF -echo "db.host=hgwdev.soe.ucsc.edu" > "${HGDB_CONF}" +echo "db.host=hgwdev.gi.ucsc.edu" > "${HGDB_CONF}" echo "db.user=hguser" >> "${HGDB_CONF}" echo "db.password=hguserstuff" >> "${HGDB_CONF}" chmod 600 "${HGDB_CONF}" ${HGWIGGLE} -verbose=2 -db="${DB}" \ -bedFile="${BF}" "${TABLE}" > "${RF}" 2>&1 WARN=`grep WARN "${RF}" | wc -l` rm -f "${CI}" "${BF}" "${HGDB_CONF}" if [ "${WARN}" -gt 0 ]; then echo "ERROR: there are ${WARN} coordinate problems" echo "Results file can be seen in: ${RF}" else