From faffe4542ed3d5838be1ae195522d558258f93ee Mon Sep 17 00:00:00 2001 From: Kate Hsuan Date: Fri, 19 Apr 2019 09:51:05 +0800 Subject: Add REST API calls for DB manipulation. 1. Add the REST APIs for DB configuration. 2. Fix ORM relationship. Issue-ID: DCAEGEN2-1437 Change-Id: Iae842921aa671419e57f569093ecdd74dea4f8d2 Signed-off-by: Kate Hsuan --- .../datalake-handler/feeder/src/assembly/scripts/init_db.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'components/datalake-handler/feeder/src/assembly') 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 32b9268c..a349d146 100644 --- a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql +++ b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql @@ -22,7 +22,7 @@ CREATE TABLE `db` ( `name` varchar(255) NOT NULL, `host` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, - `database` varchar(255) DEFAULT NULL, + `database_name` varchar(255) DEFAULT NULL, `encrypt` bit(1) DEFAULT NULL, `login` varchar(255) DEFAULT NULL, `pass` varchar(255) DEFAULT NULL, @@ -43,10 +43,10 @@ CREATE TABLE `map_db_topic` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -insert into db (name,host,login,pass,`database`) values ('Couchbase','dl_couchbase','dl','dl1234','datalake'); -insert into db (name,host) values ('Elasticsearch','dl_es'); -insert into db (name,host,port,`database`) values ('MongoDB','dl_mongodb',27017,'datalake'); -insert into db (name,host) values ('Druid','dl_druid'); +insert into db (`name`,`host`,`login`,`pass`,`database`) values ('Couchbase','dl_couchbase','dl','dl1234','datalake'); +insert into db (`name`,`host`) values ('Elasticsearch','dl_es'); +insert into db (`name`,`host`,`port`,`database`) values ('MongoDB','dl_mongodb',27017,'datalake'); +insert into db (`name`,`host`) values ('Druid','dl_druid'); -- in production, default enabled should be off -- cgit 1.2.3-korg