Changeset 19423
- Timestamp:
- Sep 8, 2008, 2:28:25 PM (18 years ago)
- Location:
- trunk/ippTools/src
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/src/camtool.c
r19301 r19423 105 105 psMetadata *where = psMetadataAlloc(); 106 106 pxcamGetSearchArgs (config, where); 107 PXOPT_COPY_STR(config->args, where, "-label", "chipRun.label", "=="); 107 108 108 109 if (!psListLength(where->list) … … 220 221 PXOPT_COPY_S64(config->args, where, "-cam_id", "cam_id", "=="); 221 222 pxcamGetSearchArgs (config, where); 223 PXOPT_COPY_STR(config->args, where, "-label", "camRun.label", "=="); 222 224 223 225 if (!psListLength(where->list) … … 266 268 PXOPT_COPY_S64(config->args, where, "-cam_id", "cam_id", "=="); 267 269 pxcamGetSearchArgs (config, where); 270 PXOPT_COPY_STR(config->args, where, "-label", "label", "=="); 268 271 269 272 PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false); … … 331 334 PXOPT_COPY_STR(config->args, where, "-class_id", "class_id", "=="); 332 335 pxcamGetSearchArgs (config, where); 336 PXOPT_COPY_STR(config->args, where, "-label", "camRun.label", "=="); 333 337 334 338 PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false); … … 427 431 if (psListLength(where->list)) { 428 432 psString whereClaus = psDBGenerateWhereSQL(where, NULL); 429 psStringAppend(&query, "%s", whereClaus);430 psFree(whereClaus);433 psStringAppend(&query, "%s", whereClaus); 434 psFree(whereClaus); 431 435 } 432 436 psFree(where); … … 564 568 PXOPT_COPY_S64(config->args, where, "-cam_id", "cam_id", "=="); 565 569 pxcamGetSearchArgs (config, where); 570 PXOPT_COPY_STR(config->args, where, "-label", "camRun.label", "=="); 566 571 567 572 psString query = pxDataGet("camtool_find_processedexp.sql"); … … 632 637 PXOPT_COPY_S64(config->args, where, "-cam_id", "cam_id", "=="); 633 638 pxcamGetSearchArgs (config, where); 639 PXOPT_COPY_STR(config->args, where, "-label", "camRun.label", "=="); 634 640 635 641 if (!psListLength(where->list) && !psMetadataLookupBool(NULL, config->args, "-all")) { … … 646 652 647 653 { 648 psString query = pxDataGet("camtool_reset_faulted_runs.sql");649 if (!query) {650 psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");651 psFree(where);652 return false;653 }654 655 // use psDBGenerateWhereConditionalSQL with AND ... because the SQL ends in a WHERE656 if (where && psListLength(where->list)) {657 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL);658 psStringAppend(&query, " AND %s", whereClause);659 psFree(whereClause);660 }661 662 if (!p_psDBRunQuery(config->dbh, query)) {663 // rollback664 if (!psDBRollback(config->dbh)) {665 psError(PS_ERR_UNKNOWN, false, "database error");666 }667 psError(PS_ERR_UNKNOWN, false, "database error");668 psFree(query);669 psFree(where);670 return false;671 }672 psFree(query);654 psString query = pxDataGet("camtool_reset_faulted_runs.sql"); 655 if (!query) { 656 psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement"); 657 psFree(where); 658 return false; 659 } 660 661 // use psDBGenerateWhereConditionalSQL with AND ... because the SQL ends in a WHERE 662 if (where && psListLength(where->list)) { 663 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL); 664 psStringAppend(&query, " AND %s", whereClause); 665 psFree(whereClause); 666 } 667 668 if (!p_psDBRunQuery(config->dbh, query)) { 669 // rollback 670 if (!psDBRollback(config->dbh)) { 671 psError(PS_ERR_UNKNOWN, false, "database error"); 672 } 673 psError(PS_ERR_UNKNOWN, false, "database error"); 674 psFree(query); 675 psFree(where); 676 return false; 677 } 678 psFree(query); 673 679 } 674 680 675 681 { 676 psString query = pxDataGet("camtool_revertprocessedexp.sql");677 if (!query) {678 // rollback679 if (!psDBRollback(config->dbh)) {680 psError(PS_ERR_UNKNOWN, false, "database error");681 }682 psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");683 psFree(where);684 return false;685 }686 687 // use psDBGenerateWhereConditionalSQL with AND ... because the SQL ends in a WHERE688 if (where && psListLength(where->list)) {689 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL);690 psStringAppend(&query, " AND %s", whereClause);691 psFree(whereClause);692 }693 694 if (!p_psDBRunQuery(config->dbh, query)) {695 // rollback696 if (!psDBRollback(config->dbh)) {697 psError(PS_ERR_UNKNOWN, false, "database error");698 }699 psError(PS_ERR_UNKNOWN, false, "database error");700 psFree(query);701 psFree(where);702 return false;703 }704 psFree(query);682 psString query = pxDataGet("camtool_revertprocessedexp.sql"); 683 if (!query) { 684 // rollback 685 if (!psDBRollback(config->dbh)) { 686 psError(PS_ERR_UNKNOWN, false, "database error"); 687 } 688 psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement"); 689 psFree(where); 690 return false; 691 } 692 693 // use psDBGenerateWhereConditionalSQL with AND ... because the SQL ends in a WHERE 694 if (where && psListLength(where->list)) { 695 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL); 696 psStringAppend(&query, " AND %s", whereClause); 697 psFree(whereClause); 698 } 699 700 if (!p_psDBRunQuery(config->dbh, query)) { 701 // rollback 702 if (!psDBRollback(config->dbh)) { 703 psError(PS_ERR_UNKNOWN, false, "database error"); 704 } 705 psError(PS_ERR_UNKNOWN, false, "database error"); 706 psFree(query); 707 psFree(where); 708 return false; 709 } 710 psFree(query); 705 711 } 706 712 psFree(where); … … 729 735 if (!pxSetFaultCode(config->dbh, "camProcessedExp", where, code)) { 730 736 psError(PS_ERR_UNKNOWN, false, "failed to set set fault flag"); 731 psFree (where);737 psFree (where); 732 738 return false; 733 739 } -
trunk/ippTools/src/camtoolConfig.c
r19292 r19423 52 52 psMetadata *definebyqueryArgs = psMetadataAlloc(); 53 53 pxcamSetSearchArgs(definebyqueryArgs); 54 55 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_workdir", 0, "define workdir", NULL); 56 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_label", 0, "define label", NULL); 54 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-label", 0, "search for label", NULL); 55 56 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_workdir", 0, "define workdir", NULL); 57 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_label", 0, "define label", NULL); 57 58 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_reduction", 0, "define reduction class", NULL); 58 59 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_expgroup", 0, "define exposure group", NULL); 59 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_dvodb", 0, "define DVO db", NULL);60 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_tess_id", 0, "define tess ID", NULL);60 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_dvodb", 0, "define DVO db", NULL); 61 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_tess_id", 0, "define tess ID", NULL); 61 62 psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_end_stage", 0, "define end stage", NULL); 62 psMetadataAddBool(definebyqueryArgs, PS_LIST_TAIL, "-all", 0, "allow everything to be queued without search terms", false);63 psMetadataAddBool(definebyqueryArgs, PS_LIST_TAIL, "-all", 0, "allow everything to be queued without search terms", false); 63 64 64 65 // -updaterun … … 69 70 psMetadataAddS64(updaterunArgs, PS_LIST_TAIL, "-cam_id", 0, "search by cam_id", 0); 70 71 pxcamSetSearchArgs(updaterunArgs); 72 psMetadataAddStr(updaterunArgs, PS_LIST_TAIL, "-label", 0, "search for label", NULL); 71 73 72 74 psMetadataAddBool(updaterunArgs, PS_LIST_TAIL, "-all", 0, "allow everything to be queued without search terms", false); … … 79 81 psMetadataAddS64(pendingexpArgs, PS_LIST_TAIL, "-cam_id", 0, "search by camtool ID", 0); 80 82 pxcamSetSearchArgs(pendingexpArgs); 83 psMetadataAddStr(pendingexpArgs, PS_LIST_TAIL, "-label", 0, "search for label", NULL); 81 84 psMetadataAddU64(pendingexpArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); 82 85 psMetadataAddBool(pendingexpArgs, PS_LIST_TAIL, "-simple", 0, "use the simple output format", false); … … 86 89 psMetadataAddS64(pendingimfileArgs, PS_LIST_TAIL, "-cam_id", 0, "search by camtool ID", 0); 87 90 pxcamSetSearchArgs(pendingimfileArgs); 91 psMetadataAddStr(pendingimfileArgs, PS_LIST_TAIL, "-label", 0, "search for label", NULL); 88 92 psMetadataAddStr(pendingimfileArgs, PS_LIST_TAIL, "-class", 0, "search by class", NULL); 89 93 psMetadataAddStr(pendingimfileArgs, PS_LIST_TAIL, "-class_id", 0, "search by class ID", NULL); … … 126 130 psMetadataAddS64(processedexpArgs, PS_LIST_TAIL, "-cam_id", 0, "search by camtool ID", 0); 127 131 pxcamSetSearchArgs(processedexpArgs); 132 psMetadataAddStr(processedexpArgs, PS_LIST_TAIL, "-label", 0, "search for label", NULL); 128 133 129 134 psMetadataAddU64(processedexpArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); … … 138 143 psMetadataAddS64(revertprocessedexpArgs, PS_LIST_TAIL, "-cam_id", 0, "search by cam_id", 0); 139 144 pxcamSetSearchArgs(revertprocessedexpArgs); 145 psMetadataAddStr(revertprocessedexpArgs, PS_LIST_TAIL, "-label", 0, "search for label", NULL); 140 146 141 147 psMetadataAddBool(revertprocessedexpArgs, PS_LIST_TAIL, "-all", 0, "allow everything to be queued without search terms", false); … … 188 194 psMetadata *modes = psMetadataAlloc(); 189 195 190 PXOPT_ADD_MODE("-definebyquery", "create runs from chip stage", CAMTOOL_MODE_DEFINEBYQUERY, definebyqueryArgs);191 PXOPT_ADD_MODE("-updaterun", "change cam run properties", CAMTOOL_MODE_UPDATERUN, updaterunArgs);192 PXOPT_ADD_MODE("-pendingexp", "show pending exposures", CAMTOOL_MODE_PENDINGEXP, pendingexpArgs);193 PXOPT_ADD_MODE("-pendingimfile", "show pending imfiles", CAMTOOL_MODE_PENDINGIMFILE, pendingimfileArgs);194 PXOPT_ADD_MODE("-addprocessedexp", "add a processed exposure", CAMTOOL_MODE_ADDPROCESSEDEXP, addprocessedexpArgs);195 PXOPT_ADD_MODE("-processedexp", "show processed exposures", CAMTOOL_MODE_PROCESSEDEXP, processedexpArgs);196 PXOPT_ADD_MODE("-revertprocessedexp", "change procesed exp properties", CAMTOOL_MODE_REVERTPROCESSEDEXP, revertprocessedexpArgs);197 PXOPT_ADD_MODE("-updateprocessedexp", "undo a processed exposure", CAMTOOL_MODE_UPDATEPROCESSEDEXP,updateprocessedexpArgs);198 PXOPT_ADD_MODE("-block", "set a label block", CAMTOOL_MODE_BLOCK, blockArgs);199 PXOPT_ADD_MODE("-masked", "show blocked labels", CAMTOOL_MODE_MASKED, maskedArgs);200 PXOPT_ADD_MODE("-unblock", "remove a label block", CAMTOOL_MODE_UNBLOCK, unblockArgs);196 PXOPT_ADD_MODE("-definebyquery", "create runs from chip stage", CAMTOOL_MODE_DEFINEBYQUERY, definebyqueryArgs); 197 PXOPT_ADD_MODE("-updaterun", "change cam run properties", CAMTOOL_MODE_UPDATERUN, updaterunArgs); 198 PXOPT_ADD_MODE("-pendingexp", "show pending exposures", CAMTOOL_MODE_PENDINGEXP, pendingexpArgs); 199 PXOPT_ADD_MODE("-pendingimfile", "show pending imfiles", CAMTOOL_MODE_PENDINGIMFILE, pendingimfileArgs); 200 PXOPT_ADD_MODE("-addprocessedexp", "add a processed exposure", CAMTOOL_MODE_ADDPROCESSEDEXP, addprocessedexpArgs); 201 PXOPT_ADD_MODE("-processedexp", "show processed exposures", CAMTOOL_MODE_PROCESSEDEXP, processedexpArgs); 202 PXOPT_ADD_MODE("-revertprocessedexp", "change procesed exp properties", CAMTOOL_MODE_REVERTPROCESSEDEXP, revertprocessedexpArgs); 203 PXOPT_ADD_MODE("-updateprocessedexp", "undo a processed exposure", CAMTOOL_MODE_UPDATEPROCESSEDEXP,updateprocessedexpArgs); 204 PXOPT_ADD_MODE("-block", "set a label block", CAMTOOL_MODE_BLOCK, blockArgs); 205 PXOPT_ADD_MODE("-masked", "show blocked labels", CAMTOOL_MODE_MASKED, maskedArgs); 206 PXOPT_ADD_MODE("-unblock", "remove a label block", CAMTOOL_MODE_UNBLOCK, unblockArgs); 201 207 PXOPT_ADD_MODE("-pendingcleanuprun", "show runs that need to be cleaned up", CAMTOOL_MODE_PENDINGCLEANUPRUN, pendingcleanuprunArgs); 202 208 PXOPT_ADD_MODE("-pendingcleanupexp", "show exposures for cleanup runs", CAMTOOL_MODE_PENDINGCLEANUPEXP, pendingcleanupexpArgs); -
trunk/ippTools/src/pxcam.c
r19292 r19423 40 40 psMetadataAddStr(md, PS_LIST_TAIL, "-exp_tag", 0, "search by exp_tag", NULL); 41 41 psMetadataAddStr(md, PS_LIST_TAIL, "-exp_type", 0, "search by exp_type", NULL); 42 psMetadataAddStr(md, PS_LIST_TAIL, "-label", 0, "search by label", NULL);43 42 psMetadataAddStr(md, PS_LIST_TAIL, "-comment", 0, "search by comment", NULL); 44 43 psMetadataAddStr(md, PS_LIST_TAIL, "-filelevel", 0, "search by filelevel", NULL); … … 72 71 psMetadataAddF32(md, PS_LIST_TAIL, "-solang_min", 0, "define min solar angle", NAN); 73 72 psMetadataAddF32(md, PS_LIST_TAIL, "-solang_max", 0, "define max solar angle", NAN); 74 73 75 74 return true; 76 75 } … … 87 86 PXOPT_COPY_STR(config->args, where, "-exp_tag", "exp_tag", "=="); 88 87 PXOPT_COPY_STR(config->args, where, "-exp_type", "exp_type", "=="); 89 PXOPT_COPY_STR(config->args, where, "-label", "camRun.label", "==");90 88 PXOPT_COPY_STR(config->args, where, "-comment", "rawExp.comment", "LIKE"); 91 89 PXOPT_COPY_STR(config->args, where, "-filelevel", "filelevel", "==");
Note:
See TracChangeset
for help on using the changeset viewer.
