Changeset 11985 for trunk/ippTools/src/warptool.c
- Timestamp:
- Feb 21, 2007, 3:59:20 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/ippTools/src/warptool.c (modified) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/src/warptool.c
r11983 r11985 761 761 " JOIN p4SkyCellMap\n" 762 762 " USING(p4_id)\n" 763 " LEFT JOIN p4S cfile\n"763 " LEFT JOIN p4Skyfile\n" 764 764 " USING(p4_id, skycell_id, tess_id)\n" 765 765 " WHERE\n" 766 766 " p4Run.state = 'run'\n" 767 " AND p4S cfile.p4_id IS NULL\n"768 " AND p4S cfile.skycell_id IS NULL\n"769 " AND p4S cfile.tess_id IS NULL\n"767 " AND p4Skyfile.p4_id IS NULL\n" 768 " AND p4Skyfile.skycell_id IS NULL\n" 769 " AND p4Skyfile.tess_id IS NULL\n" 770 770 ); 771 771 … … 893 893 } 894 894 895 // we don't want to insert the last s cfile in a run but then not mark the895 // we don't want to insert the last skyfile in a run but then not mark the 896 896 // run as 'stop' 897 897 if (!psDBTransaction(config->dbh)) { … … 901 901 902 902 // XXX need to validate that this coresponds to an p4InputImfile 903 if (!p4S cfileInsert(config->dbh,903 if (!p4SkyfileInsert(config->dbh, 904 904 (psS32)atoi(p4_id), 905 905 skycell_id, … … 949 949 " p4Run.p4_id,\n" 950 950 " p4SkyCellMap.p4_id as foo,\n" 951 " p4S cfile.p4_id as bar\n"951 " p4Skyfile.p4_id as bar\n" 952 952 " FROM p4Run\n" 953 953 " JOIN p4SkyCellMap\n" 954 954 " USING(p4_id)\n" 955 " LEFT JOIN p4S cfile\n"955 " LEFT JOIN p4Skyfile\n" 956 956 " USING(p4_id, skycell_id, tess_id)\n" 957 957 " WHERE\n" … … 960 960 " p4Run.p4_id\n" 961 961 " HAVING\n" 962 " COUNT(p4SkyCellMap.p4_id) = COUNT(p4S cfile.p4_id)\n"962 " COUNT(p4SkyCellMap.p4_id) = COUNT(p4Skyfile.p4_id)\n" 963 963 " ) as Foo\n" 964 964 " )\n" … … 990 990 psString query = psStringCopy( 991 991 "SELECT\n" 992 " p4S cfile.*\n"992 " p4Skyfile.*\n" 993 993 " FROM p4Run\n" 994 " JOIN p4S cfile\n"994 " JOIN p4Skyfile\n" 995 995 " USING(p4_id)\n" 996 996 " WHERE\n" … … 999 999 1000 1000 if (config->where) { 1001 psString whereClause = psDBGenerateWhereConditionSQL(config->where, "p4S cfile");1001 psString whereClause = psDBGenerateWhereConditionSQL(config->where, "p4Skyfile"); 1002 1002 psStringAppend(&query, " AND %s", whereClause); 1003 1003 psFree(whereClause); … … 1033 1033 } 1034 1034 if (!psArrayLength(output)) { 1035 psError(PS_ERR_UNKNOWN, false, "no p4S cfile rows found");1035 psError(PS_ERR_UNKNOWN, false, "no p4Skyfile rows found"); 1036 1036 psFree(output); 1037 1037 return true; … … 1050 1050 if (psArrayLength(output)) { 1051 1051 // negative simple so the default is true 1052 if (!ippdbPrintMetadatas(stdout, output, "p4S cfile", !simple)) {1052 if (!ippdbPrintMetadatas(stdout, output, "p4Skyfile", !simple)) { 1053 1053 psError(PS_ERR_UNKNOWN, false, "failed to print array"); 1054 1054 psFree(output);
Note:
See TracChangeset
for help on using the changeset viewer.
