0a2698e471a21cd49c6397632a07325654063027
pchan
  Sat Apr 6 00:03:14 2013 -0700
change to use centraldb connection
diff --git src/hg/lib/loweutils.c src/hg/lib/loweutils.c
index cba1510..cdb42fc 100644
--- src/hg/lib/loweutils.c
+++ src/hg/lib/loweutils.c
@@ -63,34 +63,35 @@
         sprintf(query, "select * from %s where name = '%s'", gbProtCodeXra, geneName);
     sr = sqlGetResult(conn, query);
         if ((row = sqlNextRow(sr)) != NULL)
     ginfo = minGeneInfoLoad(row);
     }
 
     if (sr != NULL)
        sqlFreeResult(&sr);
     return ginfo;
 }
 void getGenomeClade(struct sqlConnection *conn, char *dbName, char *genome, char *clade)
 {
     char query[512];
     struct sqlResult *srDb;
     char **rowDb;
-    char *centraldb = cfgOption("central.db");
+    struct sqlConnection *connCentral = hConnectCentral();
 
-    sprintf(query, "select count(*) from %s.genomeClade a, %s.dbDb b, %s.clade c where a.genome = b.genome and a.clade = c.name and b.name = '%s'",
-            centraldb, centraldb, centraldb, dbName);
-    srDb = sqlGetResult(conn, query);
+    sprintf(query, "select count(*) from genomeClade a, dbDb b, clade c where a.genome = b.genome and a.clade = c.name and b.name = '%s'",
+            dbName);
+    srDb = sqlGetResult(connCentral, query);
     if ((rowDb = sqlNextRow(srDb)) != NULL)
     {
         sqlFreeResult(&srDb);
-        sprintf(query, "select a.genome, c.label from %s.genomeClade a, %s.dbDb b, %s.clade c where a.genome = b.genome and a.clade = c.name and b.name = '%s'",
-                centraldb, centraldb, centraldb, dbName);
-        srDb = sqlGetResult(conn, query);
+        sprintf(query, "select a.genome, c.label from genomeClade a, dbDb b, clade c where a.genome = b.genome and a.clade = c.name and b.name = '%s'",
+                dbName);
+        srDb = sqlGetResult(connCentral, query);
         if ((rowDb = sqlNextRow(srDb)) != NULL)
         {
             strcpy(genome, rowDb[0]);
             strcpy(clade, rowDb[1]);
         }
     }
     sqlFreeResult(&srDb);
+    hDisconnectCentral(&connCentral);
 }