91cecec4e65aa52dfa528d17a1fba9e1b7672381 lrnassar Tue Jun 4 13:41:15 2019 -0700 Updating scripts to point to new beta machine #23616 diff --git src/utils/qa/knownGene.csh src/utils/qa/knownGene.csh index 65eb4b7..db91059 100755 --- src/utils/qa/knownGene.csh +++ src/utils/qa/knownGene.csh @@ -68,31 +68,31 @@ echo "using $oldDb for beta db " set curr_dir=$cwd # get sets of KG, GS, PB tables from master list: findKgTableSet.csh $db # count items in list echo "found the following KG tables:" wc -l $db.{kg,gs,pb}Tables cat $db.{kg,gs,pb}Tables | sort -u > $db.allTables echo "will have some overlap. uniq tables = `cat $db.allTables | sort -u | wc -l`" # find new tables: in pushQ but NOT in a kgTables list echo echo "find new tables: in pushQ but NOT in a kgTables list" -hgsql -h mysqlbeta -Ne "SELECT tbls FROM pushQ WHERE tbls LIKE '%knownGene%' \ +hgsql -h $sqlbeta -Ne "SELECT tbls FROM pushQ WHERE tbls LIKE '%knownGene%' \ AND dbs = '"$db"'" qapushq | sed "s/\\n/\n/g" | egrep -r . > $db.pushqKgList dos2unix $db.pushqKgList >& /dev/null commTrio.csh $db.allTables $db.pushqKgList if ( `wc -l $db.allTables.Only | awk '{print $1}'` != 0 ) then echo "these tables may be in separate tracks? ($db.allTables.Only) :" cat $db.allTables.Only endif echo # -------------------------------------------- echo echo "compare new genes to old set (uniq):" echo "not useful for first releasse of KG3-type track"