2bbaf46f158391cba2dc6dea1bf78c0db25598f4 pchan Wed Nov 6 00:25:53 2013 -0800 change code to use all_central db for getting genome info diff --git src/hg/lib/loweutils.c src/hg/lib/loweutils.c index 529d238..e56991a 100644 --- src/hg/lib/loweutils.c +++ src/hg/lib/loweutils.c @@ -65,33 +65,33 @@ 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; struct sqlConnection *connCentral = hConnectCentral(); - sqlSafef(query, sizeof query, "select count(*) from genomeClade a, dbDb b, clade c where a.genome = b.genome and a.clade = c.name and b.name = '%s'", + sqlSafef(query, sizeof query, "select count(*) from all_central.genomeClade a, all_central.dbDb b, all_central.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); - sqlSafef(query, sizeof 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'", + sqlSafef(query, sizeof query, "select a.genome, c.label from all_central.genomeClade a, all_central.dbDb b, all_central.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); }