Add REST API calls for DB manipulation.

[dcaegen2/services.git] / components / datalake-handler / feeder / src / assembly / scripts / init_db.sql

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 2185320..a349d14 100644 (file)
--- a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql
+++ b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql
@@ -21,6 +21,9 @@ CREATE TABLE `topic` (
 CREATE TABLE `db` (\r
   `name` varchar(255) NOT NULL,\r
   `host` varchar(255) DEFAULT NULL,\r
+  `port` int(11) DEFAULT NULL,\r
+  `database_name` varchar(255) DEFAULT NULL,\r
+  `encrypt` bit(1) DEFAULT NULL,\r
   `login` varchar(255) DEFAULT NULL,\r
   `pass` varchar(255) DEFAULT NULL,\r
   `property1` varchar(255) DEFAULT NULL,\r
@@ -40,10 +43,10 @@ CREATE TABLE `map_db_topic` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r
 \r
 \r
-insert into db (name,host,login,pass,property1) values ('Couchbase','dl_couchbase','dmaap','dmaap1234','dmaap');\r
-insert into db (name,host) values ('Elasticsearch','dl_es');\r
-insert into db (name,host) values ('MongoDB','dl_mongodb');\r
-insert into db (name,host) values ('Druid','dl_druid');\r
+insert into db (`name`,`host`,`login`,`pass`,`database`) values ('Couchbase','dl_couchbase','dl','dl1234','datalake');\r
+insert into db (`name`,`host`) values ('Elasticsearch','dl_es');\r
+insert into db (`name`,`host`,`port`,`database`) values ('MongoDB','dl_mongodb',27017,'datalake');\r
+insert into db (`name`,`host`) values ('Druid','dl_druid');\r
 \r
 \r
 -- in production, default enabled should be off\r
@@ -51,4 +54,7 @@ insert into `topic`(`name`,`enabled`,`save_raw`,`ttl`,`data_format`) values ('_D
 insert into `topic`(`name`,`enabled`) values ('__consumer_offsets',0);\r
 \r
 \r
-insert into `map_db_topic`(`db_name`,`topic_name`) values ('MongoDB','_DL_DEFAULT_'); \r
+insert into `map_db_topic`(`db_name`,`topic_name`) values ('Couchbase','_DL_DEFAULT_');\r
+insert into `map_db_topic`(`db_name`,`topic_name`) values ('Elasticsearch','_DL_DEFAULT_');\r
+insert into `map_db_topic`(`db_name`,`topic_name`) values ('MongoDB','_DL_DEFAULT_');\r
+insert into `map_db_topic`(`db_name`,`topic_name`) values ('Druid','_DL_DEFAULT_');\r