f6c4dccbcda02c911b3e832fd9668b3b3f5dee4f hiram Sat Jul 25 09:56:02 2026 -0700 an informational printout refs #31811 diff --git src/hg/utils/otto/genArk/updateHgcentral.sh src/hg/utils/otto/genArk/updateHgcentral.sh index c047a2c1e63..e5f3f7e3760 100755 --- src/hg/utils/otto/genArk/updateHgcentral.sh +++ src/hg/utils/otto/genArk/updateHgcentral.sh @@ -79,46 +79,47 @@ printf "# today MySQL rowCount %'d vs. previous MySQL rowCount %'d\n" "${todayCount}" "${mysqlCount}" >> ${msgFile} sendMsg } ########################################################################### ### begin processing ########################################################################### # everything depends on this file from hgdownload rsync -a qateam@hgdownload:/mirrordata/hubs/UCSC_GI.assemblyHubList.txt ./list.${DS} # see if it became newer than previous newSum=`grep -v "^#" list.${DS} | sort | md5sum | cut -d' ' -f1` prevSum=`grep -v "^#" previousList.txt | sort | md5sum | cut -d' ' -f1` +printf "# new list: %d, prevList: %d\n" "`grep -c . list.${DS}`" "`grep -c . previousList.txt`" 1>&2 + if [ "${prevSum}" = "${newSum}" ]; then rm -f list.${DS} ### new assemblyList table in hgcentraltest 2024-08-08 /hive/data/inside/GenArk/addAssemblyList.sh exit 0 fi # save this new list in history mkdir -p history/${YYYY} cp -p list.${DS} history/${YYYY} gzip history/${YYYY}/list.${DS} countToday=`grep -c -v "^#" list.${DS}` rowCount=`hgsql -N hgcentraltest -e 'select count(*) from genark;' | cat` if [ "${countToday}" -gt "${rowCount}" ]; then - ./genArkListToSql.pl list.${DS} > genark.tsv ### new assemblyList table in hgcentraltest 2024-08-08 - loads genark table /hive/data/inside/GenArk/addAssemblyList.sh newCount=`hgsql -N hgcentraltest -e 'select count(*) from genark;' | cat` if [ "${newCount}" -gt "${rowCount}" ]; then updateOK "${newCount}" "${rowCount}" rm -f previousList.txt mv list.${DS} previousList.txt else updateIncorrect "${newCount}" "${rowCount}" exit 255 fi else oddRowCounts "${countToday}" "${rowCount}" exit 255