9318b2b63e004429cdce7c841143f6e7d9d41f5b angie Fri Jun 20 15:14:58 2014 -0700 Added sqlQuickPairList for quick two-column queries. diff --git src/hg/inc/jksql.h src/hg/inc/jksql.h index 11190b6..af79525 100644 --- src/hg/inc/jksql.h +++ src/hg/inc/jksql.h @@ -313,30 +313,34 @@ /* Return a list of slNames for a single column query. * Do a slFreeList on result when done. */ struct hash *sqlQuickHash(struct sqlConnection *conn, char *query); /* Return a hash filled with results of two column query. * The first column is the key, the second the value. */ struct slInt *sqlQuickNumList(struct sqlConnection *conn, char *query); /* Return a list of slInts for a single column query. * Do a slFreeList on result when done. */ struct slDouble *sqlQuickDoubleList(struct sqlConnection *conn, char *query); /* Return a list of slDoubles for a single column query. * Do a slFreeList on result when done. */ +struct slPair *sqlQuickPairList(struct sqlConnection *conn, char *query); +/* Return a list of slPairs with the results of a two-column query. + * Free result with slPairFreeValsAndList. */ + void sqlRenameTable(struct sqlConnection *sc, char *table1, char *table2); /* Rename table */ void sqlCopyTable(struct sqlConnection *sc, char *table1, char *table2); /* Copy table1 to table2 */ void sqlDropTable(struct sqlConnection *sc, char *table); /* Drop table if it exists. */ void sqlGetLock(struct sqlConnection *sc, char *name); /* Sets an advisory lock on the process for 1000s returns 1 if successful,*/ /* 0 if name already locked or NULL if error occurred */ /* blocks another client from obtaining a lock with the same name */ void sqlReleaseLock(struct sqlConnection *sc, char *name);