ffe3440ffaebf92cdab371616731c5b0bae27c62 hiram Thu Aug 15 12:04:39 2024 -0700 the addAssemblyList needs to run each week even if the other business needs no update refs #32897 diff --git src/hg/utils/otto/genArk/updateHgcentral.sh src/hg/utils/otto/genArk/updateHgcentral.sh index b15b071..9150b8c 100755 --- src/hg/utils/otto/genArk/updateHgcentral.sh +++ src/hg/utils/otto/genArk/updateHgcentral.sh @@ -81,30 +81,32 @@ } ########################################################################### ### 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` 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} countToday=`grep -v "^#" list.${DS} | wc -l` rowCount=`hgsql -N hgcentraltest -e 'select count(*) from genark;' | cat` if [ "${countToday}" -gt "${rowCount}" ]; then ./genArkListToSql.pl list.${DS} > genark.tsv hgsql hgcentraltest -e 'drop table genark;' hgsql hgcentraltest < /hive/data/inside/GenArk/genark.sql hgsql hgcentraltest -e "LOAD DATA LOCAL INFILE 'genark.tsv' INTO TABLE genark;"