src/hg/lib/loweutils.c 1.1

Index: src/hg/lib/loweutils.c
===================================================================
RCS file: src/hg/lib/loweutils.c
diff -N src/hg/lib/loweutils.c
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/lib/loweutils.c	23 Sep 2009 21:48:30 -0000	1.1
@@ -0,0 +1,96 @@
+#include "common.h"
+#include "errabort.h"
+#include "bed.h"
+#include "cart.h"
+#include "cheapcgi.h"
+#include "hPrint.h"
+#include "hui.h"
+#include "jksql.h"
+#include "web.h"
+#include "loweutils.h"
+#include "hgConfig.h"
+#include "hdb.h"
+#include "minGeneInfo.h"
+
+int parseDelimitedString(char *inString, char delimiter, char *outString[], int outSize)
+{
+    int arrayCount = 0;
+    int charCount = 0;
+    int start = 0;
+    char *out = NULL;
+
+    for (charCount = 0; charCount < strlen(inString); charCount++)
+    {
+        if (inString[charCount] == delimiter)
+        {
+            if (arrayCount < outSize)
+            {
+                out = malloc(sizeof(char) * (charCount - start + 1));
+                memcpy(out, inString + start, sizeof(char) * (charCount - start));
+                out[charCount - start] = '\0';
+                outString[arrayCount++] = out;
+                start = charCount + 1;
+            }
+        }
+    }
+    if (arrayCount < outSize)
+    {
+        out = malloc(sizeof(char) * (charCount - start + 1));
+        memcpy(out, inString + start, sizeof(char) * (charCount - start));
+        out[charCount - start] = '\0';
+        outString[arrayCount++] = out;
+    }
+
+    return arrayCount;
+}
+struct minGeneInfo* getGbProtCodeInfo(struct sqlConnection *conn, char* dbName, char *geneName)
+{
+    char query[512];
+    struct sqlResult *sr = NULL;
+    char **row;
+    struct minGeneInfo* ginfo = NULL;
+    char gbProtCodeXra[50];
+
+    if (strcmp(database, dbName) == 0)
+        strcpy(gbProtCodeXra, "gbProtCodeXra");
+    else
+    {
+        strcpy(gbProtCodeXra, dbName);
+        strcat(gbProtCodeXra, ".gbProtCodeXra");
+    }
+    if (hTableExists(dbName, "gbProtCodeXra"))
+    {
+        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");
+
+    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);
+    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);
+        if ((rowDb = sqlNextRow(srDb)) != NULL)
+        {
+            strcpy(genome, rowDb[0]);
+            strcpy(clade, rowDb[1]);
+        }
+    }
+    sqlFreeResult(&srDb);
+}