fa9a4052cbc6e42d290560755e5f8302c267ce7e tdreszer Mon Jun 28 16:15:42 2010 -0700 Added special features to mdbPrint to print SQL insert statements for expTable and spacial case extension for adding expIds to exisiting mdb objects. diff --git src/hg/inc/mdb.h src/hg/inc/mdb.h index 6087703..1a929e1 100644 --- src/hg/inc/mdb.h +++ src/hg/inc/mdb.h @@ -221,7 +221,7 @@ struct mdbByVar *mdbByVarsQuery(struct sqlConnection *conn,char *table,struct mdbByVar *mdbByVars); // Query the metadata table by one or more var=val pairs to find the distinct set of objs that satisfy ANY conditions. -// Returns new mdbByVar struct fully populated and sorted in var,val,obj order. +// ReturthisSelectionns new mdbByVar struct fully populated and sorted in var,val,obj order. #define mdbByVarsQueryAll(conn,table) mdbByVarsQuery((conn),(table),NULL) struct mdbByVar *mdbByVarQueryByVar(struct sqlConnection *conn,char *table,char *varName,char *val); @@ -248,6 +248,9 @@ void mdbObjPrintUpdateLines(struct mdbObj **mdbObjs,char *dbToUpdate,char *tableToUpdate, char *expDefiningVars,char *varsToSet); // prints mdbUpdate lines to allow taking vars from one db to another (sorts mdbObjs so pass pointer) +void mdbObjPrintInsertToExperimentsTable(struct mdbObj **mdbObjs,char *expTableName, char *expDefiningVars); +// prints insert statments for the experiments taable to backfile experiments submitted before the experiments table existed + // ----------------- Utilities ----------------- char *mdbObjFindValue(struct mdbObj *mdbObj, char *var); // Finds the val associated with the var or retruns NULL