summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBT2983 <BT2983@att.com>2018-07-24 07:41:16 -0600
committerBT2983 <BT2983@att.com>2018-07-24 07:41:16 -0600
commited04622cea4a463b226bafb20eb5d8f76e0f2de9 (patch)
tree53a8908148cdf252946f96c60f09abdc2f381a17
parentf5da5198e43addc77989dee8b500cb69e9885f93 (diff)
Adding naming micro-service code - scripts-2.
Refactor DB scripts. Change-Id: I9a9a2f57435a73f7adb35c388d33dad1f9316e75 Issue-ID: CCSDK-342 Signed-off-by: BT2983 <BT2983@att.com>
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/03_ref_data_upd_dml.sql8
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/05_ref_data_upd_dml.sql5
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/06_ref_data_upd_dml.sql9
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/07_ref_data_extrn_int_update_dml.sql21
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/08_ref_data_extrn_int_update_dml.sql12
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/09_table_upd_ddl.sql4
-rw-r--r--ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/10_ref_data_upd_dml.sql5
7 files changed, 0 insertions, 64 deletions
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/03_ref_data_upd_dml.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/03_ref_data_upd_dml.sql
deleted file mode 100644
index 2c33bb09..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/03_ref_data_upd_dml.sql
+++ /dev/null
@@ -1,8 +0,0 @@
---liquibase formatted sql
---changeset ref_data_update:18_10.ref_data_update.sql
-
-INSERT INTO SERVICE_PARAMETER(NAME, VALUE, CREATED_BY) VALUES ('max_gen_attempt','50','Initial');
-
-delete from IDENTIFIER_MAP;
-
-INSERT INTO IDENTIFIER_MAP(POLICY_FN_NAME, JS_FN_NAME, CREATED_BY) VALUES ('sub_str','substr', 'Initial');
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/05_ref_data_upd_dml.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/05_ref_data_upd_dml.sql
deleted file mode 100644
index 34bd6dc3..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/05_ref_data_upd_dml.sql
+++ /dev/null
@@ -1,5 +0,0 @@
---liquibase formatted sql
---changeset ref_data_update:18_10.ref_data_update.sql
-
-INSERT INTO IDENTIFIER_MAP(POLICY_FN_NAME, JS_FN_NAME, CREATED_BY) VALUES ('substr','substr', 'Initial');
-INSERT INTO SERVICE_PARAMETER(NAME, VALUE, CREATED_BY) VALUES ('use_db_policy','Y','Initial');
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/06_ref_data_upd_dml.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/06_ref_data_upd_dml.sql
deleted file mode 100644
index da4e1ba3..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/06_ref_data_upd_dml.sql
+++ /dev/null
@@ -1,9 +0,0 @@
---liquibase formatted sql
---changeset ref_data_update_more:18_10.ref_data_update_more.sql
-
--- update policy functions to java implementations
-
-UPDATE IDENTIFIER_MAP SET JS_FN_NAME = 'substring' WHERE POLICY_FN_NAME='sub_str';
-UPDATE IDENTIFIER_MAP SET JS_FN_NAME = 'substring' WHERE POLICY_FN_NAME='substr';
-INSERT INTO IDENTIFIER_MAP(POLICY_FN_NAME, JS_FN_NAME, CREATED_BY) VALUES ('to_lower_case','toLowerCase', 'Initial');
-INSERT INTO IDENTIFIER_MAP(POLICY_FN_NAME, JS_FN_NAME, CREATED_BY) VALUES ('to_upper_case','toUpperCase', 'Initial');
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/07_ref_data_extrn_int_update_dml.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/07_ref_data_extrn_int_update_dml.sql
deleted file mode 100644
index 749076c9..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/07_ref_data_extrn_int_update_dml.sql
+++ /dev/null
@@ -1,21 +0,0 @@
---liquibase formatted sql
---changeset ref_data_update_extin:18_10.ref_data_update.sql
-
--- clean up any data
-delete from external_interface where PARAM in ('VNF', 'VNFC', 'VM', 'VFMODULE');
-
---insert the data
-
-insert into external_interface(SYSTEM,PARAM,URL_SUFFIX,CREATED_TIME,CREATED_BY,LAST_UPDATED_TIME,LAST_UPDATED_BY)
-values('aai','VNF','nodes/generic-vnfs?vnf-name=',sysdate(),'nengsys',sysdate(),'nengsys');
-
-insert into external_interface(SYSTEM,PARAM,URL_SUFFIX,CREATED_TIME,CREATED_BY,LAST_UPDATED_TIME,LAST_UPDATED_BY)
-values('aai','VNFC','nodes/vnfcs?vnfc-name=',sysdate(),'nengsys',sysdate(),'nengsys');
-
-insert into external_interface(SYSTEM,PARAM,URL_SUFFIX,CREATED_TIME,CREATED_BY,LAST_UPDATED_TIME,LAST_UPDATED_BY)
-values('aai','VM','nodes/vservers?vserver-name=',sysdate(),'nengsys',sysdate(),'nengsys');
-
-insert into external_interface(SYSTEM,PARAM,URL_SUFFIX,CREATED_TIME,CREATED_BY,LAST_UPDATED_TIME,LAST_UPDATED_BY)
-values('aai','VFMODULE','nodes/vf-modules?vf-module-name=',sysdate(),'nengsys',sysdate(),'nengsys');
-
-commit;
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/08_ref_data_extrn_int_update_dml.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/08_ref_data_extrn_int_update_dml.sql
deleted file mode 100644
index 36935c29..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/08_ref_data_extrn_int_update_dml.sql
+++ /dev/null
@@ -1,12 +0,0 @@
---liquibase formatted sql
---changeset ref_data_update_extin:18_10.ref_data_update.sql
-
--- clean up any data
-delete from external_interface where PARAM in ('VF-MODULE');
-
---insert the data
-
-insert into external_interface(SYSTEM,PARAM,URL_SUFFIX,CREATED_TIME,CREATED_BY,LAST_UPDATED_TIME,LAST_UPDATED_BY)
-values('aai','VF-MODULE','nodes/vf-modules?vf-module-name=',sysdate(),'nengsys',sysdate(),'nengsys');
-
-commit;
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/09_table_upd_ddl.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/09_table_upd_ddl.sql
deleted file mode 100644
index eccd921f..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/09_table_upd_ddl.sql
+++ /dev/null
@@ -1,4 +0,0 @@
---liquibase formatted sql
---changeset generate_name_ddl_update:18_10.table_update.sql
-
-alter table generated_name MODIFY COLUMN created_time DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL;;
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/10_ref_data_upd_dml.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/10_ref_data_upd_dml.sql
deleted file mode 100644
index b589a986..00000000
--- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/10_ref_data_upd_dml.sql
+++ /dev/null
@@ -1,5 +0,0 @@
---liquibase formatted sql
---changeset service_param_update_sql:18_10.ref_update.sql
-
-DELETE FROM SERVICE_PARAMETER where NAME='use_db_policy';
-INSERT INTO SERVICE_PARAMETER(NAME, VALUE, CREATED_BY) VALUES ('use_db_policy','N','Initial');