From bc2cab1f002649fc3ccf9dc43554506a8b2635eb Mon Sep 17 00:00:00 2001 From: Guobiao Mo Date: Tue, 18 Jun 2019 14:00:26 -0700 Subject: Add a column to table design_type Issue-ID: DCAEGEN2-1625 Change-Id: I9f5421f083957219336fec0478571014d26c819f Signed-off-by: Guobiao Mo --- .../datalake-handler/feeder/src/assembly/scripts/init_db.sql | 11 ++++++----- .../main/java/org/onap/datalake/feeder/domain/DesignType.java | 3 +++ 2 files changed, 9 insertions(+), 5 deletions(-) diff --git a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql index 4fe9ad3f..7c7b2fbf 100644 --- a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql +++ b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql @@ -57,6 +57,7 @@ CREATE TABLE `portal` ( CREATE TABLE `design_type` ( `name` varchar(255) NOT NULL, + `display` varchar(255) NOT NULL, `portal` varchar(255) DEFAULT NULL, `note` text DEFAULT NULL, PRIMARY KEY (`name`), @@ -117,9 +118,9 @@ insert into portal (`name`,`related_db`, host) values ('Kibana', 'Elasticsearch' insert into portal (`name`,`related_db`) values ('Elasticsearch', 'Elasticsearch'); insert into portal (`name`,`related_db`) values ('Druid', 'Druid'); -insert into design_type (`name`,`portal`) values ('Kibana Dashboard', 'Kibana'); -insert into design_type (`name`,`portal`) values ('Kibana Search', 'Kibana'); -insert into design_type (`name`,`portal`) values ('Kibana Visualization', 'Kibana'); -insert into design_type (`name`,`portal`) values ('Elasticsearch Field Mapping Template', 'Elasticsearch'); -insert into design_type (`name`,`portal`) values ('Druid Kafka Indexing Service Supervisor Spec', 'Druid'); +insert into design_type (`name`,`display`,`portal`) values ('kibana_db', 'Kibana Dashboard', 'Kibana'); +insert into design_type (`name`,`display`,`portal`) values ('kibana_search', 'Kibana Search', 'Kibana'); +insert into design_type (`name`,`display`,`portal`) values ('kibana_visual', 'Kibana Visualization', 'Kibana'); +insert into design_type (`name`,`display`,`portal`) values ('es_mapping', 'Elasticsearch Field Mapping Template', 'Elasticsearch'); +insert into design_type (`name`,`display`,`portal`) values ('druid_kafka_spec', 'Druid Kafka Indexing Service Supervisor Spec', 'Druid'); diff --git a/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/DesignType.java b/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/DesignType.java index 3e730c14..a7716451 100644 --- a/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/DesignType.java +++ b/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/DesignType.java @@ -47,6 +47,9 @@ public class DesignType { @JsonBackReference private Portal portal; + @Column(name = "`display`") + private String display; + @Column(name = "`note`") private String note; -- cgit