[prev in list] [next in list] [prev in thread] [next in thread]
List: mapbender-commits
Subject: [Mapbender-commits] r9657 - trunk/mapbender/resources/db/pgsql/UTF-8/update
From: svn_mapbender () osgeo ! org
Date: 2017-01-17 10:52:43
Message-ID: 20170117105243.09FB6390102 () trac ! osgeo ! org
[Download RAW message or body]
Author: armin11
Date: 2017-01-17 02:52:42 -0800 (Tue, 17 Jan 2017)
New Revision: 9657
Modified:
trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
New enhancement to add possibility to hide (dataset)metadata in the mapbender \
catalogue
Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql 2017-01-17 \
10:51:47 UTC (rev 9656)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql 2017-01-17 \
10:52:42 UTC (rev 9657) @@ -1293,12 +1293,12 @@
-- Loesche die abhängigen Sichten, um anschließend die Tabelle wfs_featuretype \
anpassen zu können
-DROP VIEW IF EXISTS mapbender.search_wfs_view;
-DROP VIEW IF EXISTS mapbender.wfs_service_metadata_new;
-DROP VIEW IF EXISTS mapbender.wfs_service_metadata;
+DROP VIEW mapbender.search_wfs_view;
+DROP VIEW mapbender.wfs_service_metadata_new;
+DROP VIEW mapbender.wfs_service_metadata;
--- Änderung Tabellenspalte auf varchar(200)
-alter table wfs_featuretype alter column featuretype_title TYPE varchar(200);
+-- Änderung Tabellenspalte auf varchar(100)
+alter table wfs_featuretype alter column featuretype_title TYPE varchar(100);
-- Erneutes anlegen der 3 zuvor gelöschten Sichten \
search_wfs_view,wfs_service_metadata_new,wfs_service_metadata @@ -1531,7 +1531,44 \
@@ ALTER TABLE mb_group ADD COLUMN mb_group_ckan_uuid uuid;
ALTER TABLE mb_group ADD COLUMN mb_group_ckan_api_key uuid;
-ALTER TABLE mb_metadata ADD COLUMN inspire_interoperability BOOLEAN DEFAULT false;
+ALTER TABLE mb_metadata ADD COLUMN inspire_interoperablity BOOLEAN DEFAULT false;
+ALTER TABLE mb_metadata ADD COLUMN searchable BOOLEAN DEFAULT true;
---enable visual feedback for clickable at datatables
-UPDATE gui_element SET e_content='<table style=''cursor:pointer'' \
class=''display''></table>' where e_content='<table class=''display''></table>'; \
+--Alter view to react on searchable = true field +-- View: search_dataset_view
+
+-- DROP VIEW search_dataset_view;
+
+CREATE OR REPLACE VIEW search_dataset_view AS
+ SELECT DISTINCT ON (datasets.metadata_id) datasets.user_id, datasets.dataset_id, \
datasets.metadata_id, datasets.dataset_srs, datasets.title, \
datasets.dataset_abstract, datasets.accessconstraints, datasets.isopen, \
datasets.termsofuse, datasets.searchtext, datasets.dataset_timestamp, \
datasets.department, datasets.mb_group_name, datasets.mb_group_title, \
datasets.mb_group_country, datasets.load_count, datasets.mb_group_stateorprovince, \
datasets.md_inspire_cats, datasets.md_custom_cats, datasets.md_topic_cats, \
datasets.the_geom, datasets.bbox, datasets.preview_url, datasets.fileidentifier, \
datasets.coupled_resources, datasets.mb_group_logo_path, datasets.timebegin, \
datasets.timeend + FROM ( SELECT dataset_dep.fkey_mb_user_id AS user_id, \
dataset_dep.dataset_id, dataset_dep.dataset_id AS metadata_id, dataset_dep.srs AS \
dataset_srs, dataset_dep.title, dataset_dep.abstract AS dataset_abstract, \
dataset_dep.accessconstraints, dataset_dep.isopen, dataset_dep.termsofuse, \
f_collect_searchtext_dataset(dataset_dep.dataset_id) AS searchtext, \
dataset_dep.dataset_timestamp, dataset_dep.department, dataset_dep.mb_group_name, \
dataset_dep.mb_group_title, dataset_dep.mb_group_country, + CASE
+ WHEN dataset_dep.load_count IS NULL THEN 0::bigint
+ ELSE dataset_dep.load_count
+ END AS load_count, dataset_dep.mb_group_stateorprovince, \
f_collect_inspire_cat_dataset(dataset_dep.dataset_id) AS md_inspire_cats, \
f_collect_custom_cat_dataset(dataset_dep.dataset_id) AS md_custom_cats, \
f_collect_topic_cat_dataset(dataset_dep.dataset_id) AS md_topic_cats, \
dataset_dep.bbox AS the_geom, (((((st_xmin(dataset_dep.bbox::box3d)::text || \
','::text) || st_ymin(dataset_dep.bbox::box3d)::text) || ','::text) || \
st_xmax(dataset_dep.bbox::box3d)::text) || ','::text) || \
st_ymax(dataset_dep.bbox::box3d)::text AS bbox, dataset_dep.preview_url, \
dataset_dep.fileidentifier, f_get_coupled_resources(dataset_dep.dataset_id) AS \
coupled_resources, dataset_dep.mb_group_logo_path, dataset_dep.timebegin::date AS \
timebegin, + CASE
+ WHEN dataset_dep.update_frequency::text = 'continual'::text THEN \
now()::date + WHEN dataset_dep.update_frequency::text = \
'daily'::text THEN now()::date + WHEN \
dataset_dep.update_frequency::text = 'weekly'::text THEN (now() - '7 \
days'::interval)::date + WHEN dataset_dep.update_frequency::text = \
'fortnightly'::text THEN (now() - '14 days'::interval)::date + \
WHEN dataset_dep.update_frequency::text = 'monthly'::text THEN (now() - '1 \
mon'::interval)::date + WHEN dataset_dep.update_frequency::text = \
'quarterly'::text THEN (now() - '3 mons'::interval)::date + WHEN \
dataset_dep.update_frequency::text = 'biannually'::text THEN (now() - '6 \
mons'::interval)::date + WHEN dataset_dep.update_frequency::text = \
'annually'::text THEN (now() - '1 year'::interval)::date + ELSE \
dataset_dep.timeend::date + END AS timeend
+ FROM ( SELECT mb_metadata.the_geom AS bbox, mb_metadata.ref_system AS \
srs, mb_metadata.metadata_id AS dataset_id, mb_metadata.title, mb_metadata.abstract, \
mb_metadata.lastchanged AS dataset_timestamp, mb_metadata.tmp_reference_1 AS \
timebegin, mb_metadata.tmp_reference_2 AS timeend, mb_metadata.uuid AS \
fileidentifier, mb_metadata.preview_image AS preview_url, mb_metadata.load_count, \
mb_metadata.fkey_mb_user_id, mb_metadata.constraints AS accessconstraints, \
mb_metadata.update_frequency, f_getmd_tou(mb_metadata.metadata_id) AS termsofuse, \
f_tou_isopen(f_getmd_tou(mb_metadata.metadata_id)) AS isopen, user_dep.mb_group_id AS \
department, user_dep.mb_group_name, user_dep.mb_group_title, \
user_dep.mb_group_country, user_dep.mb_group_stateorprovince, \
user_dep.mb_group_logo_path + FROM ( SELECT \
registrating_groups.fkey_mb_user_id AS mb_user_id, mb_group.mb_group_id, \
mb_group.mb_group_name, mb_group.mb_group_title, mb_group.mb_group_country, \
mb_group.mb_group_stateorprovince, mb_group.mb_group_logo_path + \
FROM registrating_groups, mb_group + WHERE \
registrating_groups.fkey_mb_group_id = mb_group.mb_group_id) user_dep, ( SELECT \
mb_metadata.metadata_id, mb_metadata.uuid, mb_metadata.origin, \
mb_metadata.includeincaps, mb_metadata.schema, mb_metadata.createdate, \
mb_metadata.changedate, mb_metadata.lastchanged, mb_metadata.data, mb_metadata.link, \
mb_metadata.linktype, mb_metadata.md_format, mb_metadata.title, mb_metadata.abstract, \
mb_metadata.searchtext, mb_metadata.status, mb_metadata.type, \
mb_metadata.harvestresult, mb_metadata.harvestexception, mb_metadata.export2csw, \
mb_metadata.tmp_reference_1, mb_metadata.tmp_reference_2, \
mb_metadata.spatial_res_type, mb_metadata.spatial_res_value, mb_metadata.ref_system, \
mb_metadata.format, mb_metadata.inspire_charset, mb_metadata.inspire_top_consistence, \
mb_metadata.fkey_mb_user_id, mb_metadata.responsible_party, \
mb_metadata.individual_name, mb_metadata.visibility, mb_metadata.locked, \
mb_metadata.copyof, mb_metadata.constraints, mb_metadata.fees, mb_metadata. \
classification, mb_metadata.browse_graphic, mb_metadata.inspire_conformance, \
mb_metadata.preview_image, mb_metadata.the_geom, mb_metadata.lineage, \
mb_metadata.datasetid, mb_metadata.randomid, mb_metadata.update_frequency, \
mb_metadata.datasetid_codespace, mb_metadata.bounding_geom, \
mb_metadata.inspire_whole_area, mb_metadata.inspire_actual_coverage, \
mb_metadata.datalinks, mb_metadata.inspire_download, mb_metadata.transfer_size, \
mb_metadata.md_license_source_note, mb_metadata.responsible_party_name, \
mb_metadata.responsible_party_email, mb_metadata.searchable, \
metadata_load_count.load_count + FROM mb_metadata
+ LEFT JOIN metadata_load_count ON mb_metadata.metadata_id = \
metadata_load_count.fkey_metadata_id) mb_metadata + WHERE \
user_dep.mb_user_id = mb_metadata.fkey_mb_user_id AND mb_metadata.the_geom IS NOT \
NULL AND mb_metadata.searchable IS TRUE) dataset_dep + ORDER BY \
dataset_dep.dataset_id) datasets; +
+ALTER TABLE search_dataset_view
+ OWNER TO postgres;
+
+UPDATE mb_metadata SET searchable = TRUE WHERE searchable IS NULL;
+
+
_______________________________________________
Mapbender_commits mailing list
Mapbender_commits@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapbender_commits
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic