add dashboard related configs to deployment.yaml
@@ -182,3 +182,27 @@ wso2.artifact.deployment:
# Scheduler update interval
updateInterval: 5
+# Dashboard related configurations
+wso2.dashboard:
+ db_queries:
+ h2:
+ add_dashboard: >
+ INSERT INTO DASHBOARD_RESOURCE (DASHBOARD_URL, DASHBOARD_NAME, DASHBOARD_DESCRIPTION, DASHBOARD_PARENT_ID , DASHBOARD_LANDING_PAGE, DASHBOARD_CONTENT)
+ VALUES (?, ?, ?, ?, ?, ?)
+ get_dashboard_by_url: >
+ SELECT
+ DASHBOARD_ID, DASHBOARD_URL, DASHBOARD_NAME, DASHBOARD_DESCRIPTION, DASHBOARD_PARENT_ID, DASHBOARD_LANDING_PAGE, DASHBOARD_CONTENT
+ FROM DASHBOARD_RESOURCE
+ WHERE
+ DASHBOARD_URL = ?
+ get_dashboard_metadata_list: >
+ SELECT
+ DASHBOARD_ID, DASHBOARD_URL, DASHBOARD_NAME, DASHBOARD_DESCRIPTION, DASHBOARD_PARENT_ID, DASHBOARD_LANDING_PAGE
+ FROM DASHBOARD_RESOURCE
+ delete_dashboard_by_url: >
+ DELETE FROM DASHBOARD_RESOURCE
+ WHERE DASHBOARD_URL = ?
+ update_dashboard_content: >
+ MERGE INTO DASHBOARD_RESOURCE (DASHBOARD_NAME, DASHBOARD_DESCRIPTION, DASHBOARD_CONTENT, DASHBOARD_URL, DASHBOARD_PARENT_ID, DASHBOARD_LANDING_PAGE)
+ KEY(DASHBOARD_URL)
+ VALUES( ?, ?, ?, ?, ?, ?)
