diff options
| author |   Kate Hsuan <kate.hsuan@qct.io> | 2019-04-19 09:51:05 +0800 |
|---|---|---|
| committer | Kate Hsuan <kate.hsuan@qct.io> | 2019-04-23 10:16:42 +0800 |
| commit | faffe4542ed3d5838be1ae195522d558258f93ee (patch) | |
| tree | 8446ab82f26d33c63a6f6bbefc83d9f351f0e76e /components/datalake-handler/feeder/src/assembly | |
| parent | da4ba6e2c81f3dd7157e1cc06a92e91c5a38aa95 (diff) | |
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 <kate.hsuan@qct.io>
Diffstat (limited to 'components/datalake-handler/feeder/src/assembly')
| -rw-r--r-- | components/datalake-handler/feeder/src/assembly/scripts/init_db.sql | 10 |
1 files changed, 5 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 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
|