Index: /tags/ipp-20100823/ippTools/share/Makefile.am =================================================================== --- /tags/ipp-20100823/ippTools/share/Makefile.am (revision 29306) +++ /tags/ipp-20100823/ippTools/share/Makefile.am (revision 29307) @@ -138,4 +138,5 @@ difftool_inputskyfile.sql \ difftool_listrun.sql \ + difftool_listssrun.sql \ difftool_pendingcleanuprun.sql \ difftool_pendingcleanupskyfile.sql \ @@ -274,4 +275,5 @@ pstamptool_revertreq.sql \ pstamptool_revertreq_deletejobs.sql \ + pstamptool_stopdependentjob.sql \ pstamptool_updatejob.sql \ pxadmin_create_tables.sql \ Index: /tags/ipp-20100823/ippTools/share/difftool_listrun.sql =================================================================== --- /tags/ipp-20100823/ippTools/share/difftool_listrun.sql (revision 29306) +++ /tags/ipp-20100823/ippTools/share/difftool_listrun.sql (revision 29307) @@ -25,4 +25,6 @@ rawInput.exp_name AS exp_name_1, rawInput.exp_id AS exp_id_1, + rawInput.comment AS comment_1, + rawInput.dateobs AS dateobs_1, chipInput.chip_id AS chip_id_1, camInput.cam_id AS cam_id_1, @@ -32,4 +34,6 @@ rawTemplate.exp_name AS exp_name_2, rawTemplate.exp_id AS exp_id_2, + rawTemplate.comment AS comment_2, + rawTemplate.dateobs AS dateobs_2, chipTemplate.chip_id AS chip_id_2, camTemplate.cam_id AS cam_id_2, Index: /tags/ipp-20100823/ippTools/share/difftool_listssrun.sql =================================================================== --- /tags/ipp-20100823/ippTools/share/difftool_listssrun.sql (revision 29307) +++ /tags/ipp-20100823/ippTools/share/difftool_listssrun.sql (revision 29307) @@ -0,0 +1,20 @@ +SELECT DISTINCT + diffRun.diff_id, + diffRun.state, + diffRun.workdir, + diffRun.label, + diffRun.data_group, + diffRun.dist_group, + diffRun.note, + diffRun.tess_id +FROM diffRun +JOIN diffInputSkyfile USING(diff_id) +JOIN stackRun AS stackInputRun + ON stackInputRun.stack_id = diffInputSkyfile.stack1 +JOIN stackSumSkyfile AS stackInput + ON stackInputRun.stack_id = stackInput.stack_id +JOIN stackRun AS stackTemplateRun + ON stackTemplateRun.stack_id = diffInputSkyfile.stack2 +JOIN stackSumSkyfile AS stackTemplate + ON stackTemplateRun.stack_id = stackTemplate.stack_id +WHERE diff_mode = 4 Index: /tags/ipp-20100823/ippTools/share/pstamptool_stopdependentjob.sql =================================================================== --- /tags/ipp-20100823/ippTools/share/pstamptool_stopdependentjob.sql (revision 29307) +++ /tags/ipp-20100823/ippTools/share/pstamptool_stopdependentjob.sql (revision 29307) @@ -0,0 +1,9 @@ +-- stop jobs which have a faulted dependent +UPDATE pstampDependent + JOIN pstampJob USING(dep_id) + JOIN pstampRequest USING(req_id) +SET pstampJob.state = 'stop', + pstampJob.fault = %d, + pstampDependent.fault = %d +WHERE pstampJob.state = 'run' + AND pstampDependent.state = 'new' Index: /tags/ipp-20100823/ippTools/src/difftool.c =================================================================== --- /tags/ipp-20100823/ippTools/src/difftool.c (revision 29306) +++ /tags/ipp-20100823/ippTools/src/difftool.c (revision 29307) @@ -60,4 +60,5 @@ static bool tofullskyfileMode(pxConfig *config); static bool listrunMode(pxConfig *config); +static bool listssrunMode(pxConfig *config); static bool setskyfiletoupdateMode(pxConfig *config); @@ -108,4 +109,5 @@ MODECASE(DIFFTOOL_MODE_TOFULLSKYFILE, tofullskyfileMode); MODECASE(DIFFTOOL_MODE_LISTRUN, listrunMode); + MODECASE(DIFFTOOL_MODE_LISTSSRUN, listssrunMode); MODECASE(DIFFTOOL_MODE_SETSKYFILETOUPDATE, setskyfiletoupdateMode); @@ -1236,4 +1238,5 @@ PXOPT_COPY_F32(config->args, warp2Where, "-good_frac", "warpSkyfile.good_frac", ">="); PXOPT_COPY_STR(config->args, stackWhere, "-stack_label", "stackRun.label", "=="); + PXOPT_COPY_STR(config->args, stackWhere, "-stack_data_group", "stackRun.data_group", "=="); PXOPT_LOOKUP_STR(workdir, config->args, "-set_workdir", true, false); // required option @@ -1607,4 +1610,5 @@ PXOPT_COPY_S64(config->args, selectWhere, "-warp_id", "inputWarpRun.warp_id", "=="); PXOPT_COPY_S64(config->args, selectWhere, "-exp_id", "inputRawExp.exp_id", "=="); + PXOPT_COPY_S64(config->args, selectWhere, "-template_exp_id", "templateRawExp.exp_id", "=="); PXOPT_COPY_STR(config->args, selectWhere, "-filter", "inputRawExp.filter", "=="); PXOPT_COPY_STR(config->args, selectWhere, "-obs_mode", "inputRawExp.obs_mode", "=="); @@ -1645,5 +1649,6 @@ PXOPT_COPY_F32(config->args, selectWhere, "-sun_angle_min", "inputRawExp.sun_angle", ">="); PXOPT_COPY_F32(config->args, selectWhere, "-sun_angle_max", "inputRawExp.sun_angle", "<"); - PXOPT_COPY_STR(config->args, selectWhere, "-comment", "inputRawExp.comment", "LIKE"); + PXOPT_COPY_STR(config->args, selectWhere, "-input_comment", "inputRawExp.comment", "LIKE"); + PXOPT_COPY_STR(config->args, selectWhere, "-template_comment", "templateRawExp.comment", "LIKE"); // Haversine formula for great circle distance @@ -1676,4 +1681,5 @@ PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false); + PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false); PXOPT_LOOKUP_BOOL(pretend, config->args, "-pretend", false); @@ -1835,4 +1841,7 @@ long numGood = 0; // Number of good rows added for (long i = 0; i < results->n; i++) { + if (limit && numGood >= limit) { + break; + } psMetadata *row = results->data[i]; // Result row from query @@ -2862,8 +2871,9 @@ psMetadata *where = psMetadataAlloc(); - PXOPT_COPY_S64(config->args, where, "-diff_id", "diffRun.diff_id", "=="); - PXOPT_COPY_STR(config->args, where, "-tess_id", "diffRun.tess_id", "=="); - PXOPT_COPY_S64(config->args, where, "-magicked", "diffRun.magicked", "=="); - pxAddLabelSearchArgs (config, where, "-label", "diffRun.label", "LIKE"); + PXOPT_COPY_S64(config->args, where, "-diff_id", "diffRun.diff_id", "=="); + PXOPT_COPY_STR(config->args, where, "-tess_id", "diffRun.tess_id", "LIKE"); + PXOPT_COPY_S64(config->args, where, "-magicked", "diffRun.magicked", "=="); + PXOPT_COPY_STR(config->args, where, "-state", "diffRun.state", "=="); + pxAddLabelSearchArgs (config, where, "-label", "diffRun.label", "LIKE"); pxAddLabelSearchArgs (config, where, "-data_group", "diffRun.data_group", "LIKE"); pxAddLabelSearchArgs (config, where, "-dist_group", "diffRun.dist_group", "LIKE"); @@ -2971,4 +2981,121 @@ return true; } +static bool listssrunMode(pxConfig *config) +{ + PS_ASSERT_PTR_NON_NULL(config, false); + + psMetadata *where = psMetadataAlloc(); + PXOPT_COPY_S64(config->args, where, "-diff_id", "diffRun.diff_id", "=="); + PXOPT_COPY_S64(config->args, where, "-stack_id", "stackInput.stack_id", "=="); + PXOPT_COPY_S64(config->args, where, "-template_stack_id", "stackTemplate.stack_id", "=="); + PXOPT_COPY_STR(config->args, where, "-tess_id", "diffRun.tess_id", "LIKE"); + PXOPT_COPY_STR(config->args, where, "-state", "diffRun.state", "=="); + pxAddLabelSearchArgs (config, where, "-label", "diffRun.label", "LIKE"); + pxAddLabelSearchArgs (config, where, "-data_group", "diffRun.data_group", "LIKE"); + pxAddLabelSearchArgs (config, where, "-dist_group", "diffRun.dist_group", "LIKE"); + + // lookup these so we don't compare to zero if they are not supplied + PXOPT_LOOKUP_F64(mjd_obs_begin, config->args, "-mjd_obs_begin", false, false); + PXOPT_LOOKUP_F64(mjd_obs_end, config->args, "-mjd_obs_end", false, false); + + PXOPT_LOOKUP_BOOL(template, config->args, "-template", false); + + if (!template) { + if (mjd_obs_begin) { + PXOPT_COPY_F64(config->args, where, "-mjd_obs_begin", "stackInput.mjd_obs", ">="); + } + if (mjd_obs_end) { + PXOPT_COPY_F64(config->args, where, "-mjd_obs_end", "stackInput.mjd_obs", "<="); + } + PXOPT_COPY_STR(config->args, where, "-filter", "stackInputRun.filter", "LIKE"); + } else { + if (mjd_obs_begin) { + PXOPT_COPY_F64(config->args, where, "-mjd_obs_begin", "stackTemplate.mjd_obs", ">="); + } + if (mjd_obs_end) { + PXOPT_COPY_F64(config->args, where, "-mjd_obs_end", "stackTemplate.mjd_obs", "<="); + } + PXOPT_COPY_STR(config->args, where, "-filter", "stackTemplateRun.filter", "LIKE"); + } + + PXOPT_LOOKUP_BOOL(all, config->args, "-all", false); + PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false); + PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false); + PXOPT_LOOKUP_BOOL(pstamp_order, config->args, "-pstamp_order", false); + + psString where2 = NULL; + psString query = pxDataGet("difftool_listssrun.sql"); + if (!query) { + psError(PXTOOLS_ERR_SYS, false, "failed to retreive SQL statement"); + return false; + } + + if (psListLength(where->list)) { + psString whereClause = psDBGenerateWhereConditionSQL(where, NULL); + psStringAppend(&query, " AND %s", whereClause); + psFree(whereClause); + } else if (where2) { + psStringAppend(&query, " AND %s", where2); + } else if (!all) { + psError(PXTOOLS_ERR_CONFIG, true, "search parameters or -all are required"); + return false; + } + psFree(where); + + if (pstamp_order) { + if (template) { + psStringAppend(&query, " ORDER BY stackTemplate.stack_id, diff_id DESC"); + } else { + psStringAppend(&query, " ORDER BY stackInput.stack_id, diff_id DESC"); + } + } + + // treat limit == 0 as "no limit" + if (limit) { + psString limitString = psDBGenerateLimitSQL(limit); + psStringAppend(&query, " %s", limitString); + psFree(limitString); + } + + if (!p_psDBRunQuery(config->dbh, query)) { + psError(PS_ERR_UNKNOWN, false, "database error"); + psFree(query); + return false; + } + psFree(query); + + psArray *output = p_psDBFetchResult(config->dbh); + if (!output) { + psErrorCode err = psErrorCodeLast(); + switch (err) { + case PS_ERR_DB_CLIENT: + psError(PXTOOLS_ERR_SYS, false, "database error"); + case PS_ERR_DB_SERVER: + psError(PXTOOLS_ERR_PROG, false, "database error"); + default: + psError(PXTOOLS_ERR_PROG, false, "unknown error"); + } + + return false; + } + if (!psArrayLength(output)) { + psTrace("difftool", PS_LOG_INFO, "no rows found"); + psFree(output); + return true; + } + + if (psArrayLength(output)) { + // negative simple so the default is true + if (!ippdbPrintMetadatas(stdout, output, "diffRun", !simple)) { + psError(PS_ERR_UNKNOWN, false, "failed to print array"); + psFree(output); + return false; + } + } + + psFree(output); + + return true; +} // a very specfic function to queue a cleaned warpSkyfile to be updated static bool setskyfiletoupdateMode(pxConfig *config) Index: /tags/ipp-20100823/ippTools/src/difftool.h =================================================================== --- /tags/ipp-20100823/ippTools/src/difftool.h (revision 29306) +++ /tags/ipp-20100823/ippTools/src/difftool.h (revision 29307) @@ -51,4 +51,5 @@ DIFFTOOL_MODE_TOFULLSKYFILE, DIFFTOOL_MODE_LISTRUN, + DIFFTOOL_MODE_LISTSSRUN, DIFFTOOL_MODE_SETSKYFILETOUPDATE, } difftoolMode; Index: /tags/ipp-20100823/ippTools/src/difftoolConfig.c =================================================================== --- /tags/ipp-20100823/ippTools/src/difftoolConfig.c (revision 29306) +++ /tags/ipp-20100823/ippTools/src/difftoolConfig.c (revision 29307) @@ -185,4 +185,5 @@ psMetadataAddStr(listrunArgs, PS_LIST_TAIL, "-dist_group", PS_META_DUPLICATE_OK, "search by diffRun dist_group (LIKE comparison)", NULL); psMetadataAddS16(listrunArgs, PS_LIST_TAIL, "-diff_mode", 0, "search for diff_mode", 0); + psMetadataAddStr(listrunArgs, PS_LIST_TAIL, "-state", 0, "search by state", NULL); pxmagicAddArguments(listrunArgs); pxspaceAddArguments(listrunArgs); @@ -193,4 +194,29 @@ psMetadataAddU64(listrunArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); psMetadataAddBool(listrunArgs, PS_LIST_TAIL, "-simple", 0, "use the simple output format", false); + + + // -listssrun + psMetadata *listssrunArgs = psMetadataAlloc(); + psMetadataAddS64(listssrunArgs, PS_LIST_TAIL, "-diff_id", 0, "search by diff ID", 0); + psMetadataAddStr(listssrunArgs, PS_LIST_TAIL, "-tess_id", 0, "search by tessellation ID", NULL); + psMetadataAddS64(listssrunArgs , PS_LIST_TAIL, "-stack_id", 0, "search by input stack_id", 0); + psMetadataAddS64(listssrunArgs , PS_LIST_TAIL, "-template_stack_id",0, "search by template stack_id", 0); + psMetadataAddBool(listssrunArgs, PS_LIST_TAIL, "-template", 0, "apply stack selectors to template", false); + psMetadataAddF64(listssrunArgs, PS_LIST_TAIL, "-mjd_obs_begin", 0, "search by stack MJD-OBS (>=)", 0); + psMetadataAddF64(listssrunArgs, PS_LIST_TAIL, "-mjd_obs_end", 0, "search by stack MJD-OBS(<=)", 0); + psMetadataAddStr(listssrunArgs, PS_LIST_TAIL, "-filter", 0, "search by stack filter", NULL); + psMetadataAddStr(listssrunArgs, PS_LIST_TAIL, "-label", PS_META_DUPLICATE_OK, "search by diffRun label (LIKE comparison)", NULL); + psMetadataAddStr(listssrunArgs, PS_LIST_TAIL, "-data_group", PS_META_DUPLICATE_OK, "search by diffRun data_group (LIKE comparison)", NULL); + psMetadataAddStr(listssrunArgs, PS_LIST_TAIL, "-dist_group", PS_META_DUPLICATE_OK, "search by diffRun dist_group (LIKE comparison)", NULL); + psMetadataAddS16(listssrunArgs, PS_LIST_TAIL, "-diff_mode", 0, "search for diff_mode", 0); + psMetadataAddStr(listssrunArgs, PS_LIST_TAIL, "-state", 0, "search by state", NULL); + pxmagicAddArguments(listssrunArgs); + pxspaceAddArguments(listssrunArgs); + + psMetadataAddBool(listssrunArgs, PS_LIST_TAIL, "-pstamp_order", 0, "order results for postage stamp server", false); + + psMetadataAddBool(listssrunArgs, PS_LIST_TAIL, "-all", 0, "search without arguments", false); + psMetadataAddU64(listssrunArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); + psMetadataAddBool(listssrunArgs, PS_LIST_TAIL, "-simple", 0, "use the simple output format", false); @@ -226,4 +252,5 @@ psMetadataAddStr(definewarpstackArgs, PS_LIST_TAIL, "-comment", 0, "search by comment (LIKE)", NULL); psMetadataAddStr(definewarpstackArgs, PS_LIST_TAIL, "-stack_label", 0, "search by stack label", NULL); + psMetadataAddStr(definewarpstackArgs, PS_LIST_TAIL, "-stack_data_group", 0, "search by stack data_group", NULL); psMetadataAddStr(definewarpstackArgs, PS_LIST_TAIL, "-warp_label", 0, "search by warp label", NULL); psMetadataAddStr(definewarpstackArgs, PS_LIST_TAIL, "-data_group", 0, "search by data_group", NULL); @@ -246,4 +273,5 @@ psMetadataAddS64(definewarpwarpArgs, PS_LIST_TAIL, "-warp_id", 0, "search by warp ID", 0); psMetadataAddS64(definewarpwarpArgs, PS_LIST_TAIL, "-exp_id", 0, "search by exposure ID", 0); + psMetadataAddS64(definewarpwarpArgs, PS_LIST_TAIL, "-template_exp_id", 0, "search by template exposure ID", 0); psMetadataAddStr(definewarpwarpArgs, PS_LIST_TAIL, "-filter", 0, "search by filter", NULL); psMetadataAddF32(definewarpwarpArgs, PS_LIST_TAIL, "-distance", 0, "limit distance between input and template (deg)", NAN); @@ -291,7 +319,9 @@ psMetadataAddF64(definewarpwarpArgs, PS_LIST_TAIL, "-posang_min", 0, "search by min rotator position angle", NAN); psMetadataAddF64(definewarpwarpArgs, PS_LIST_TAIL, "-posang_max", 0, "search by max rotator position angle", NAN); - psMetadataAddF32(definewarpwarpArgs, PS_LIST_TAIL, "-sun_angle_min", 0, "search by min solar angle", NAN); - psMetadataAddF32(definewarpwarpArgs, PS_LIST_TAIL, "-sun_angle_max", 0, "search by max solar angle", NAN); - psMetadataAddStr(definewarpwarpArgs, PS_LIST_TAIL, "-comment", 0, "search by comment field (LIKE comparison)", NULL); + psMetadataAddF32(definewarpwarpArgs, PS_LIST_TAIL, "-sun_angle_min", 0, "search by min solar angle", NAN); + psMetadataAddF32(definewarpwarpArgs, PS_LIST_TAIL, "-sun_angle_max", 0, "search by max solar angle", NAN); + psMetadataAddStr(definewarpwarpArgs, PS_LIST_TAIL, "-input_comment", 0, "search by comment field for input exposure(LIKE comparison)", NULL); + psMetadataAddStr(definewarpwarpArgs, PS_LIST_TAIL, "-template_comment", 0, "search by comment field for template exposure(LIKE comparison)", NULL); + psMetadataAddU64(definewarpwarpArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); // -definestackstack @@ -425,5 +455,4 @@ PXOPT_ADD_MODE("-advance", "", DIFFTOOL_MODE_ADVANCE, advanceArgs); PXOPT_ADD_MODE("-diffskyfile", "", DIFFTOOL_MODE_DIFFSKYFILE, diffskyfileArgs); - PXOPT_ADD_MODE("-listrun", "", DIFFTOOL_MODE_LISTRUN, listrunArgs); PXOPT_ADD_MODE("-revertdiffskyfile","", DIFFTOOL_MODE_REVERTDIFFSKYFILE, revertdiffskyfileArgs); PXOPT_ADD_MODE("-definepoprun", "", DIFFTOOL_MODE_DEFINEPOPRUN, definepoprunArgs); @@ -431,4 +460,6 @@ PXOPT_ADD_MODE("-definewarpwarp", "", DIFFTOOL_MODE_DEFINEWARPWARP, definewarpwarpArgs); PXOPT_ADD_MODE("-definestackstack", "", DIFFTOOL_MODE_DEFINESTACKSTACK, definestackstackArgs); + PXOPT_ADD_MODE("-listrun", "list diff runs", DIFFTOOL_MODE_LISTRUN, listrunArgs); + PXOPT_ADD_MODE("-listssrun", "list stack-stack diff runs", DIFFTOOL_MODE_LISTSSRUN, listssrunArgs); PXOPT_ADD_MODE("-pendingcleanuprun", "show runs that need to be cleaned up", DIFFTOOL_MODE_PENDINGCLEANUPRUN, pendingcleanuprunArgs); PXOPT_ADD_MODE("-pendingcleanupskyfile", "show runs that need to be cleaned up", DIFFTOOL_MODE_PENDINGCLEANUPSKYFILE, pendingcleanupskyfileArgs); Index: /tags/ipp-20100823/ippTools/src/stacktool.c =================================================================== --- /tags/ipp-20100823/ippTools/src/stacktool.c (revision 29306) +++ /tags/ipp-20100823/ippTools/src/stacktool.c (revision 29307) @@ -1096,5 +1096,5 @@ psMetadata *where = psMetadataAlloc(); PXOPT_COPY_S64(config->args, where, "-stack_id", "stackSumSkyfile.stack_id", "=="); - PXOPT_COPY_STR(config->args, where, "-tess_id", "stackRun.tess_id", "=="); + PXOPT_COPY_STR(config->args, where, "-tess_id", "stackRun.tess_id", "LIKE"); PXOPT_COPY_STR(config->args, where, "-skycell_id", "stackRun.skycell_id", "=="); PXOPT_COPY_STR(config->args, where, "-filter", "stackRun.filter", "LIKE"); @@ -1102,4 +1102,7 @@ PXOPT_COPY_STR(config->args, where, "-data_group", "stackRun.data_group", "LIKE"); PXOPT_COPY_S16(config->args, where, "-fault", "stackSumSkyfile.fault", "=="); + PXOPT_COPY_F64(config->args, where, "-mjd_obs_begin", "stackSumSkyfile.mjd_obs", ">="); + PXOPT_COPY_F64(config->args, where, "-mjd_obs_end", "stackSumSkyfile.mjd_obs", "<="); + // The following three selectors are incompatible with the sql so omit them Index: /tags/ipp-20100823/ippTools/src/stacktoolConfig.c =================================================================== --- /tags/ipp-20100823/ippTools/src/stacktoolConfig.c (revision 29306) +++ /tags/ipp-20100823/ippTools/src/stacktoolConfig.c (revision 29307) @@ -186,5 +186,5 @@ psMetadata *sumskyfileArgs= psMetadataAlloc(); psMetadataAddS64(sumskyfileArgs, PS_LIST_TAIL, "-stack_id", 0, "search by stack ID", 0); - psMetadataAddStr(sumskyfileArgs, PS_LIST_TAIL, "-tess_id", 0, "search by tess ID", 0); + psMetadataAddStr(sumskyfileArgs, PS_LIST_TAIL, "-tess_id", 0, "search by tess ID (LIKE comparison)", 0); psMetadataAddStr(sumskyfileArgs, PS_LIST_TAIL, "-skycell_id", 0, "search by skycell ID", 0); #ifdef notdef @@ -197,4 +197,6 @@ psMetadataAddStr(sumskyfileArgs, PS_LIST_TAIL, "-data_group", 0, "search by stackRun.data_group (LIKE comparison)", NULL); psMetadataAddStr(sumskyfileArgs, PS_LIST_TAIL, "-filter", 0, "search by filter (LIKE comparison)", NULL); + psMetadataAddF64(sumskyfileArgs, PS_LIST_TAIL, "-mjd_obs_begin", 0, "search by mjd_obs (average mjd_obs of inputs <=)", NAN); + psMetadataAddF64(sumskyfileArgs, PS_LIST_TAIL, "-mjd_obs_end", 0, "search by mjd_obs (average mjd_obs of inputs>=)", NAN); psMetadataAddS16(sumskyfileArgs, PS_LIST_TAIL, "-fault", 0, "search by fault code", 0); psMetadataAddU64(sumskyfileArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); @@ -205,5 +207,5 @@ psMetadata *sassskyfileArgs = psMetadataAlloc(); psMetadataAddS64(sassskyfileArgs, PS_LIST_TAIL, "-sass_id", 0, "search by stack association ID", 0); - psMetadataAddStr(sassskyfileArgs, PS_LIST_TAIL, "-tess_id", 0, "search by tess ID", 0); + psMetadataAddStr(sassskyfileArgs, PS_LIST_TAIL, "-tess_id", 0, "search by tess ID (LIKE comparison)", 0); psMetadataAddStr(sassskyfileArgs, PS_LIST_TAIL, "-projection_cell", 0, "search by projection cell", 0);