8931ab6b05b124503660f86d60fe34a38266d716 max Fri May 29 06:53:20 2020 -0700 OMIM: not showing phenotype table when there are no phenotypes and add more spaces, refs #18419 diff --git src/hg/inc/jksql.h src/hg/inc/jksql.h index 5ee523a..fc6e079 100644 --- src/hg/inc/jksql.h +++ src/hg/inc/jksql.h @@ -256,30 +256,33 @@ /* Escape a string for including in a tab seperated file. Freez or freeMem * result when done. */ struct sqlResult *sqlMustGetResult(struct sqlConnection *sc, char *query); /* Query database. * old comment: If result empty squawk and die. * This only applied back when sqlGetResult was using mysql_store_result. * These days, with mysql_use_result, we cannot know ahead of time * if there are results, we can only know by actually trying to fetch a row. * At then how would we put it back? So in fact right now sqlMustGetResult * is no different than sqlGetResult. */ void sqlFreeResult(struct sqlResult **pRes); /* Free up a result. */ +int sqlCountRows(struct sqlResult *sr); +/* on a sqlResult that was obtained with sqlStoreResult, return number of rows */ + int sqlCountColumns(struct sqlResult *sr); /* Count the number of columns in result. */ int sqlCountColumnsInTable(struct sqlConnection *sc, char *table); /* Return the number of columns in a table */ boolean sqlDatabaseExists(char *database); /* Return TRUE if database exists. */ boolean sqlTableExists(struct sqlConnection *sc, char *table); /* Return TRUE if a table exists. */ bool sqlColumnExists(struct sqlConnection *conn, char *tableName, char *column); /* return TRUE if column exists in table. column can contain sql wildcards */