Changeset 14232 for trunk/ippdb/src/ippdb.c
- Timestamp:
- Jul 16, 2007, 12:35:24 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/ippdb/src/ippdb.c (modified) (11 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippdb/src/ippdb.c
r14169 r14232 12874 12874 { 12875 12875 psMetadata *md = psMetadataAlloc(); 12876 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key INDEX(det_id, exp_id) fkey(det_id) ref detRun(det_id)", 0)) {12876 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id) ref detRun(det_id)", 0)) { 12877 12877 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 12878 12878 psFree(md); 12879 12879 return false; 12880 12880 } 12881 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key INDEX(det_id, iteration)", 0)) {12881 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(exp_id) ref rawExp(exp_id)", 0)) { 12882 12882 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 12883 12883 psFree(md); 12884 12884 return false; 12885 12885 } 12886 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key fkey (exp_id) ref rawExp(exp_id)", 64)) {12886 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key INDEX(det_id, exp_id)", 64)) { 12887 12887 psError(PS_ERR_UNKNOWN, false, "failed to add item exp_id"); 12888 12888 psFree(md); 12889 12889 return false; 12890 12890 } 12891 if (!psMetadataAdd(md, PS_LIST_TAIL, "include", PS_DATA_BOOL, NULL, 0)) {12891 if (!psMetadataAdd(md, PS_LIST_TAIL, "include", PS_DATA_BOOL, "INDEX(det_id, iteration)", 0)) { 12892 12892 psError(PS_ERR_UNKNOWN, false, "failed to add item include"); 12893 12893 psFree(md); … … 13228 13228 { 13229 13229 psMetadata *md = psMetadataAlloc(); 13230 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey (det_id, exp_id) ref detInputExp(det_id, exp_id)", 0)) {13230 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, exp_id) ref detInputExp(det_id, exp_id)", 0)) { 13231 13231 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 13232 13232 psFree(md); 13233 13233 return false; 13234 13234 } 13235 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id)", 64)) {13235 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key fkey(exp_id, class_id) ref rawImfile(exp_id, class_id)", 64)) { 13236 13236 psError(PS_ERR_UNKNOWN, false, "failed to add item exp_id"); 13237 13237 psFree(md); … … 13243 13243 return false; 13244 13244 } 13245 if (!psMetadataAdd(md, PS_LIST_TAIL, "uri", PS_DATA_STRING, NULL, "255")) {13245 if (!psMetadataAdd(md, PS_LIST_TAIL, "uri", PS_DATA_STRING, "INDEX(det_id, exp_id)", "255")) { 13246 13246 psError(PS_ERR_UNKNOWN, false, "failed to add item uri"); 13247 13247 psFree(md); … … 13863 13863 return false; 13864 13864 } 13865 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key ", 64)) {13865 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key fkey(det_id, exp_id) ref detProcessedImfile(det_id, exp_id)", 64)) { 13866 13866 psError(PS_ERR_UNKNOWN, false, "failed to add item exp_id"); 13867 13867 psFree(md); … … 14452 14452 return false; 14453 14453 } 14454 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, class_id) ref detProcessedImfile(det_id, class_id)", 0)) {14454 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, class_id) ref detProcessedImfile(det_id, class_id)", 0)) { 14455 14455 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 14456 14456 psFree(md); … … 14985 14985 { 14986 14986 psMetadata *md = psMetadataAlloc(); 14987 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration , class_id) ref detStackedImfile(det_id, iteration, class_id)", 0)) {14987 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration)", 0)) { 14988 14988 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 14989 14989 psFree(md); 14990 14990 return false; 14991 14991 } 14992 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key ", 0)) {14992 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, iteration, class_id) ref detStackedImfile(det_id, iteration, class_id)", 0)) { 14993 14993 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 14994 14994 psFree(md); … … 15354 15354 { 15355 15355 psMetadata *md = psMetadataAlloc(); 15356 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key INDEX(det_id, iteration)fkey(det_id) ref detInputExp(det_id)", 0)) {15356 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id) ref detInputExp(det_id)", 0)) { 15357 15357 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 15358 15358 psFree(md); 15359 15359 return false; 15360 15360 } 15361 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key ", 0)) {15361 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, iteration, class_id) ref detNormalizedStatImfile(det_id, iteration, class_id)", 0)) { 15362 15362 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 15363 15363 psFree(md); 15364 15364 return false; 15365 15365 } 15366 if (!psMetadataAdd(md, PS_LIST_TAIL, "class_id", PS_DATA_STRING, "Primary Key ", "64")) {15366 if (!psMetadataAdd(md, PS_LIST_TAIL, "class_id", PS_DATA_STRING, "Primary Key INDEX(det_id, iteration)", "64")) { 15367 15367 psError(PS_ERR_UNKNOWN, false, "failed to add item class_id"); 15368 15368 psFree(md); … … 15901 15901 { 15902 15902 psMetadata *md = psMetadataAlloc(); 15903 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration) ref det NormalizedImfile(det_id, iteration)", 0)) {15903 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration)", 0)) { 15904 15904 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 15905 15905 psFree(md); 15906 15906 return false; 15907 15907 } 15908 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key ", 0)) {15908 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, iteration) ref detNormalizedImfile(det_id, iteration)", 0)) { 15909 15909 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 15910 15910 psFree(md); … … 16437 16437 { 16438 16438 psMetadata *md = psMetadataAlloc(); 16439 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key ", 0)) {16439 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration, exp_id) ref detInputExp(det_id, iteration, exp_id)", 0)) { 16440 16440 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 16441 16441 psFree(md); 16442 16442 return false; 16443 16443 } 16444 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key ", 0)) {16444 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, exp_id, class_id) ref detProcessedImfile(det_id, exp_id, class_id)", 0)) { 16445 16445 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 16446 16446 psFree(md); 16447 16447 return false; 16448 16448 } 16449 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key ", 64)) {16449 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration) ref detNormalizedExp(det_id, iteration)", 64)) { 16450 16450 psError(PS_ERR_UNKNOWN, false, "failed to add item exp_id"); 16451 16451 psFree(md); 16452 16452 return false; 16453 16453 } 16454 if (!psMetadataAdd(md, PS_LIST_TAIL, "class_id", PS_DATA_STRING, "Primary Key ", "64")) {16454 if (!psMetadataAdd(md, PS_LIST_TAIL, "class_id", PS_DATA_STRING, "Primary Key INDEX(det_id, iteration, exp_id)", "64")) { 16455 16455 psError(PS_ERR_UNKNOWN, false, "failed to add item class_id"); 16456 16456 psFree(md); … … 17110 17110 { 17111 17111 psMetadata *md = psMetadataAlloc(); 17112 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key ", 0)) {17112 if (!psMetadataAdd(md, PS_LIST_TAIL, "det_id", PS_DATA_S64, "Primary Key fkey(det_id, iteration, exp_id) ref detInputExp(det_id, iteration, exp_id)", 0)) { 17113 17113 psError(PS_ERR_UNKNOWN, false, "failed to add item det_id"); 17114 17114 psFree(md); 17115 17115 return false; 17116 17116 } 17117 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key ", 0)) {17117 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, iteration, exp_id) ref detResidImfile(det_id, iteration, exp_id)", 0)) { 17118 17118 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 17119 17119 psFree(md); 17120 17120 return false; 17121 17121 } 17122 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key ", 64)) {17122 if (!psMetadataAdd(md, PS_LIST_TAIL, "exp_id", PS_DATA_S64, "Primary Key INDEX(det_id, iteration)", 64)) { 17123 17123 psError(PS_ERR_UNKNOWN, false, "failed to add item exp_id"); 17124 17124 psFree(md); … … 17754 17754 return false; 17755 17755 } 17756 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key ", 0)) {17756 if (!psMetadataAdd(md, PS_LIST_TAIL, "iteration", PS_DATA_S32, "Primary Key fkey(det_id, iteration) ref detResidExp(det_id, iteration)", 0)) { 17757 17757 psError(PS_ERR_UNKNOWN, false, "failed to add item iteration"); 17758 17758 psFree(md);
Note:
See TracChangeset
for help on using the changeset viewer.
