8be39eded2ca995a387d5c47127f049c2b228932 braney Tue Jun 2 17:26:58 2015 -0700 changes to get NCBI RefSeq track to use the trackVersion table, and to grab Genbank information when available. #13673 diff --git src/hg/lib/ensFace.c src/hg/lib/ensFace.c index c2fc4a8..ed6bf53 100644 --- src/hg/lib/ensFace.c +++ src/hg/lib/ensFace.c @@ -132,41 +132,15 @@ dyStringPrintf(dy, "http://%s.ensembl.org/%s/contigview?chr=%s&start=%d&end=%d", archive, ensOrg, chrName, start, end); } else { dyStringPrintf(dy, "http://%s.archive.ensembl.org/%s/contigview?chr=%s&start=%d&end=%d", archive, ensOrg, chrName, start, end); } else dyStringPrintf(dy, "http://www.ensembl.org/%s/contigview?chr=%s&start=%d&end=%d", ensOrg, chrName, start, end); return dy; } - -void ensGeneTrackVersion(char *database, char *ensVersionString, - char *ensDateReference, int stringSize) -/* check for trackVersion table and find Ensembl version */ -{ -/* see if hgFixed.trackVersion exists */ -boolean trackVersionExists = (sqlDatabaseExists("hgFixed") && hTableExists("hgFixed", "trackVersion")); -ensVersionString[0] = 0; -ensDateReference[0] = 0; -if (trackVersionExists) - { - struct sqlConnection *conn = hAllocConn("hgFixed"); - char query[256]; - sqlSafef(query, sizeof(query), "select version,dateReference from hgFixed.trackVersion where db = '%s' and name = 'ensGene' order by updateTime DESC limit 1", database); - struct sqlResult *sr = sqlGetResult(conn, query); - char **row; - - while ((row = sqlNextRow(sr)) != NULL) - { - safef(ensVersionString, stringSize, "Ensembl %s", row[0]); - safef(ensDateReference, stringSize, "%s", row[1]); - } - sqlFreeResult(&sr); - hFreeConn(&conn); - } -}