[Mapbender-commits] r10063 - trunk/mapbender/resources/db

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-02-22 00:46:59 -0800 (Fri, 22 Feb 2019)
New Revision: 10063

Modified:
   trunk/mapbender/resources/db/install_geoportal_mb28.sh
Log:
New cronjob to materialize search_wmc_view

Modified: trunk/mapbender/resources/db/install_geoportal_mb28.sh
===================================================================
--- trunk/mapbender/resources/db/install_geoportal_mb28.sh	2019-02-22 08:43:42 UTC (rev 10062)
+++ trunk/mapbender/resources/db/install_geoportal_mb28.sh	2019-02-22 08:46:59 UTC (rev 10063)
@@ -1295,6 +1295,7 @@
 ############################################################
 echo "GRANT ALL ON TABLE wms_search_table TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_wms_view.sql
 echo "ALTER TABLE wms_search_table OWNER TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_wms_view.sql
+
 echo "ALTER TABLE wms_list OWNER TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_wms_view.sql
 
 echo "GRANT ALL ON TABLE wfs_search_table TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_wfs_view.sql
@@ -1302,6 +1303,9 @@
 
 echo "GRANT ALL ON TABLE dataset_search_table TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_dataset_view.sql
 echo "ALTER TABLE dataset_search_table OWNER TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_dataset_view.sql
+
+echo "GRANT ALL ON TABLE wmc_search_table TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_wmc_view.sql
+echo "ALTER TABLE wmc_search_table OWNER TO $mapbender_database_user;" >> ${installation_folder}mapbender/resources/db/materialize_wmc_view.sql
 ############################################################
 if [ $configure_cronjobs = 'true' ]; then
 
@@ -1368,7 +1372,12 @@
 cronjob10="2,32 * * * * $croncmd10"
 ( crontab -l | grep -v -F "$croncmd10" ; echo "$cronjob10" ) | crontab -
 ############################################################
-# 11. monitor capabilities (wms/wfs)
+# 11. materialize wmc search view
+croncmd10="su - postgres -c \"psql -q -p $mapbender_database_port -d $mapbender_database_name -f ${installation_folder}mapbender/resources/db/materialize_wmc_view.sql\""
+cronjob10="3,32 * * * * $croncmd10"
+( crontab -l | grep -v -F "$croncmd10" ; echo "$cronjob10" ) | crontab -
+############################################################
+# 12. monitor capabilities (wms/wfs)
 croncmd11="sh ${installation_folder}mapbender/tools/monitorCapabilities.sh"
 cronjob11="7 2,4,6,8,10,12,14,16,18,20,22 * * * $croncmd11"
 ( crontab -l | grep -v -F "$croncmd11" ; echo "$cronjob11" ) | crontab -