50134b292a47af4ae93e22cc4f7d290c0a46262e
braney
  Fri Jul 29 11:28:29 2022 -0700
rewrite utility to take dbDb to assembly hubAndGenomes.

diff --git src/hg/lib/hdb.c src/hg/lib/hdb.c
index e7b26a3..949dfb1 100644
--- src/hg/lib/hdb.c
+++ src/hg/lib/hdb.c
@@ -5017,46 +5017,47 @@
 char dbActualName[32];
 
 /* If necessary convert database description to name. */
 sqlSafef(query, sizeof(query), "select name from %s where name = '%s'", dbDbTable(), db);
 if (!sqlExists(conn, query))
     {
     sqlSafef(query, sizeof(query),
 	  "select name from %s where description = '%s'",dbDbTable(),  db);
     if (sqlQuickQuery(conn, query, dbActualName, sizeof(dbActualName)) != NULL)
         db = dbActualName;
     }
 
 /* Do a little join to get data to fit into the blatServerTable. */
 sqlSafef(query, sizeof(query),
                "select d.name,d.description,blatServers.isTrans"
-               ",blatServers.host,blatServers.port,d.nibPath "
+               ",blatServers.host,blatServers.port,d.nibPath, blatServers.dynamic "
 	       "from %s d,blatServers where blatServers.isTrans = %d and "
 	       "d.name = '%s' and d.name = blatServers.db",
 	        dbDbTable(), isTrans, db);
 sr = sqlGetResult(conn, query);
 if ((row = sqlNextRow(sr)) == NULL)
     {
     errAbort("Can't find a server for %s database %s\n",
 	    (isTrans ? "translated" : "DNA"), db);
     }
 st.db = cloneString(row[0]);
 st.genome = cloneString(row[1]);
 st.isTrans = atoi(row[2]);
 st.host = cloneString(row[3]);
 st.port = cloneString(row[4]);
 st.nibDir = cloneString(row[5]);
+st.isDynamic = atoi(row[6]);
 sqlFreeResult(&sr);
 hDisconnectCentral(&conn);
 return &st;
 }
 
 char *sqlGetField(char *db, char *tblName, char *fldName,
   	          char *condition)
 /* Return a single field from the database, table name, field name, and a
    condition string */
 {
 struct sqlConnection *conn = hAllocConn(db);
 char query[256];
 struct sqlResult *sr;
 char **row;
 char *answer;