From 18253e5bfbccc53baaa58e485704e9cb87855ac4 Mon Sep 17 00:00:00 2001 From: "Magnusen, Drew (dm741q)" Date: Thu, 7 Sep 2017 08:55:17 -0500 Subject: Addition of State Management Feature Patch 1:This commit adds the feature to provide node state management. There are also a couple of very minor cleanup items in feature-session-persistence which came up during review and testing. Patch 2: Cleaned up some logging statements and exceptions per comments by Pam Dragosh. Patch 3: Clean up per comments from Jorge Hernandez. Patch4: Added a default to ignoreErrors in RepositoryAudit. Patch 5: Rebase. Patch 6: Removed api-state-management/.gitignore Issue-ID: POLICY-155 Change-Id: I4fbfa33314d488ff46764931ca965f802b6a26d5 Signed-off-by: Kevin McKiou --- .../sql/18020-statemanagement.upgrade.sql | 74 ++++++++++++++++++++++ 1 file changed, 74 insertions(+) create mode 100644 feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql (limited to 'feature-state-management/src/main/feature/db/statemanagement') diff --git a/feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql b/feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql new file mode 100644 index 00000000..f73f992b --- /dev/null +++ b/feature-state-management/src/main/feature/db/statemanagement/sql/18020-statemanagement.upgrade.sql @@ -0,0 +1,74 @@ +/*- + * ============LICENSE_START======================================================= + * feature-state-management + * ================================================================================ + * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * ============LICENSE_END========================================================= + */ + +set foreign_key_checks=0; + +CREATE TABLE if not exists statemanagement.StateManagementEntity +( + id int not null auto_increment, + resourceName varchar(100) not null, + adminState varchar(20) not null, + opstate varchar(20) not null, + availStatus varchar(20), + standbyStatus varchar(20), + created_date timestamp not null default current_timestamp, + modifiedDate timestamp not null, + primary key(id), + unique key resource(resourceName) +); + +CREATE TABLE if not exists statemanagement.ResourceRegistrationEntity +( + resourceRegistrationId bigint not null auto_increment, + resourceName varchar(100) not null, + resourceURL varchar(255) not null, + site varchar(50), + nodetype varchar(50), + created_date timestamp not null default current_timestamp, + last_updated timestamp not null, + primary key (resourceRegistrationId), + unique key resource (resourceName), + unique key id_resource_url (resourceURL) +); + +CREATE TABLE if not exists statemanagement.ForwardProgressEntity +( + forwardProgressId bigint not null auto_increment, + resourceName varchar(100) not null, + fpc_count bigint not null, + created_date timestamp not null default current_timestamp, + last_updated timestamp not null, + primary key (forwardProgressId), + unique key resource_key (resourceName) +); + +CREATE TABLE if not exists statemanagement.sequence +( +SEQ_NAME VARCHAR(50) NOT NULL, +SEQ_COUNT DECIMAL(38,0), +PRIMARY KEY (SEQ_NAME) +); + +-- Will only insert a record if none exists: +INSERT INTO statemanagement.SEQUENCE (SEQ_NAME,SEQ_COUNT) +SELECT * FROM (SELECT 'SEQ_GEN',1) AS tmp +WHERE NOT EXISTS(select SEQ_NAME from statemanagement.SEQUENCE where SEQ_NAME = 'SEQ_GEN') LIMIT 1; + +set foreign_key_checks=1; \ No newline at end of file -- cgit 1.2.3-korg