e8ffc5e45bd8e8de9f1c78347ea6b11fd4817a40
chmalee
  Mon Dec 2 12:37:53 2024 -0800
Generate api keys for each user and store them in hgcentral.hubSpaceKeys

diff --git src/hg/lib/hubSpaceKeys.c src/hg/lib/hubSpaceKeys.c
new file mode 100644
index 0000000..8cff7ed
--- /dev/null
+++ src/hg/lib/hubSpaceKeys.c
@@ -0,0 +1,136 @@
+/* hubSpaceKeys.c was originally generated by the autoSql program, which also 
+ * generated hubSpaceKeys.h and hubSpaceKeys.sql.  This module links the database and
+ * the RAM representation of objects. */
+
+#include "common.h"
+#include "linefile.h"
+#include "dystring.h"
+#include "jksql.h"
+#include "hubSpaceKeys.h"
+#include "hdb.h"
+
+
+
+char *hubSpaceKeysCommaSepFieldNames = "userName,apiKey";
+
+void hubSpaceKeysStaticLoad(char **row, struct hubSpaceKeys *ret)
+/* Load a row from hubSpaceKeys table into ret.  The contents of ret will
+ * be replaced at the next call to this function. */
+{
+
+ret->userName = row[0];
+ret->apiKey = row[1];
+}
+
+struct hubSpaceKeys *hubSpaceKeysLoad(char **row)
+/* Load a hubSpaceKeys from row fetched with select * from hubSpaceKeys
+ * from database.  Dispose of this with hubSpaceKeysFree(). */
+{
+struct hubSpaceKeys *ret;
+
+AllocVar(ret);
+ret->userName = cloneString(row[0]);
+ret->apiKey = cloneString(row[1]);
+return ret;
+}
+
+struct hubSpaceKeys *hubSpaceKeysLoadAll(char *fileName) 
+/* Load all hubSpaceKeys from a whitespace-separated file.
+ * Dispose of this with hubSpaceKeysFreeList(). */
+{
+struct hubSpaceKeys *list = NULL, *el;
+struct lineFile *lf = lineFileOpen(fileName, TRUE);
+char *row[2];
+
+while (lineFileRow(lf, row))
+    {
+    el = hubSpaceKeysLoad(row);
+    slAddHead(&list, el);
+    }
+lineFileClose(&lf);
+slReverse(&list);
+return list;
+}
+
+struct hubSpaceKeys *hubSpaceKeysLoadAllByChar(char *fileName, char chopper) 
+/* Load all hubSpaceKeys from a chopper separated file.
+ * Dispose of this with hubSpaceKeysFreeList(). */
+{
+struct hubSpaceKeys *list = NULL, *el;
+struct lineFile *lf = lineFileOpen(fileName, TRUE);
+char *row[2];
+
+while (lineFileNextCharRow(lf, chopper, row, ArraySize(row)))
+    {
+    el = hubSpaceKeysLoad(row);
+    slAddHead(&list, el);
+    }
+lineFileClose(&lf);
+slReverse(&list);
+return list;
+}
+
+struct hubSpaceKeys *hubSpaceKeysCommaIn(char **pS, struct hubSpaceKeys *ret)
+/* Create a hubSpaceKeys out of a comma separated string. 
+ * This will fill in ret if non-null, otherwise will
+ * return a new hubSpaceKeys */
+{
+char *s = *pS;
+
+if (ret == NULL)
+    AllocVar(ret);
+ret->userName = sqlStringComma(&s);
+ret->apiKey = sqlStringComma(&s);
+*pS = s;
+return ret;
+}
+
+void hubSpaceKeysFree(struct hubSpaceKeys **pEl)
+/* Free a single dynamically allocated hubSpaceKeys such as created
+ * with hubSpaceKeysLoad(). */
+{
+struct hubSpaceKeys *el;
+
+if ((el = *pEl) == NULL) return;
+freeMem(el->userName);
+freeMem(el->apiKey);
+freez(pEl);
+}
+
+void hubSpaceKeysFreeList(struct hubSpaceKeys **pList)
+/* Free a list of dynamically allocated hubSpaceKeys's */
+{
+struct hubSpaceKeys *el, *next;
+
+for (el = *pList; el != NULL; el = next)
+    {
+    next = el->next;
+    hubSpaceKeysFree(&el);
+    }
+*pList = NULL;
+}
+
+void hubSpaceKeysOutput(struct hubSpaceKeys *el, FILE *f, char sep, char lastSep) 
+/* Print out hubSpaceKeys.  Separate fields with sep. Follow last field with lastSep. */
+{
+if (sep == ',') fputc('"',f);
+fprintf(f, "%s", el->userName);
+if (sep == ',') fputc('"',f);
+fputc(sep,f);
+if (sep == ',') fputc('"',f);
+fprintf(f, "%s", el->apiKey);
+if (sep == ',') fputc('"',f);
+fputc(lastSep,f);
+}
+
+/* -------------------------------- End autoSql Generated Code -------------------------------- */
+
+char *userNameForApiKey(char *apiKey)
+/* Return userName associated with apiKey else NULL */
+{
+struct sqlConnection *conn = hConnectCentral();
+struct dyString *query = sqlDyStringCreate("select userName from %s where apiKey = '%s'", HUBSPACE_AUTH_TABLE, apiKey);
+char *userName = sqlQuickString(conn, dyStringCannibalize(&query));
+hDisconnectCentral(&conn);
+return userName;
+}