5adcf6bc2904690de7b7b30a83ec8a7a0996abe9 galt Tue Aug 21 00:01:25 2018 -0700 changing cse subdomain to soe diff --git src/utils/qa/compareHgFindSpecFast.csh src/utils/qa/compareHgFindSpecFast.csh index a49813c..06d70c5 100755 --- src/utils/qa/compareHgFindSpecFast.csh +++ src/utils/qa/compareHgFindSpecFast.csh @@ -78,50 +78,50 @@ # -- not RR node-specific set pubMySqlFlag=0 set tableRow="" if ( $field == "searchSettings" ) then rm -f $machine1.$db.$table rm -f $machine2.$db.$table set specs=`hgsql -N -h $sqlbeta -e "SELECT searchName FROM hgFindSpec" $db` foreach row ( $specs ) set tableRow=$row foreach machX ( $machine1 $machine2 ) if ( $machX == "hgwbeta" ) then hgsql -h $sqlbeta -e 'SELECT '$field' FROM hgFindSpec \ WHERE searchName = "'$tableRow'"' $db > $machX.$db.$table.$field else set pubMySqlFlag=1 - mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A \ + mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A \ -e 'SELECT '$field' FROM hgFindSpec \ WHERE searchName = "'$tableRow'"' $db > $machX.$db.$table.$field endif cat $machX.$db.$table.$field | perl -pw -e "s/\\n/\n/g" \ | sed -e "s/^/${tableRow} \| /" >> $machX.$db.$table rm -f $machX.$db.$table.$field end end else foreach mach ( $machine1 $machine2 ) rm -f $mach.$db.$table if ( $mach == "hgwbeta" ) then hgsql -h $sqlbeta -e 'SELECT '$field' FROM hgFindSpec' $db \ > $mach.$db.$table else set pubMySqlFlag=1 - mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A \ + mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A \ -e 'SELECT '$field' FROM hgFindSpec' $db > $mach.$db.$table endif end endif diff $machine1.$db.$table $machine2.$db.$table \ | sed -e "/^[0123456789]/s/^/\n/" # if the line begins with a digit, substitute a newline at the beginning # | perl -pw -e "s/^(\d)/\nx/" if ( $status ) then echo "\nThe differences above are found in $table.$field" echo "between $machine1 and $machine2" if ( $pubMySqlFlag == 1 ) then echo "(RR fields taken from public MySql server, not individual machine)" endif