Changeset 28941
- Timestamp:
- Aug 17, 2010, 11:12:06 AM (16 years ago)
- Location:
- trunk/ippTools
- Files:
-
- 2 added
- 4 edited
-
share/Makefile.am (modified) (1 diff)
-
share/bgtool_listchip.sql (added)
-
share/bgtool_listwarp.sql (added)
-
src/bgtool.c (modified) (6 diffs)
-
src/bgtool.h (modified) (2 diffs)
-
src/bgtoolConfig.c (modified) (4 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/share/Makefile.am
r28934 r28941 27 27 bgtool_definechip.sql \ 28 28 bgtool_definewarp.sql \ 29 bgtool_listchip.sql \ 30 bgtool_listwarp.sql \ 29 31 bgtool_revertchip.sql \ 30 32 bgtool_revertwarp.sql \ -
trunk/ippTools/src/bgtool.c
r28746 r28941 39 39 static bool advancechipMode(pxConfig *config); 40 40 static bool revertchipMode(pxConfig *config); 41 static bool listchipMode(pxConfig *config); 41 42 static bool definewarpMode(pxConfig *config); 42 43 static bool updatewarpMode(pxConfig *config); … … 47 48 static bool advancewarpMode(pxConfig *config); 48 49 static bool revertwarpMode(pxConfig *config); 50 static bool listwarpMode(pxConfig *config); 49 51 static bool tocleanchipMode(pxConfig *config); 50 52 static bool cleanedchipMode(pxConfig *config); … … 100 102 MODECASE(BGTOOL_MODE_ADVANCECHIP, advancechipMode); 101 103 MODECASE(BGTOOL_MODE_REVERTCHIP, revertchipMode); 104 MODECASE(BGTOOL_MODE_LISTCHIP, listchipMode); 102 105 MODECASE(BGTOOL_MODE_DEFINEWARP, definewarpMode); 103 106 MODECASE(BGTOOL_MODE_UPDATEWARP, updatewarpMode); … … 108 111 MODECASE(BGTOOL_MODE_ADVANCEWARP, advancewarpMode); 109 112 MODECASE(BGTOOL_MODE_REVERTWARP, revertwarpMode); 113 MODECASE(BGTOOL_MODE_LISTWARP, listwarpMode); 110 114 MODECASE(BGTOOL_MODE_TOCLEANCHIP, tocleanchipMode); 111 115 MODECASE(BGTOOL_MODE_CLEANEDCHIP, cleanedchipMode); … … 907 911 int numDeleted = psDBAffectedRows(config->dbh); 908 912 psLogMsg("bgtool", PS_LOG_INFO, "Deleted %d chipBackgroundImfiles", numDeleted); 913 914 return true; 915 } 916 static bool listchipMode(pxConfig *config) 917 { 918 PS_ASSERT_PTR_NON_NULL(config, false); 919 920 psMetadata *where = psMetadataAlloc(); 921 PXOPT_COPY_S64(config->args, where, "-chip_bg_id", "chipBackgroundRun.chip_bg_id", "=="); 922 PXOPT_COPY_STR(config->args, where, "-class_id", "chipProcessedImfile.class_id", "=="); 923 924 // chip_bg_id is required 925 PXOPT_LOOKUP_S64(chip_bg_id, config->args, "-chip_bg_id", true, false); 926 927 PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false); 928 PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false); 929 930 psString query = pxDataGet("bgtool_listchip.sql"); 931 if (!query) { 932 psError(psErrorCodeLast(), false, "failed to retreive SQL statement"); 933 return false; 934 } 935 936 psString whereStr = psStringCopy(""); 937 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL); 938 psStringAppend(&query, "\nWHERE %s", whereClause); 939 psFree(whereClause); 940 psFree(where); 941 942 if (limit) { 943 psString limitString = psDBGenerateLimitSQL(limit); 944 psStringAppend(&query, " %s", limitString); 945 psFree(limitString); 946 } 947 948 if (!p_psDBRunQuery(config->dbh, query)) { 949 psError(psErrorCodeLast(), false, "database error"); 950 psFree(query); 951 return false; 952 } 953 psFree(whereStr); 954 psFree(query); 955 956 psArray *output = p_psDBFetchResult(config->dbh); 957 if (!output) { 958 psError(psErrorCodeLast(), false, "Unable to fetch result of query %s", query); 959 return false; 960 } 961 if (!psArrayLength(output)) { 962 psTrace("bgtool", PS_LOG_INFO, "no rows found"); 963 psFree(output); 964 return true; 965 } 966 967 if (psArrayLength(output)) { 968 if (!ippdbPrintMetadatas(stdout, output, "chipProcessedImfile", !simple)) { 969 psError(psErrorCodeLast(), false, "failed to print array"); 970 psFree(output); 971 return false; 972 } 973 } 974 975 psFree(output); 909 976 910 977 return true; … … 1686 1753 return true; 1687 1754 } 1755 static bool listwarpMode(pxConfig *config) 1756 { 1757 PS_ASSERT_PTR_NON_NULL(config, false); 1758 1759 psMetadata *where = psMetadataAlloc(); 1760 PXOPT_COPY_S64(config->args, where, "-warp_bg_id", "warpBackgroundRun.warp_bg_id", "=="); 1761 PXOPT_COPY_STR(config->args, where, "-skycell_id", "warpSkyfile.skycell_id", "=="); 1762 1763 PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false); 1764 PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false); 1765 1766 psString query = pxDataGet("bgtool_listwarp.sql"); 1767 if (!query) { 1768 psError(psErrorCodeLast(), false, "failed to retreive SQL statement"); 1769 return false; 1770 } 1771 1772 psString whereStr = psStringCopy(""); 1773 psString whereClause = psDBGenerateWhereConditionSQL(where, NULL); 1774 psStringAppend(&query, "\nWHERE %s", whereClause); 1775 psFree(whereClause); 1776 psFree(where); 1777 1778 if (limit) { 1779 psString limitString = psDBGenerateLimitSQL(limit); 1780 psStringAppend(&query, " %s", limitString); 1781 psFree(limitString); 1782 } 1783 1784 if (!p_psDBRunQuery(config->dbh, query)) { 1785 psError(psErrorCodeLast(), false, "database error"); 1786 psFree(query); 1787 return false; 1788 } 1789 psFree(whereStr); 1790 psFree(query); 1791 1792 psArray *output = p_psDBFetchResult(config->dbh); 1793 if (!output) { 1794 psError(psErrorCodeLast(), false, "Unable to fetch result of query %s", query); 1795 return false; 1796 } 1797 if (!psArrayLength(output)) { 1798 psTrace("bgtool", PS_LOG_INFO, "no rows found"); 1799 psFree(output); 1800 return true; 1801 } 1802 1803 if (psArrayLength(output)) { 1804 if (!ippdbPrintMetadatas(stdout, output, "warpSkyfile", !simple)) { 1805 psError(psErrorCodeLast(), false, "failed to print array"); 1806 psFree(output); 1807 return false; 1808 } 1809 } 1810 1811 psFree(output); 1812 1813 return true; 1814 } 1688 1815 1689 1816 static bool tocleanwarpMode(pxConfig *config) -
trunk/ippTools/src/bgtool.h
r28486 r28941 34 34 BGTOOL_MODE_ADVANCECHIP, 35 35 BGTOOL_MODE_REVERTCHIP, 36 BGTOOL_MODE_LISTCHIP, 36 37 // Warp stage 37 38 BGTOOL_MODE_DEFINEWARP, … … 43 44 BGTOOL_MODE_ADVANCEWARP, 44 45 BGTOOL_MODE_REVERTWARP, 46 BGTOOL_MODE_LISTWARP, 45 47 // Cleanups 46 48 BGTOOL_MODE_TOCLEANCHIP, -
trunk/ippTools/src/bgtoolConfig.c
r28743 r28941 184 184 psMetadataAddS16(revertchipArgs, PS_LIST_TAIL, "-fault", 0, "search by fault code", 0); 185 185 psMetadataAddBool(revertchipArgs, PS_LIST_TAIL, "-all", 0, "allow everything to be queued without search terms", false); 186 187 // -listchip 188 psMetadata *listchipArgs = psMetadataAlloc(); 189 psMetadataAddS64(listchipArgs, PS_LIST_TAIL, "-chip_bg_id", 0, "search by chip_bg_id (required)", 0); 190 psMetadataAddStr(listchipArgs, PS_LIST_TAIL, "-class_id", 0, "search by class_id", NULL); 191 psMetadataAddBool(listchipArgs, PS_LIST_TAIL, "-simple", 0, "use the simple output format", false); 192 psMetadataAddU64(listchipArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); 186 193 187 194 // -tocleanchip … … 347 354 psMetadataAddBool(revertwarpArgs, PS_LIST_TAIL, "-all", 0, "allow everything to be queued without search terms", false); 348 355 356 // -listwarp 357 psMetadata *listwarpArgs = psMetadataAlloc(); 358 psMetadataAddS64(listwarpArgs, PS_LIST_TAIL, "-warp_bg_id", 0, "search by warp_bg_id (required)", 0); 359 psMetadataAddStr(listwarpArgs, PS_LIST_TAIL, "-skycell_id", 0, "search by skycell_id", NULL); 360 psMetadataAddBool(listwarpArgs, PS_LIST_TAIL, "-simple", 0, "use the simple output format", false); 361 psMetadataAddU64(listwarpArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0); 362 349 363 // -tocleanwarp 350 364 psMetadata *tocleanwarpArgs = psMetadataAlloc(); … … 382 396 PXOPT_ADD_MODE("-advancechip", "", BGTOOL_MODE_ADVANCECHIP, advancechipArgs); 383 397 PXOPT_ADD_MODE("-revertchip", "", BGTOOL_MODE_REVERTCHIP, revertchipArgs); 398 PXOPT_ADD_MODE("-listchip", "", BGTOOL_MODE_LISTCHIP, listchipArgs); 384 399 PXOPT_ADD_MODE("-tocleanchip", "", BGTOOL_MODE_TOCLEANCHIP, tocleanchipArgs); 385 400 PXOPT_ADD_MODE("-cleanedchip", "", BGTOOL_MODE_CLEANEDCHIP, cleanedchipArgs); … … 395 410 PXOPT_ADD_MODE("-advancewarp", "", BGTOOL_MODE_ADVANCEWARP, advancewarpArgs); 396 411 PXOPT_ADD_MODE("-revertwarp", "", BGTOOL_MODE_REVERTWARP, revertwarpArgs); 412 PXOPT_ADD_MODE("-listwarp", "", BGTOOL_MODE_LISTWARP, listwarpArgs); 397 413 PXOPT_ADD_MODE("-tocleanwarp", "", BGTOOL_MODE_TOCLEANWARP, tocleanwarpArgs); 398 414 PXOPT_ADD_MODE("-cleanedwarp", "", BGTOOL_MODE_CLEANEDWARP, cleanedwarpArgs);
Note:
See TracChangeset
for help on using the changeset viewer.
