From 35481027b3fdf251a3b520ab5b1ae89c7d2d0e34 Mon Sep 17 00:00:00 2001 From: Kavitha P Date: Wed, 25 Aug 2021 16:12:18 +0530 Subject: CCSDK-3434 CBA workflow status store Change-Id: Iaeac6fa534c569bbc152e6c8a78c2dd23b6c4b1a Signed-off-by: Kavitha P Issue-ID: CCSDK-3434 --- .../src/main/resources/application-dev.properties | 4 ++++ .../src/main/resources/application.properties | 4 ++++ .../src/main/resources/sql/schema-local.sql | 24 +++++++++++++++++++++- .../application/src/main/resources/sql/schema.sql | 22 ++++++++++++++++++++ .../src/test/resources/application-test.properties | 4 ++++ .../src/test/resources/application.properties | 4 ++++ 6 files changed, 61 insertions(+), 1 deletion(-) (limited to 'ms/blueprintsprocessor/application') diff --git a/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties b/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties index e7443434a..e20e2649d 100755 --- a/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties +++ b/ms/blueprintsprocessor/application/src/main/resources/application-dev.properties @@ -175,3 +175,7 @@ blueprintsprocessor.messageproducer.self-service-api.audit.response.topic=audit- blueprintprocessor.k8s.plugin.username=test blueprintprocessor.k8s.plugin.password=pass blueprintprocessor.k8s.plugin.url=http://multicloud-k8s:9015/ + +#Workflow store configuration +#workflow Audit request +blueprintsprocessor.workflow.self-service-api.audit.storeEnable=false diff --git a/ms/blueprintsprocessor/application/src/main/resources/application.properties b/ms/blueprintsprocessor/application/src/main/resources/application.properties index 9b48359a1..eef45f052 100755 --- a/ms/blueprintsprocessor/application/src/main/resources/application.properties +++ b/ms/blueprintsprocessor/application/src/main/resources/application.properties @@ -168,3 +168,7 @@ management.info.git.mode=full blueprintprocessor.k8s.plugin.username=test blueprintprocessor.k8s.plugin.password=pass blueprintprocessor.k8s.plugin.url=http://multicloud-k8s:9015/ + +#Workflow store configuration +#workflow Audit request +blueprintsprocessor.workflow.self-service-api.audit.storeEnable=false diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql index 05df4200a..794a3b42a 100644 --- a/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql +++ b/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql @@ -80,4 +80,26 @@ CREATE TABLE IF NOT EXISTS sdnctl.RESOURCE_DICTIONARY ( updated_by VARCHAR(100) NOT NULL, primary key PK_RESOURCE_DICTIONARY (name), INDEX IX_RESOURCE_DICTIONARY (name) -) ENGINE=InnoDB; \ No newline at end of file +) ENGINE=InnoDB; + +-- ----------------------------------------------------- +-- table BLUEPRINT_WORKFLOW_AUDIT_STATUS +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS sdnctl.BLUEPRINT_WORKFLOW_AUDIT_STATUS ( + workflow_audit_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY, + workflow_task_content longtext NOT NULL, + originator_Id varchar(255) NOT NULL, + request_Id varchar(255) NOT NULL, + subRequest_Id varchar(255) NOT NULL, + workflow_name varchar(255) NOT NULL, + status varchar(255) NULL, + start_time datetime NULL, + end_time datetime NULL, + updated_date datetime NULL, + updated_by varchar(255) NULL, + blueprint_version varchar(255) NOT NULL, + blueprint_name varchar(255) NOT NULL, + request_mode varchar(255) NULL, + workflow_response_content longtext NULL, + blueprint_uuid varchar(255) NULL +) AUTO_INCREMENT = 1000 ENGINE=InnoDB; diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql index 6dcd2af89..851adcf6c 100644 --- a/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql +++ b/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql @@ -77,3 +77,25 @@ CREATE TABLE IF NOT EXISTS configurator.RESOURCE_DICTIONARY ( primary key PK_RESOURCE_DICTIONARY (name), INDEX IX_RESOURCE_DICTIONARY (name) ) ENGINE=InnoDB; + +-- ----------------------------------------------------- +-- table BLUEPRINT_WORKFLOW_AUDIT_STATUS +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS configurator.BLUEPRINT_WORKFLOW_AUDIT_STATUS ( + workflow_audit_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY, + workflow_task_content longtext NOT NULL, + originator_Id varchar(255) NOT NULL, + request_Id varchar(255) NOT NULL, + subRequest_Id varchar(255) NOT NULL, + workflow_name varchar(255) NOT NULL, + status varchar(255) NULL, + start_time datetime NULL, + end_time datetime NULL, + updated_date datetime NULL, + updated_by varchar(255) NULL, + blueprint_version varchar(255) NOT NULL, + blueprint_name varchar(255) NOT NULL, + request_mode varchar(255) NULL, + workflow_response_content longtext NULL, + blueprint_uuid varchar(255) NULL +) AUTO_INCREMENT = 1000 ENGINE=InnoDB; diff --git a/ms/blueprintsprocessor/application/src/test/resources/application-test.properties b/ms/blueprintsprocessor/application/src/test/resources/application-test.properties index c436b3876..b23cdb284 100644 --- a/ms/blueprintsprocessor/application/src/test/resources/application-test.properties +++ b/ms/blueprintsprocessor/application/src/test/resources/application-test.properties @@ -71,3 +71,7 @@ cdslistener.healthcheck.mapping-service-name-with-service-link=[SDC Listener ser blueprintprocessor.k8s.plugin.username=test blueprintprocessor.k8s.plugin.password=pass blueprintprocessor.k8s.plugin.url=http://multicloud-k8s:9015/ + +#Workflow store configuration +#workflow Audit request +blueprintsprocessor.workflow.self-service-api.audit.storeEnable=false diff --git a/ms/blueprintsprocessor/application/src/test/resources/application.properties b/ms/blueprintsprocessor/application/src/test/resources/application.properties index c6e957b32..6bac3a3d6 100644 --- a/ms/blueprintsprocessor/application/src/test/resources/application.properties +++ b/ms/blueprintsprocessor/application/src/test/resources/application.properties @@ -98,3 +98,7 @@ blueprintsprocessor.messageproducer.self-service-api.audit.response.topic=audit- endpoints.user.name=eHbVUbJAj4AG2522cSbrOQ== endpoints.user.password=eHbVUbJAj4AG2522cSbrOQ== + +#Workflow store configuration +#workflow Audit request +blueprintsprocessor.workflow.self-service-api.audit.storeEnable=false -- cgit 1.2.3-korg