Ignore:
Timestamp:
Oct 11, 2018, 4:30:46 PM (3 years ago)
Author:
djay
Message:

Check for md5sum of any file in the cache to avoid sending the same file on HPC server twice. Add the multiple LiteralData? inputs support for HPC services. Remove condition for defining SCALE for every band in the outputed MapServer? mapfile.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/prototype-v0/zoo-project/zoo-kernel/meta_sql.c

    r854 r886  
    4242#endif
    4343#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"\
    4545  " from ows_process"
    46 #define META_SERVICES_LIST_ALL_LENGTH 83
     46#define META_SERVICES_LIST_ALL_LENGTH strlen(META_SERVICES_LIST_ALL)
    4747
    4848#define META_SERVICES_KEYWORDS_FROM_PROCESS \
     
    5050  " (SELECT keywords_id FROM CollectionDB.DescriptionsKeywordsAssignment"\
    5151  " where descriptions_id=%s) "
    52 #define META_SERVICES_KEYWORDS_FROM_PROCESS_LENGTH 162
     52#define META_SERVICES_KEYWORDS_FROM_PROCESS_LENGTH strlen(META_SERVICES_KEYWORDS_FROM_PROCESS)
    5353
    5454#define META_SERVICES_META_FROM_ANYTHING \
     
    5656  " (SELECT metadata_id FROM CollectionDB.DescriptionsMetadataAssignment"\
    5757  " where descriptions_id=%s) "
    58 #define META_SERVICES_META_FROM_ANYTHING_LENGTH 162
     58#define META_SERVICES_META_FROM_ANYTHING_LENGTH strlen(META_SERVICES_META_FROM_ANYTHING)
    5959
    6060#define META_SERVICES_AP_FROM_ANYTHING \
     
    6262  " (SELECT additional_parameters_id FROM CollectionDB.DescriptionsAdditionalParametersAssignment"\
    6363  " where descriptions_id=%s) "
    64 #define META_SERVICES_AP_FROM_ANYTHING_LENGTH 199
     64#define META_SERVICES_AP_FROM_ANYTHING_LENGTH strlen(META_SERVICES_AP_FROM_ANYTHING)
    6565
    6666#define META_SERVICES_AP_FROM_AP \
    6767  "SELECT key,value FROM CollectionDB.ows_AdditionalParameter where additional_parameters_id =$q$%s$q$"
    68 #define META_SERVICES_AP_FROM_AP_LENGTH 100
     68#define META_SERVICES_AP_FROM_AP_LENGTH strlen(META_SERVICES_AP_FROM_AP)
    6969
    7070#define META_SERVICES_LIST_INPUTS_FROM_PROCESS                          \
    7171  "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 190
     72#define META_SERVICES_LIST_INPUTS_FROM_PROCESS_LENGTH strlen(META_SERVICES_LIST_INPUTS_FROM_PROCESS)
    7373
    7474#define META_SERVICES_LIST_INPUTS_FROM_INPUT                            \
    7575  "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 193
     76#define META_SERVICES_LIST_INPUTS_FROM_INPUT_LENGTH strlen(META_SERVICES_LIST_INPUTS_FROM_INPUT)
    7777
    7878#define META_SERVICES_LIST_OUTPUTS_FROM_PROCESS \
    7979  "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 171
     80#define META_SERVICES_LIST_OUTPUTS_FROM_PROCESS_LENGTH strlen(META_SERVICES_LIST_OUTPUTS_FROM_PROCESS)
    8181
    8282#define META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT \
    8383  "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 176
     84#define META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT_LENGTH strlen(META_SERVICES_LIST_OUTPUTS_FROM_OUTPUT)
    8585
    8686#define META_SERVICES_LIST_LITERAL_FROM_IO \
    8787  "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 634
     88#define META_SERVICES_LIST_LITERAL_FROM_IO_LENGTH strlen(META_SERVICES_LIST_LITERAL_FROM_IO)
    8989
    9090#define META_SERVICES_LIST_FORMATS_FROM_IO \
    9191  "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 458
     92#define META_SERVICES_LIST_FORMATS_FROM_IO_LENGTH strlen(META_SERVICES_LIST_FORMATS_FROM_IO)
    9393
    9494/**
     
    387387      addToMap(s->content,"serviceType",poFeature->GetFieldAsString( 4 ));
    388388      addToMap(s->content,"serviceProvider",poFeature->GetFieldAsString( 5 ));
     389      addToMap(s->content,"confId",poFeature->GetFieldAsString( 6 ));
    389390      addToMap(s->content,"fromDb","true");
    390391      s->metadata=NULL;
Note: See TracChangeset for help on using the changeset viewer.

Search

Context Navigation

ZOO Sponsors

http://www.zoo-project.org/trac/chrome/site/img/geolabs-logo.pnghttp://www.zoo-project.org/trac/chrome/site/img/neogeo-logo.png http://www.zoo-project.org/trac/chrome/site/img/apptech-logo.png http://www.zoo-project.org/trac/chrome/site/img/3liz-logo.png http://www.zoo-project.org/trac/chrome/site/img/gateway-logo.png

Become a sponsor !

Knowledge partners

http://www.zoo-project.org/trac/chrome/site/img/ocu-logo.png http://www.zoo-project.org/trac/chrome/site/img/gucas-logo.png http://www.zoo-project.org/trac/chrome/site/img/polimi-logo.png http://www.zoo-project.org/trac/chrome/site/img/fem-logo.png http://www.zoo-project.org/trac/chrome/site/img/supsi-logo.png http://www.zoo-project.org/trac/chrome/site/img/cumtb-logo.png

Become a knowledge partner

Related links

http://zoo-project.org/img/ogclogo.png http://zoo-project.org/img/osgeologo.png