src/hg/utils/makeTrackIndex/makeTrackIndex.c 1.1

Index: src/hg/utils/makeTrackIndex/makeTrackIndex.c
===================================================================
RCS file: src/hg/utils/makeTrackIndex/makeTrackIndex.c
diff -N src/hg/utils/makeTrackIndex/makeTrackIndex.c
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/utils/makeTrackIndex/makeTrackIndex.c	3 Jun 2010 23:41:29 -0000	1.1
@@ -0,0 +1,129 @@
+/* Make a track ixIxx file for the given to be used in the track search tool. */
+
+#include "common.h"
+#include "options.h"
+#include "hdb.h"
+#include "grp.h"
+#include "hui.h"
+#include "ra.h"
+
+static char const rcsid[] = "$Id$";
+
+void usage()
+/* Explain usage and exit. */
+{
+errAbort(
+  "makeTrackIndex - make a ixIxx input file for the tracks in given assembly.\n"
+  "usage:\n"
+  "   makeTrackIndex database\n\n");
+}
+
+static void printTrack(char *database, struct sqlConnection *conn, struct trackDb *tdb, char *html, 
+                       struct hash *grpHash, struct hash *cvHash)
+{
+char query[256];
+struct sqlResult *sr = NULL;
+char **row = NULL;
+char *metadataList[] = {"longLabel", NULL}; // include a fixed set of metadata (i.e. not stuff like subGroup).
+int i;
+char *grpLabel, *tmp;
+
+printf("%s ", tdb->track);
+safef(query, sizeof(query), "select val from metaDb where obj = '%s'", tdb->track);
+sr = sqlGetResult(conn, query);
+while ((row = sqlNextRow(sr)) != NULL)
+    {
+    printf("%s ", row[0]);
+    }
+sqlFreeResult(&sr);
+
+// XXXX Jim want's cv data after short/long label
+// XXXX Kate says we also need to include the long descriptions for these terms (get them from the .ra file??)
+
+if(cvHash)
+    {
+    sr = sqlGetResult(conn, query);
+    while ((row = sqlNextRow(sr)) != NULL)
+        {
+        struct hash *hash = hashFindVal(cvHash, row[0]);
+        if(hash != NULL)
+            {
+            char *str = hashFindVal(hash, "description");
+            if(str)
+                printf("%s ", str);
+            }
+        }
+    sqlFreeResult(&sr);
+    }
+
+for(i = 0; metadataList[i] != NULL; i++)
+    {
+    char *str = trackDbLocalSetting(tdb, metadataList[i]);
+    if(str != NULL)
+        printf("%s ", str);
+    }
+
+grpLabel = tdb->grp;
+tmp = hashFindVal(grpHash, grpLabel);
+if(tmp != NULL)
+    grpLabel = tmp;
+printf("%s ", grpLabel);
+
+
+if(html == NULL)
+    html = tdb->html;
+if(html != NULL)
+    {
+    char *tmp = cloneString(html);
+    char *val = nextWord(&tmp);
+    while(val != NULL)
+        {
+        // XXXX strip html markup.
+        printf("%s ", val);
+        val = nextWord(&tmp);
+        }
+    }
+printf("\n");
+
+// if(tdbIsComposite(tdb) && tdb->subtracks != NULL)
+if(tdbIsSuper(tdb))
+    hTrackDbLoadSuper(database, tdb);
+if(tdb->subtracks != NULL)
+    {
+    struct trackDb *subtrack;
+    for (subtrack = tdb->subtracks; subtrack != NULL; subtrack = subtrack->next)
+        printTrack(database, conn, subtrack, NULL, grpHash, cvHash);
+    }
+}
+
+int main(int argc, char *argv[])
+{
+char *database;
+struct trackDb *tdb, *tdbList = NULL;
+struct hash *grpHash = newHash(0);
+struct grp *grp, *grps;
+char filePath[PATH_LEN];
+struct hash *cvHash;
+
+if (argc < 2)
+    usage();
+database = argv[1];
+tdbList = hTrackDb(database, NULL);
+struct sqlConnection *conn = hAllocConn(database);
+
+grps = hLoadGrps(database);
+for (grp = grps; grp != NULL; grp = grp->next)
+    hashAdd(grpHash, grp->name, grp->label);
+
+// XXXX cvHash is work in progress...
+
+safef(filePath, sizeof(filePath), "/usr/local/apache/cgi-bin/encode/cv.ra");
+if(!fileExists(filePath))
+    errAbort("Error: can't locate cv.ra; %s doesn't exist\n", filePath);
+cvHash = raReadAll(filePath, "term");
+
+for (tdb = tdbList; tdb != NULL; tdb = tdb->next)
+    printTrack(database, conn, tdb, NULL, grpHash, cvHash);
+
+return 0;
+}