1436ad57e2be4d9763b695eef131b28ba648df46 markd Thu Jun 25 11:44:18 2020 -0700 added all.joiner schema for new gencode structure diff --git src/hg/makeDb/outside/gencode/gencodeHgGene2Load.mk src/hg/makeDb/outside/gencode/gencodeHgGene2Load.mk index 05c4e84..626be03 100644 --- src/hg/makeDb/outside/gencode/gencodeHgGene2Load.mk +++ src/hg/makeDb/outside/gencode/gencodeHgGene2Load.mk @@ -392,29 +392,29 @@ ## # compare number of tracks with previous ## cmpRelease: gencode-cmp.tsv gencode-cmp.tsv: loadTables @echo 'table V${prevVer} V${ver} delta' >$@.tmp @for tab in ${allTables} ; do \ prevTab=$$(echo "$$tab" | sed 's/V${ver}/V${prevVer}/g') ; \ echo "$${tab} "$$(hgsql -Ne "select count(*) from $${prevTab}" ${db})" "$$(hgsql -Ne "select count(*) from $${tab}" ${db}) ; \ done | tawk '{print $$1, $$2, $$3, $$3-$$2}' >>$@.tmp mv -f $@.tmp $@ joinerCheck: loadTables @mkdir -p check - for tbl in $$(hgsql -Ne 'show tables like "gencode%V${ver}"' ${db} ; do \ + for tbl in $$(hgsql -Ne 'show tables like "gencode%V${ver}"' ${db}) ; do \ echo table=$$tbl; \ runJoiner.csh ${db} $$tbl ~/kent/src/hg/makeDb/schema/all.joiner noTimes; \ done >check/joiner.out 2>&1 if fgrep Error: check/joiner.out ; then false; else true; fi clean: rm -rf ${dataDir} ${tableDir} ${loadedDir} ${checkDir} dropTables: ${allTables:%=%.drop} %.drop: hgsql ${db} -e 'drop table if exists $*'