b6aee4c6471cddebd638fec8dbb988c29a69bc22 markd Thu Apr 23 21:58:41 2026 -0700 import of GENCODE V50, MV39, and V50lift37; added a command to do import with a single command diff --git src/hg/makeDb/outside/gencode/bin/gencodeJoinerCheck src/hg/makeDb/outside/gencode/bin/gencodeJoinerCheck new file mode 100755 index 00000000000..b86f537ddf5 --- /dev/null +++ src/hg/makeDb/outside/gencode/bin/gencodeJoinerCheck @@ -0,0 +1,28 @@ +#!/bin/bash +set -beEu -o pipefail + +if [[ $# != 2 ]] ; then + echo "Wrong # args: $0 db version" >&2 + exit 1 +fi +db="$1" ; shift +version="$1" ; shift + +all_joiner=${HOME}/kent/src/hg/makeDb/schema/all.joiner + +extraIdents="wgEncodeGencodeBasicAttrsV${version} wgEncodeGencodeCompAttrsV${version} wgEncodeGencodePseudoGeneAttrsV${version}" +tblsql="show tables like \"wgEncodeGencode%V${version}\"" +tbls=$(hgsql -Ne "${tblsql}" ${db}) + +for ident in ${tbls} ${extraIdents} ; do + case "${ident}" in + wgEncodeGencodeAttrs*|wgEncodeGencode2wayConsPseudo*|wgEncodeGencodePolya*|wgEncodeGencodeBasicV*|wgEncodeGencodeCompV*|wgEncodeGencodePseudoGeneV*) + # skip tables whose identifier name differs (handled via extraIdents) + # and tables not covered by a joiner identifier + ;; + *) + echo "Checking ${db} ${ident}" >&2 + joinerCheck -database=${db} -identifier=${ident} -keys ${all_joiner} + ;; + esac +done