080a160c7b9595d516c9c70e83689a09b60839d0 galt Mon Jun 3 12:16:53 2013 -0700 fix SQL Injection diff --git src/hg/inc/ucscRetroOrtho.h src/hg/inc/ucscRetroOrtho.h index ef3c654..fd180bb 100644 --- src/hg/inc/ucscRetroOrtho.h +++ src/hg/inc/ucscRetroOrtho.h @@ -21,42 +21,31 @@ /* Load a row from ucscRetroOrtho table into ret. The contents of ret will * be replaced at the next call to this function. */ struct ucscRetroOrtho *ucscRetroOrthoLoadByQuery(struct sqlConnection *conn, char *query); /* Load all ucscRetroOrtho from table that satisfy the query given. * Where query is of the form 'select * from example where something=something' * or 'select example.* from example, anotherTable where example.something = * anotherTable.something'. * Dispose of this with ucscRetroOrthoFreeList(). */ void ucscRetroOrthoSaveToDb(struct sqlConnection *conn, struct ucscRetroOrtho *el, char *tableName, int updateSize); /* Save ucscRetroOrtho as a row to the table specified by tableName. * As blob fields may be arbitrary size updateSize specifies the approx size * of a string that would contain the entire query. Arrays of native types are * converted to comma separated strings and loaded as such, User defined types are - * inserted as NULL. Note that strings must be escaped to allow insertion into the database. - * For example "autosql's features include" --> "autosql\'s features include" - * If worried about this use ucscRetroOrthoSaveToDbEscaped() */ - -void ucscRetroOrthoSaveToDbEscaped(struct sqlConnection *conn, struct ucscRetroOrtho *el, char *tableName, int updateSize); -/* Save ucscRetroOrtho as a row to the table specified by tableName. - * As blob fields may be arbitrary size updateSize specifies the approx size. - * of a string that would contain the entire query. Automatically - * escapes all simple strings (not arrays of string) but may be slower than ucscRetroOrthoSaveToDb(). - * For example automatically copies and converts: - * "autosql's features include" --> "autosql\'s features include" - * before inserting into database. */ + * inserted as NULL. Strings are automatically escaped to allow insertion into the database. */ struct ucscRetroOrtho *ucscRetroOrthoLoad(char **row); /* Load a ucscRetroOrtho from row fetched with select * from ucscRetroOrtho * from database. Dispose of this with ucscRetroOrthoFree(). */ struct ucscRetroOrtho *ucscRetroOrthoLoadAll(char *fileName); /* Load all ucscRetroOrtho from whitespace-separated file. * Dispose of this with ucscRetroOrthoFreeList(). */ struct ucscRetroOrtho *ucscRetroOrthoLoadAllByChar(char *fileName, char chopper); /* Load all ucscRetroOrtho from chopper separated file. * Dispose of this with ucscRetroOrthoFreeList(). */ #define ucscRetroOrthoLoadAllByTab(a) ucscRetroOrthoLoadAllByChar(a, '\t'); /* Load all ucscRetroOrtho from tab separated file.