eb977447c35d01a2aa61f7ff47a1de0ed477b6cf
braney
  Fri Jun 24 09:51:46 2022 -0700
check to make sure database exists before accessing it

diff --git src/hg/makeDb/trackDb/maybeBuildHub src/hg/makeDb/trackDb/maybeBuildHub
index b4fd60d..f90b59e 100755
--- src/hg/makeDb/trackDb/maybeBuildHub
+++ src/hg/makeDb/trackDb/maybeBuildHub
@@ -1,17 +1,31 @@
-#!/bin/bash -ex
+#!/bin/bash -e
 
 user=$1
 trackDb=$2
 db=$3
 
 hubParent=/gbdb/$db/hubs
 hubDir=$hubParent/$user
 
+# check if a database exists, print note and return non-zero if it doesn't
+dbExists() {
+    local db="$1"
+    local dbChk=$(hgsql -Ne 'show databases like "'$db'"')
+    if [ -z "$dbChk" ] ; then
+        echo "Note: database $db does not exist, skipping"
+        return 1
+    else
+        return 0
+    fi
+}
+
+if dbExists $db ; then
     if test -d $hubParent
     then
         #rm -rf $hubDir
 
         trackDbToTxt $db $trackDb $hubDir
         cat $hubParent/hubAndGenome.txt $hubDir/trackDb.txt > $hubDir/hub.txt
     fi
+fi