/* Copyright (C) 2014 The Regents of the University of California 
 * See kent/LICENSE or http://genome.ucsc.edu/license/ for licensing information. */

#include "common.h"
#include "hCommon.h"
#include "hdb.h"
#include "errAbort.h"
#include "kgAlias.h"

static void addKgAlias(struct sqlConnection *conn, struct dyString *query,
       struct kgAlias **pList)
/* Query database and add returned kgAlias to head of list. */
{
struct sqlResult *sr = sqlGetResult(conn, query->string);
char **row;
while ((row = sqlNextRow(sr)) != NULL)
    {
    struct kgAlias *kl = kgAliasLoad(row);
    slAddHead(pList, kl);
    }
sqlFreeResult(&sr);
}

struct kgAlias *findKGAlias(char *dataBase, char *spec, char *mode)
/* findKGAlias Looks up aliases for Known Genes, given a seach spec 
 *   mode "E" is for Exact match
 *   mode "F" is for Fuzzy match
 *   mode "P" is for Prefix match
 * it returns a link list of kgAlias nodes, which contain kgID and Alias */
{
struct sqlConnection *conn  = hAllocConn(dataBase);
struct dyString      *ds    = dyStringNew(256);
struct kgAlias *kaList 	    = NULL;
char   fullTableName[256];

safef(fullTableName, 250, "%s.%s", dataBase, "kgAlias");
if (!sqlTableExists(conn, fullTableName))
    {
    errAbort("Table %s.kgAlias does not exist.\n", dataBase);
    }

if (sameString(mode, "E"))
    {
    sqlDyStringPrintf(ds, "select * from %s.kgAlias where alias = '%s'", dataBase, spec);
    }
else if (sameString(mode, "F"))
    {
    sqlDyStringPrintf(ds, "select * from %s.kgAlias where alias like '%%%s%%'", 
    	dataBase, spec);
    }
else if (sameString(mode, "P"))
    {
    sqlDyStringPrintf(ds, "select * from %s.kgAlias where alias like '%s%%'", 
    	dataBase, spec);
    }
addKgAlias(conn, ds, &kaList);
hFreeConn(&conn);
return(kaList);
}