65d4e214bd753220cd3f1b9700f107ef1ae648da chmalee Fri May 24 09:36:42 2024 -0700 Make hubSpace autoSql files, haven't created the table yet diff --git src/hg/inc/jksql.h src/hg/inc/jksql.h index 3722ce0..d6162fc 100644 --- src/hg/inc/jksql.h +++ src/hg/inc/jksql.h @@ -105,30 +105,34 @@ char *sqlHostInfo(struct sqlConnection *sc); /* Returns the mysql host info for the connection, must be connected. */ void sqlDisconnect(struct sqlConnection **pSc); /* Close down connection. */ char* sqlGetDatabase(struct sqlConnection *sc); /* Get the database associated with an connection. Warning: return may be NULL! */ char* sqlGetHost(struct sqlConnection *sc); /* Get the host associated with an connection. */ struct slName *sqlGetAllDatabase(struct sqlConnection *sc); /* Get a list of all database on the server */ +bool sqlTableExistsOnMain(struct sqlConnection *sc, char *tableName); +/* Return TRUE if the table can be queried using sc's main conn; + * don't check failoverConn or the table cache (showTableCache in hg.conf). */ + struct slName *sqlListTablesLike(struct sqlConnection *conn, char *likeExpr); /* Return list of tables in database associated with conn. Optionally filter list with * given LIKE expression that can be NULL or string e.g. "LIKE 'snp%'". */ struct slName *sqlListTables(struct sqlConnection *conn); /* Return list of tables in database associated with conn. */ struct slName *sqlListFields(struct sqlConnection *conn, char *table); /* Return list of fields in table. */ struct sqlResult *sqlDescribe(struct sqlConnection *conn, char *table); /* Run the sql DESCRIBE command or get a cached table description and return the sql result */ void sqlAddDatabaseFields(char *database, struct hash *hash); /* Add fields from the one database to hash. */