Changeset 886 for branches/prototype-v0/zoo-project/zoo-kernel/meta_sql.c
- Timestamp:
- Oct 11, 2018, 4:30:46 PM (6 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/prototype-v0/zoo-project/zoo-kernel/meta_sql.c
r854 r886 42 42 #endif 43 43 #define META_SERVICES_LIST_ALL \ 44 "select id,identifier,title,abstract,service_type,service_provider "\44 "select id,identifier,title,abstract,service_type,service_provider,conf_id"\ 45 45 " from ows_process" 46 #define META_SERVICES_LIST_ALL_LENGTH 8346 #define META_SERVICES_LIST_ALL_LENGTH strlen(META_SERVICES_LIST_ALL) 47 47 48 48 #define META_SERVICES_KEYWORDS_FROM_PROCESS \ … … 50 50 " (SELECT keywords_id FROM CollectionDB.DescriptionsKeywordsAssignment"\ 51 51 " where descriptions_id=%s) " 52 #define META_SERVICES_KEYWORDS_FROM_PROCESS_LENGTH 16252 #define META_SERVICES_KEYWORDS_FROM_PROCESS_LENGTH strlen(META_SERVICES_KEYWORDS_FROM_PROCESS) 53 53 54 54 #define META_SERVICES_META_FROM_ANYTHING \ … … 56 56 " (SELECT metadata_id FROM CollectionDB.DescriptionsMetadataAssignment"\ 57 57 " where descriptions_id=%s) " 58 #define META_SERVICES_META_FROM_ANYTHING_LENGTH 16258 #define META_SERVICES_META_FROM_ANYTHING_LENGTH strlen(META_SERVICES_META_FROM_ANYTHING) 59 59 60 60 #define META_SERVICES_AP_FROM_ANYTHING \ … … 62 62 " (SELECT additional_parameters_id FROM CollectionDB.DescriptionsAdditionalParametersAssignment"\ 63 63 " where descriptions_id=%s) " 64 #define META_SERVICES_AP_FROM_ANYTHING_LENGTH 19964 #define META_SERVICES_AP_FROM_ANYTHING_LENGTH strlen(META_SERVICES_AP_FROM_ANYTHING) 65 65 66 66 #define META_SERVICES_AP_FROM_AP \ 67 67 "SELECT key,value FROM CollectionDB.ows_AdditionalParameter where additional_parameters_id =$q$%s$q$" 68 #define META_SERVICES_AP_FROM_AP_LENGTH 10068 #define META_SERVICES_AP_FROM_AP_LENGTH strlen(META_SERVICES_AP_FROM_AP) 69 69 70 70 #define META_SERVICES_LIST_INPUTS_FROM_PROCESS \ 71 71 "select id, identifier,title,abstract,min_occurs,max_occurs from CollectionDB.ows_Input where id in (SELECT input_id from CollectionDB.ProcessInputAssignment where process_id=%s) order by id" 72 #define META_SERVICES_LIST_INPUTS_FROM_PROCESS_LENGTH 19072 #define META_SERVICES_LIST_INPUTS_FROM_PROCESS_LENGTH strlen(META_SERVICES_LIST_INPUTS_FROM_PROCESS) 73 73 74 74 #define META_SERVICES_LIST_INPUTS_FROM_INPUT \ 75 75 "select id, identifier,title,abstract,min_occurs,max_occurs from CollectionDB.ows_Input where id in (SELECT child_input from CollectionDB.InputInputAssignment where parent_input=%s) order by id" 76 #define META_SERVICES_LIST_INPUTS_FROM_INPUT_LENGTH 19376 #define META_SERVICES_LIST_INPUTS_FROM_INPUT_LENGTH strlen(META_SERVICES_LIST_INPUTS_FROM_INPUT) 77 77 78 78 #define META_SERVICES_LIST_OUTPUTS_FROM_PROCESS \ 79 79 "select id, identifier,title,abstract from CollectionDB.ows_Output where id in (SELECT output_id from CollectionDB.ProcessOutputAssignment where process_id=%s) order by id" 80 #define META_SERVICES_LIST_OUTPUTS_FROM_PROCESS_LENGTH 17180 #define META_SERVICES_LIST_OUTPUTS_FROM_PROCESS_LENGTH strlen(META_SERVICES_LIST_OUTPUTS_FROM_PROCESS) 81 81 82 82 #define META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT \ 83 83 "select id, identifier,title,abstract from CollectionDB.ows_Output where id in (SELECT child_output from CollectionDB.OutputOutputAssignment where parent_output=%s) order by id" 84 #define META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT_LENGTH 17684 #define META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT_LENGTH strlen(META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT) 85 85 86 86 #define META_SERVICES_LIST_LITERAL_FROM_IO \ 87 87 "select (SELECT name as type FROM CollectionDB.PrimitiveDatatypes where CollectionDB.PrimitiveDatatypes.id=data_type_id),default_value,(SELECT uom from CollectionDB.PrimitiveUOM where id=CollectionDB.LiteralDataDomain.uom),translate(translate(ARRAY((SELECT allowed_Value from CollectionDB.AllowedValues where id in (SELECT allowed_value_id from CollectionDB.AllowedValuesAssignment where literal_data_domain_id=CollectionDB.LiteralDataDomain.id)))::varchar,'{',''),'}',''),def as allowedvalues from CollectionDB.LiteralDataDomain where id in (SELECT data_description_id from CollectionDB.%sDataDescriptionAssignment where %s_id = %s);" 88 #define META_SERVICES_LIST_LITERAL_FROM_IO_LENGTH 63488 #define META_SERVICES_LIST_LITERAL_FROM_IO_LENGTH strlen(META_SERVICES_LIST_LITERAL_FROM_IO) 89 89 90 90 #define META_SERVICES_LIST_FORMATS_FROM_IO \ 91 91 "select mime_type,encoding,schema,maximum_megabytes,CASE WHEN use_mapserver THEN 'true' ELSE 'false' END, ms_styles, def from CollectionDB.ows_Format,CollectionDB.PrimitiveFormats where CollectionDB.ows_Format.primitive_format_id=CollectionDB.PrimitiveFormats.id and CollectionDB.ows_Format.id in (SELECT format_id from collectiondb.ows_datadescription where id in ( SELECT data_description_id from CollectionDB.%sDataDescriptionAssignment where %s_id = %s))" 92 #define META_SERVICES_LIST_FORMATS_FROM_IO_LENGTH 45892 #define META_SERVICES_LIST_FORMATS_FROM_IO_LENGTH strlen(META_SERVICES_LIST_FORMATS_FROM_IO) 93 93 94 94 /** … … 387 387 addToMap(s->content,"serviceType",poFeature->GetFieldAsString( 4 )); 388 388 addToMap(s->content,"serviceProvider",poFeature->GetFieldAsString( 5 )); 389 addToMap(s->content,"confId",poFeature->GetFieldAsString( 6 )); 389 390 addToMap(s->content,"fromDb","true"); 390 391 s->metadata=NULL;
Note: See TracChangeset
for help on using the changeset viewer.