diff options
author | 2019-05-07 12:18:19 +0000 | |
---|---|---|
committer | 2019-05-07 12:18:19 +0000 | |
commit | 56414b15fce9c9e292160a767eacbfc0a37eccff (patch) | |
tree | 500f92df4d9a4f8864e624a1426ad448ae5bc2f2 | |
parent | a5336234db7c92232371b3bcc28817baaf4144f0 (diff) | |
parent | 55072522875beca6ed2cc0bc6604369715c2252c (diff) |
Merge "Add dashboard template configuration schema"
-rw-r--r-- | components/datalake-handler/feeder/src/assembly/scripts/init_db.sql | 38 | ||||
-rw-r--r-- | components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/Db.java | 3 |
2 files changed, 41 insertions, 0 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 e201242d..6688d684 100644 --- a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql +++ b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql @@ -17,6 +17,7 @@ CREATE TABLE `topic` ( CREATE TABLE `db` (
`name` varchar(255) NOT NULL,
+ `enabled` bit(1) DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
`port` int(11) DEFAULT NULL,
`database_name` varchar(255) DEFAULT NULL,
@@ -39,6 +40,43 @@ CREATE TABLE `map_db_topic` ( CONSTRAINT `FK_db_name` FOREIGN KEY (`db_name`) REFERENCES `db` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+CREATE TABLE `dashboard_template` (
+ `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) NOT NULL,
+ `body` text DEFAULT NULL,
+ `note` text DEFAULT NULL,
+ `topic` varchar(255) DEFAULT NULL,
+ `type` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `FK_topic` (`topic`),
+ KEY `FK_type` (`type`),
+ CONSTRAINT `FK_topic` FOREIGN KEY (`topic`) REFERENCES `topic` (`name`) ON DELETE SET NULL,
+ CONSTRAINT `FK_type` FOREIGN KEY (`type`) REFERENCES `dashboard_type` (`name`) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `dashboard_type` (
+ `name` varchar(255) NOT NULL,
+ `dashboard` varchar(255) DEFAULT NULL,
+ `note` text DEFAULT NULL,
+ PRIMARY KEY (`name`),
+ KEY `FK_dashboard` (`dashboard`),
+ CONSTRAINT `FK_dashboard` FOREIGN KEY (`dashboard`) REFERENCES `dashboard` (`name`) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `dashboard` (
+ `name` varchar(255) NOT NULL DEFAULT '',
+ `type` varchar(255) DEFAULT NULL,
+ `address` varchar(500) DEFAULT NULL,
+ `port` int(5) unsigned DEFAULT NULL,
+ `username` varchar(255) DEFAULT NULL,
+ `password` varchar(255) DEFAULT NULL,
+ `related_db` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`name`),
+ KEY `FK_related_db` (`related_db`),
+ CONSTRAINT `FK_related_db` FOREIGN KEY (`related_db`) REFERENCES `db` (`name`) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
insert into db (`name`,`host`,`login`,`pass`,`database_name`) values ('Couchbase','dl_couchbase','dl','dl1234','datalake');
insert into db (`name`,`host`) values ('Elasticsearch','dl_es');
diff --git a/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/Db.java b/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/Db.java index 7aaf4e35..da1f6cab 100644 --- a/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/Db.java +++ b/components/datalake-handler/feeder/src/main/java/org/onap/datalake/feeder/domain/Db.java @@ -49,6 +49,9 @@ public class Db { @Column(name="`name`") private String name; + @Column(name="`enabled`") + private boolean enabled; + @Column(name="`host`") private String host; |