aboutsummaryrefslogtreecommitdiffstats
path: root/cmso-service/src/main
diff options
context:
space:
mode:
authorRamaPrasad Amaranarayana (ra5425) <ra5425@att.com>2018-09-19 18:38:46 -0400
committerRamaPrasad Amaranarayana (ra5425) <ra5425@att.com>2018-09-19 18:38:46 -0400
commitc47d835762dfd4423ab77d3c525a2c541af6b36e (patch)
tree5fbb06d83b1e9af92afb6c52e91c01713889a0de /cmso-service/src/main
parent3732a8d3365e0fe0c0d3cf98e9c6653dbee277ef (diff)
Change Management Schedule Optimization
Adding CMSO Service Common Utilities and Table Model Dao Files for Change Management Schedule Optimization Change-Id: I93c0f86598789fae3b3e1bc105a939730a609d97 Issue-ID: OPTFRA-353 Signed-off-by: RamaPrasad Amaranarayana (ra5425) <ra5425@att.com>
Diffstat (limited to 'cmso-service/src/main')
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ApprovalType.java100
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementChangeWindow.java136
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementDetail.java372
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementGroup.java236
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementSchedule.java348
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/Domain.java63
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/DomainData.java104
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/HelloWorld.java58
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/Schedule.java360
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleApproval.java150
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleEvent.java160
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleQuery.java52
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ApprovalTypeDAO.java52
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementChangeWindowDAO.java56
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAO.java41
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAOImpl.java75
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementGroupDAO.java53
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementScheduleDAO.java77
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/DomainDataDAO.java45
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleApprovalDAO.java45
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleDAO.java69
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleEventDAO.java53
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAO.java41
-rw-r--r--cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAOImpl.java64
24 files changed, 2810 insertions, 0 deletions
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ApprovalType.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ApprovalType.java
new file mode 100644
index 0000000..d4ab593
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ApprovalType.java
@@ -0,0 +1,100 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+
+/**
+ * The persistent class for the approval_types database table.
+ *
+ */
+@Entity
+@Table(name = "APPROVAL_TYPES")
+@NamedQuery(name = "ApprovalType.findAll", query = "SELECT a FROM ApprovalType a")
+public class ApprovalType implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @Id
+ @GeneratedValue
+ private int id;
+
+ @Column(name = "approval_count")
+ private int approvalCount;
+
+ @Column(name = "approval_type")
+ private String approvalType;
+
+ // bi-directional many-to-one association to Domain
+ @Column(name = "domain")
+ private String domain;
+
+ public ApprovalType() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public int getApprovalCount() {
+ return this.approvalCount;
+ }
+
+ public void setApprovalCount(int approvalCount) {
+ this.approvalCount = approvalCount;
+ }
+
+ public String getApprovalType() {
+ return this.approvalType;
+ }
+
+ public void setApprovalType(String approvalType) {
+ this.approvalType = approvalType;
+ }
+
+ public String getDomain() {
+ return domain;
+ }
+
+ public void setDomain(String domain) {
+ this.domain = domain;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementChangeWindow.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementChangeWindow.java
new file mode 100644
index 0000000..ceece9a
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementChangeWindow.java
@@ -0,0 +1,136 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+
+/**
+ * The persistent class for the change_management_change_windows database table.
+ *
+ */
+@Entity
+@Table(name = "CHANGE_MANAGEMENT_CHANGE_WINDOWS")
+@NamedQuery(name = "ChangeManagementChangeWindow.findAll", query = "SELECT c FROM ChangeManagementChangeWindow c")
+@ApiModel(value = "Change Window", description = "Desired window within which the VNF changes are to be execututed.")
+public class ChangeManagementChangeWindow implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @JsonIgnore
+ @Id
+ @GeneratedValue
+ private int id;
+
+ @JsonIgnore
+ @Column(name = "finish_time")
+ private Long finishTimeMillis;
+
+ @ApiModelProperty(value = "Time by which all changes must be completed")
+ @JsonProperty
+ @Transient
+ private String finishTime;
+
+ @JsonIgnore
+ @Column(name = "start_time")
+ private Long startTimeMillis;
+
+ @ApiModelProperty(value = "Earliest date/time to initiate changes")
+ @JsonProperty
+ @Transient
+ private String startTime;
+
+ @JsonIgnore
+ @Column(name = "change_management_groups_id")
+ private int changeManagementGroupsId;
+
+ public ChangeManagementChangeWindow() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getFinishTime() {
+ if (finishTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.finishTimeMillis);
+ return null;
+ }
+
+ public void setFinishTime(String finishTime) {}
+
+ public String getStartTime() {
+ if (startTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.startTimeMillis);
+ return null;
+ }
+
+ public void setStartTime(String startTime) {}
+
+ public int getChangeManagementGroupsId() {
+ return changeManagementGroupsId;
+ }
+
+ public void setChangeManagementGroupsId(int changeManagementGroupsId) {
+ this.changeManagementGroupsId = changeManagementGroupsId;
+ }
+
+ public Long getFinishTimeMillis() {
+ return finishTimeMillis;
+ }
+
+ public void setFinishTimeMillis(Long finishTimeMillis) {
+ this.finishTimeMillis = finishTimeMillis;
+ }
+
+ public Long getStartTimeMillis() {
+ return startTimeMillis;
+ }
+
+ public void setStartTimeMillis(Long startTimeMillis) {
+ this.startTimeMillis = startTimeMillis;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementDetail.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementDetail.java
new file mode 100644
index 0000000..3b82c62
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementDetail.java
@@ -0,0 +1,372 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.Lob;
+import javax.persistence.Transient;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+
+@Entity
+
+// @NamedNativeQueries({
+// @NamedNativeQuery(
+// name = "searchScheduleDetails",
+// query = "SELECT id, firstName, lastName, email, department.id, department.name " +
+// "FROM employee, department",
+// resultClass=ChangeManagementDetail.class
+// ),
+// })
+@ApiModel(value = "Change Management Details",
+ description = "VNF information returned for Change Management Schedule Search request")
+public class ChangeManagementDetail {
+ @Id
+ @JsonIgnore
+ @GeneratedValue
+ private int id;
+
+ @ApiModelProperty(value = "Name of the VNF.")
+ @Column(name = "vnf_name")
+ private String vnfName;
+
+ @JsonIgnore
+ @Column(name = "vnf_id")
+ private String vnfId;
+
+ @ApiModelProperty(value = "Status of the VNF.", allowableValues = "See CMSStatusEnum")
+ @Column(name = "status")
+ private String status;
+
+ @ApiModelProperty(value = "TM Change Id")
+ @Column(name = "tm_change_id")
+ private String tmChangeId;
+
+ @ApiModelProperty(value = "TM ticket status", allowableValues = "<null>,Closed")
+ @Column(name = "tm_status")
+ private String tmStatus;
+
+ @ApiModelProperty(value = "TM ticket approval status", allowableValues = "<null>,Approved")
+ @Column(name = "tm_approval_status")
+ private String tmApprovalStatus;
+
+ @JsonIgnore
+ @Column(name = "start_time")
+ private Long startTimeMillis;
+
+ @ApiModelProperty(
+ value = "Start time of this VNF workflow assigned by Scheduler based upon the group start time returned by the optimizer and concurrency.")
+ @JsonProperty
+ @Transient
+ private String startTime;
+
+ @JsonIgnore
+ @Column(name = "finish_time")
+ private Long finishTimeMillis;
+
+ @ApiModelProperty(value = "Anticipated time of completion based upon start time and duration")
+ @JsonProperty
+ @Transient
+ private String finishTime;
+
+ @ApiModelProperty(value = "Name of the group of VNFs to be scheduled")
+ @Column(name = "group_id")
+ private String groupId;
+
+ @JsonIgnore
+ @Column(name = "last_instance_start_time")
+ private Long lastInstanceStartTimeMillis;
+
+ @ApiModelProperty(value = "The latest date/time by which a workflow is to be started.")
+ @JsonProperty
+ @Transient
+ private String lastInstanceStartTime;
+
+ @ApiModelProperty(value = "Time of last poll for MSO status.")
+ @Column(name = "policy_id")
+ private String policyId;
+
+ @JsonIgnore
+ @Column(name = "dispatch_time")
+ private Long dispatchTimeMillis;
+
+ @ApiModelProperty(value = "Actual time the VNF workflow was dispatched.")
+ @JsonProperty
+ @Transient
+ private String dispatchTime;
+
+ @JsonIgnore
+ @Column(name = "execution_completed_time")
+ private Long executionCompletedTimeMillis;
+
+ @ApiModelProperty(value = "Actual time the VNF workflow execution was completed as reported by MSO.")
+ @JsonProperty
+ @Transient
+ private String executionCompletedTime;
+
+ @ApiModelProperty(value = "MSO Request ID of the workflow returned at dispatch time.")
+ @Column(name = "mso_request_id")
+ private String msoRequestId;
+
+ @ApiModelProperty(value = "Final MSO status.", allowableValues = "COMPLETED,FAILED")
+ @Column(name = "mso_status")
+ private String msoStatus;
+
+ @ApiModelProperty(value = "MSO final status message.")
+ @Lob
+ @Column(name = "mso_message")
+ private String msoMessage;
+
+ @ApiModelProperty(value = "Scheduler status message.")
+ @Lob
+ @Column(name = "status_message")
+ private String statusMessage;
+
+ @JsonIgnore
+ @Column(name = "mso_time")
+ private Long msoTimeMillis;
+
+ @ApiModelProperty(value = "Time of last poll for MSO status.")
+ @JsonProperty
+ @Transient
+ private String msoTime;
+
+ @JsonIgnore
+ private int schedules_id;
+
+ public String getVnfName() {
+ return vnfName;
+ }
+
+ public void setVnfName(String vnfName) {
+ this.vnfName = vnfName;
+ }
+
+ public String getVnfId() {
+ return vnfId;
+ }
+
+ public void setVnfId(String vnfId) {
+ this.vnfId = vnfId;
+ }
+
+ public String getStatus() {
+ return status;
+ }
+
+ public void setStatus(String status) {
+ this.status = status;
+ }
+
+ public String getTmChangeId() {
+ return tmChangeId;
+ }
+
+ public void setTmChangeId(String tmChangeId) {
+ this.tmChangeId = tmChangeId;
+ }
+
+ public String getStartTime() {
+ if (startTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(startTimeMillis);
+ return null;
+ }
+
+ public void setStartTime(String startTime) {}
+
+ public String getFinishTime() {
+ if (finishTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(finishTimeMillis);
+ return null;
+ }
+
+ public void setFinishTime(String finishTime) {}
+
+ public String getGroupId() {
+ return groupId;
+ }
+
+ public void setGroupId(String groupId) {
+ this.groupId = groupId;
+ }
+
+ public String getLastInstanceStartTime() {
+ if (lastInstanceStartTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(lastInstanceStartTimeMillis);
+ return null;
+ }
+
+ public void setLastInstanceStartTime(String lastInstanceStartTime) {}
+
+ public String getPolicyId() {
+ return policyId;
+ }
+
+ public void setPolicyId(String policyId) {
+ this.policyId = policyId;
+ }
+
+ public int getSchedulesId() {
+ return schedules_id;
+ }
+
+ public void setSchedulesId(int schedules_id) {
+ this.schedules_id = schedules_id;
+ }
+
+ public Long getStartTimeMillis() {
+ return startTimeMillis;
+ }
+
+ public void setStartTimeMillis(Long startTimeMillis) {
+ this.startTimeMillis = startTimeMillis;
+ }
+
+ public Long getFinishTimeMillis() {
+ return finishTimeMillis;
+ }
+
+ public void setFinishTimeMillis(Long finishTimeMillis) {
+ this.finishTimeMillis = finishTimeMillis;
+ }
+
+ public Long getLastInstanceStartTimeMillis() {
+ return lastInstanceStartTimeMillis;
+ }
+
+ public void setLastInstanceStartTimeMillis(Long lastInstanceStartTimeMillis) {
+ this.lastInstanceStartTimeMillis = lastInstanceStartTimeMillis;
+ }
+
+ public String getTmStatus() {
+ return tmStatus;
+ }
+
+ public void setTmStatus(String tmStatus) {
+ this.tmStatus = tmStatus;
+ }
+
+ public String getTmApprovalStatus() {
+ return tmApprovalStatus;
+ }
+
+ public void setTmApprovalStatus(String tmApprovalStatus) {
+ this.tmApprovalStatus = tmApprovalStatus;
+ }
+
+ public String getMsoRequestId() {
+ return msoRequestId;
+ }
+
+ public void setMsoRequestId(String msoRequestId) {
+ this.msoRequestId = msoRequestId;
+ }
+
+ public String getMsoStatus() {
+ return msoStatus;
+ }
+
+ public void setMsoStatus(String msoStatus) {
+ this.msoStatus = msoStatus;
+ }
+
+ public String getMsoMessage() {
+ return msoMessage;
+ }
+
+ public void setMsoMessage(String msoMessage) {
+ this.msoMessage = msoMessage;
+ }
+
+ public Long getDispatchTimeMillis() {
+ return dispatchTimeMillis;
+ }
+
+ public void setDispatchTimeMillis(Long dispatchTimeMillis) {
+ this.dispatchTimeMillis = dispatchTimeMillis;
+ }
+
+ public String getDispatchTime() {
+ if (dispatchTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(dispatchTimeMillis);
+ return null;
+ }
+
+ public void setDispatchTime(String dispatchTime) {}
+
+ public Long getExecutionCompletedTimeMillis() {
+ return executionCompletedTimeMillis;
+ }
+
+ public void setExecutionCompletedTimeMillis(Long executionCompletedTimeMillis) {
+ this.executionCompletedTimeMillis = executionCompletedTimeMillis;
+ }
+
+ public String getExecutionCompletedTime() {
+ if (executionCompletedTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(executionCompletedTimeMillis);
+ return null;
+ }
+
+ public void setExecutionCompletedTime(String executionCompletedTime) {}
+
+ public String getStatusMessage() {
+ return statusMessage;
+ }
+
+ public void setStatusMessage(String statusMessage) {
+ this.statusMessage = statusMessage;
+ }
+
+ public Long getMsoTimeMillis() {
+ return msoTimeMillis;
+ }
+
+ public void setMsoTimeMillis(Long msoTimeMillis) {
+ this.msoTimeMillis = msoTimeMillis;
+ }
+
+ public String getMsoTime() {
+ if (msoTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(msoTimeMillis);
+ return null;
+ }
+
+ public void setMsoTime(String msoTime) {}
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementGroup.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementGroup.java
new file mode 100644
index 0000000..0664851
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementGroup.java
@@ -0,0 +1,236 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import java.util.List;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+
+/**
+ * The persistent class for the change_management_groups database table.
+ *
+ */
+@Entity
+@Table(name = "CHANGE_MANAGEMENT_GROUPS")
+@NamedQuery(name = "ChangeManagementGroup.findAll", query = "SELECT c FROM ChangeManagementGroup c")
+@ApiModel(value = "Change Management Group", description = "Scheduling critirea for a group of VNFs")
+public class ChangeManagementGroup implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @JsonIgnore
+ @Id
+ @GeneratedValue
+ private int id;
+
+ @JsonIgnore
+ @Column(name = "finish_time")
+ private Long finishTimeMillis;
+
+ @ApiModelProperty(value = "Date/time by which all of the workflows should be completed.")
+ @JsonProperty
+ @Transient
+ private String finishTime;
+
+ @ApiModelProperty(value = "Name of the group of VNFs to be scheduled")
+ @Column(name = "group_id")
+ private String groupId;
+
+ @JsonIgnore
+ @Column(name = "last_instance_start_time")
+ private Long lastInstanceStartTimeMillis;
+
+ @ApiModelProperty(value = "The latest date/time by which a workflow is to be started.")
+ @JsonProperty
+ @Transient
+ private String lastInstanceStartTime;
+
+ @JsonIgnore
+ @Column(name = "start_time")
+ private Long startTimeMillis;
+
+ @ApiModelProperty(value = "The date/time when workflows are to be started.")
+ @JsonProperty
+ @Transient
+ private String startTime;
+
+ @JsonIgnore
+ @Column(name = "schedules_id")
+ private int schedulesId;
+
+ @Column(name = "additional_duration_in_secs")
+ @ApiModelProperty(value = "Time added to the workflow interval to allow for rollback in case of failure.")
+ private int additionalDurationInSecs;
+
+ @ApiModelProperty(value = "The maximum number of workflows that should be started simultaneiously.")
+ @Column(name = "concurrency_limit")
+ private int concurrencyLimit;
+
+ @ApiModelProperty(value = "Expected duration of a successful workflow execution.")
+ @Column(name = "normal_duration_in_secs")
+ private int normalDurationInSecs;
+
+ @ApiModelProperty(
+ value = "The name of the schedule optimization policy used by the change management schedule optimizer.")
+ @Column(name = "policy_id")
+ private String policyId;
+
+ @ApiModelProperty(value = "The list of VNF workflows scheduled.")
+ @JsonProperty
+ @Transient
+ private List<ChangeManagementSchedule> changeManagementSchedules;
+
+ public ChangeManagementGroup() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getFinishTime() {
+ if (finishTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.finishTimeMillis);
+ return null;
+ }
+
+ public void setFinishTime(String finishTime) {}
+
+ public String getGroupId() {
+ return this.groupId;
+ }
+
+ public void setGroupId(String groupId) {
+ this.groupId = groupId;
+ }
+
+ public String getLastInstanceStartTime() {
+ if (lastInstanceStartTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.lastInstanceStartTimeMillis);
+ return null;
+ }
+
+ public void setLastInstanceStartTime(String lastInstanceStartTime) {}
+
+ public String getStartTime() {
+ if (startTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.startTimeMillis);
+ return null;
+ }
+
+ public void setStartTime(String startTime) {}
+
+ public int getSchedulesId() {
+ return schedulesId;
+ }
+
+ public void setSchedulesId(int schedulesId) {
+ this.schedulesId = schedulesId;
+ }
+
+ public int getAdditionalDurationInSecs() {
+ return additionalDurationInSecs;
+ }
+
+ public void setAdditionalDurationInSecs(int additionalDurationInSecs) {
+ this.additionalDurationInSecs = additionalDurationInSecs;
+ }
+
+ public int getConcurrencyLimit() {
+ return concurrencyLimit;
+ }
+
+ public void setConcurrencyLimit(int concurrencyLimit) {
+ this.concurrencyLimit = concurrencyLimit;
+ }
+
+ public int getNormalDurationInSecs() {
+ return normalDurationInSecs;
+ }
+
+ public void setNormalDurationInSecs(int normalDurationInSecs) {
+ this.normalDurationInSecs = normalDurationInSecs;
+ }
+
+ public String getPolicyId() {
+ return policyId;
+ }
+
+ public void setPolicyId(String policyId) {
+ this.policyId = policyId;
+ }
+
+ public Long getFinishTimeMillis() {
+ return finishTimeMillis;
+ }
+
+ public void setFinishTimeMillis(Long finishTimeMillis) {
+ this.finishTimeMillis = finishTimeMillis;
+ }
+
+ public Long getLastInstanceStartTimeMillis() {
+ return lastInstanceStartTimeMillis;
+ }
+
+ public void setLastInstanceStartTimeMillis(Long lastInstanceStartTimeMillis) {
+ this.lastInstanceStartTimeMillis = lastInstanceStartTimeMillis;
+ }
+
+ public Long getStartTimeMillis() {
+ return startTimeMillis;
+ }
+
+ public void setStartTimeMillis(Long startTimeMillis) {
+ this.startTimeMillis = startTimeMillis;
+ }
+
+ public List<ChangeManagementSchedule> getChangeManagementSchedules() {
+ return changeManagementSchedules;
+ }
+
+ public void setChangeManagementSchedules(List<ChangeManagementSchedule> changeManagementSchedules) {
+ this.changeManagementSchedules = changeManagementSchedules;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementSchedule.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementSchedule.java
new file mode 100644
index 0000000..779e8ca
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ChangeManagementSchedule.java
@@ -0,0 +1,348 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.Lob;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+
+/**
+ * The persistent class for the change_management_schedules database table.
+ *
+ */
+@Entity
+@Table(name = "CHANGE_MANAGEMENT_SCHEDULES")
+@NamedQuery(name = "ChangeManagementSchedule.findAll", query = "SELECT c FROM ChangeManagementSchedule c")
+
+@ApiModel(value = "Change Management Schedule", description = "VNF details for Change Management Schedule")
+public class ChangeManagementSchedule implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @JsonIgnore
+ @Id
+ @GeneratedValue
+ private Integer id;
+
+ @ApiModelProperty(value = "TM Change Id")
+ @Column(name = "tm_change_id")
+ private String tmChangeId;
+
+ @ApiModelProperty(value = "TM ticket status", allowableValues = "<null>,Closed")
+ @Column(name = "tm_status")
+ private String tmStatus;
+
+ @ApiModelProperty(value = "TM ticket approval status", allowableValues = "<null>,Approved")
+ @Column(name = "tm_approval_status")
+ private String tmApprovalStatus;
+
+ @JsonIgnore
+ @Column(name = "finish_time")
+ private Long finishTimeMillis;
+
+ @JsonProperty
+ @Transient
+ @ApiModelProperty(value = "Anticipated time of completion based upon start time and duration")
+ private String finishTime;
+
+ @JsonIgnore
+ @Column(name = "start_time")
+ private Long startTimeMillis;
+
+ @ApiModelProperty(
+ value = "Start time of this VNF workflow assigned by Scheduler based upon the group start time returned by the optimizer and concurrency.")
+ @JsonProperty
+ @Transient
+ private String startTime;
+
+ @ApiModelProperty(value = "Status of the VNF.", allowableValues = "See CMSStatusEnum")
+ @Column(name = "status")
+ private String status;
+
+ @JsonIgnore
+ @Column(name = "vnf_id")
+ private String vnfId;
+
+ @ApiModelProperty(value = "Name of the VNF.")
+ @Column(name = "vnf_name")
+ private String vnfName;
+
+ @Column(name = "change_management_groups_id")
+ @JsonIgnore
+ private int changeManagementGroupsId;
+
+ @JsonIgnore
+ @Column(name = "dispatch_time")
+ private Long dispatchTimeMillis;
+
+ @ApiModelProperty(value = "Actual time the VNF workflow was dispatched.")
+ @JsonProperty
+ @Transient
+ private String dispatchTime;
+
+ @JsonIgnore
+ @Column(name = "dispatcher_instance")
+ private String dispatcherInstance;
+
+ @JsonIgnore
+ @Column(name = "execution_completed_time")
+ private Long executionCompletedTimeMillis;
+
+ @ApiModelProperty(value = "Actual time the VNF workflow execution was completed as reported by MSO.")
+ @JsonProperty
+ @Transient
+ private String executionCompletedTime;
+
+ @ApiModelProperty(value = "MSO Request ID of the workflow returned at dispatch time.")
+ @Column(name = "mso_request_id")
+ private String msoRequestId;
+
+ @ApiModelProperty(value = "Final MSO status.", allowableValues = "COMPLETED,FAILED")
+ @Column(name = "mso_status")
+ private String msoStatus;
+
+ @ApiModelProperty(value = "MSO final status message.")
+ @Lob
+ @Column(name = "mso_message")
+ private String msoMessage;
+
+ @ApiModelProperty(value = "Scheduler status message.")
+ @Lob
+ @Column(name = "status_message")
+ private String statusMessage;
+
+ @JsonIgnore
+ @Column(name = "mso_time")
+ private Long msoTimeMillis;
+
+ @ApiModelProperty(value = "Time of last poll for MSO status.")
+ @JsonProperty
+ @Transient
+ private String msoTime;
+
+ public ChangeManagementSchedule() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getFinishTime() {
+ if (finishTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(finishTimeMillis);
+ return null;
+ }
+
+ public void setFinishTime(String finishTime) {}
+
+ public String getStartTime() {
+ if (startTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(startTimeMillis);
+ return null;
+ }
+
+ public void setStartTime(String startTime) {}
+
+ public String getStatus() {
+ return this.status;
+ }
+
+ public void setStatus(String status) {
+ this.status = status;
+ }
+
+ public String getVnfId() {
+ return this.vnfId;
+ }
+
+ public void setVnfId(String vnfId) {
+ this.vnfId = vnfId;
+ }
+
+ public String getVnfName() {
+ return this.vnfName;
+ }
+
+ public void setVnfName(String vnfName) {
+ this.vnfName = vnfName;
+ }
+
+ public String getTmChangeId() {
+ return tmChangeId;
+ }
+
+ public void setTmChangeId(String tmChangeId) {
+ this.tmChangeId = tmChangeId;
+ }
+
+ public int getChangeManagementGroupsId() {
+ return changeManagementGroupsId;
+ }
+
+ public void setChangeManagementGroupsId(int changeManagementGroupsId) {
+ this.changeManagementGroupsId = changeManagementGroupsId;
+ }
+
+ public String getDispatchTime() {
+ if (dispatchTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(dispatchTimeMillis);
+ return null;
+ }
+
+ public void setDispatchTime(String dispatchTime) {}
+
+ public String getDispatcherInstance() {
+ return dispatcherInstance;
+ }
+
+ public void setDispatcherInstance(String dispatcherInstance) {
+ this.dispatcherInstance = dispatcherInstance;
+ }
+
+ public String getExecutionCompletedTime() {
+ if (executionCompletedTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(executionCompletedTimeMillis);
+ return null;
+ }
+
+ public void setExecutionCompletedTime(String executionCompletedTime) {}
+
+ public String getMsoRequestId() {
+ return msoRequestId;
+ }
+
+ public void setMsoRequestId(String msoRequestId) {
+ this.msoRequestId = msoRequestId;
+ }
+
+ public String getStatusMessage() {
+ return statusMessage;
+ }
+
+ public void setStatusMessage(String statusMessage) {
+ this.statusMessage = statusMessage;
+ }
+
+ public Long getFinishTimeMillis() {
+ return finishTimeMillis;
+ }
+
+ public void setFinishTimeMillis(Long finishTimeMillis) {
+ this.finishTimeMillis = finishTimeMillis;
+ }
+
+ public Long getStartTimeMillis() {
+ return startTimeMillis;
+ }
+
+ public void setStartTimeMillis(Long startTimeMillis) {
+ this.startTimeMillis = startTimeMillis;
+ }
+
+ public Long getDispatchTimeMillis() {
+ return dispatchTimeMillis;
+ }
+
+ public void setDispatchTimeMillis(Long dispatchTimeMillis) {
+ this.dispatchTimeMillis = dispatchTimeMillis;
+ }
+
+ public Long getExecutionCompletedTimeMillis() {
+ return executionCompletedTimeMillis;
+ }
+
+ public void setExecutionCompletedTimeMillis(Long executionCompletedTimeMillis) {
+ this.executionCompletedTimeMillis = executionCompletedTimeMillis;
+ }
+
+ public String getMsoStatus() {
+ return msoStatus;
+ }
+
+ public void setMsoStatus(String msoStatus) {
+ this.msoStatus = msoStatus;
+ }
+
+ public String getMsoMessage() {
+ return msoMessage;
+ }
+
+ public void setMsoMessage(String msoMessage) {
+ this.msoMessage = msoMessage;
+ }
+
+ public Long getMsoTimeMillis() {
+ return msoTimeMillis;
+ }
+
+ public void setMsoTimeMillis(Long msoTimeMillis) {
+ this.msoTimeMillis = msoTimeMillis;
+ }
+
+ public String getMsoTime() {
+ if (msoTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(msoTimeMillis);
+ return null;
+ }
+
+ protected void setMsoTime(String msoTime) {}
+
+ public String getTmStatus() {
+ return tmStatus;
+ }
+
+ public void setTmStatus(String tmStatus) {
+ this.tmStatus = tmStatus;
+ }
+
+ public String getTmApprovalStatus() {
+ return tmApprovalStatus;
+ }
+
+ public void setTmApprovalStatus(String tmApprovalStatus) {
+ this.tmApprovalStatus = tmApprovalStatus;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/Domain.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/Domain.java
new file mode 100644
index 0000000..c7af7c5
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/Domain.java
@@ -0,0 +1,63 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Entity;
+import javax.persistence.Id;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+
+/**
+ * The persistent class for the domains database table.
+ *
+ */
+@Entity
+@Table(name = "DOMAINS")
+@NamedQuery(name = "Domain.findAll", query = "SELECT d FROM Domain d")
+public class Domain implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @Id
+ private String domain;
+
+ public Domain() {}
+
+ public String getDomain() {
+ return this.domain;
+ }
+
+ public void setDomain(String domain) {
+ this.domain = domain;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/DomainData.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/DomainData.java
new file mode 100644
index 0000000..f32ff98
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/DomainData.java
@@ -0,0 +1,104 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import io.swagger.annotations.ApiModel;
+
+/**
+ * The persistent class for the domain_data database table.
+ *
+ */
+@Entity
+@Table(name = "DOMAIN_DATA")
+@NamedQuery(name = "DomainData.findAll", query = "SELECT d FROM DomainData d")
+@ApiModel(value = "Domain data", description = "Domain specific data represented as name/value pairs")
+public class DomainData implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @JsonIgnore
+ @Id
+ @GeneratedValue
+ private int id;
+
+ private String name;
+
+ private String value;
+
+ @ManyToOne(optional = true)
+ @JoinColumn(name = "schedules_id", nullable = false, updatable = false)
+ @JsonIgnore
+ private Schedule schedule;
+
+ public DomainData() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getName() {
+ return this.name;
+ }
+
+ public void setName(String name) {
+ this.name = name;
+ }
+
+ public String getValue() {
+ return this.value;
+ }
+
+ public void setValue(String value) {
+ this.value = value;
+ }
+
+ public Schedule getSchedule() {
+ return schedule;
+ }
+
+ public void setSchedule(Schedule schedule) {
+ this.schedule = schedule;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/HelloWorld.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/HelloWorld.java
new file mode 100644
index 0000000..ed09ad7
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/HelloWorld.java
@@ -0,0 +1,58 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+public class HelloWorld {
+
+ private String message;
+
+ public HelloWorld() {
+ // needed for deserializer
+ }
+
+ public HelloWorld(String message) {
+ this.message = message;
+ }
+
+ public String getMessage() {
+ return message;
+ }
+
+ public void setMessage(String message) {
+ this.message = message;
+ }
+
+ @Override
+ public String toString() {
+ return "message = " + getMessage();
+ }
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/Schedule.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/Schedule.java
new file mode 100644
index 0000000..3a13563
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/Schedule.java
@@ -0,0 +1,360 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import java.util.ArrayList;
+import java.util.List;
+import javax.persistence.CascadeType;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.Lob;
+import javax.persistence.NamedQuery;
+import javax.persistence.OneToMany;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import org.hibernate.annotations.LazyCollection;
+import org.hibernate.annotations.LazyCollectionOption;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import io.swagger.annotations.ApiModelProperty;
+
+/**
+ * The persistent class for the schedules database table.
+ *
+ */
+@Entity
+@Table(name = "SCHEDULES")
+@NamedQuery(name = "Schedule.findAll", query = "SELECT s FROM Schedule s")
+public class Schedule implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @JsonIgnore
+ @Id
+ @GeneratedValue
+ private int id;
+
+ @JsonIgnore
+ @Column(name = "create_date_time")
+ private Long createDateTimeMillis;
+
+ @ApiModelProperty(value = "Date/time schedule was created.")
+ @JsonProperty
+ @Transient
+ private String createDateTime;
+
+ @ApiModelProperty(value = "Date/time optimizer was invoked.")
+ @JsonIgnore
+ @Column(name = "optimizer_date_time")
+ private Long optimizerDateTimeMillis;
+
+ @JsonProperty
+ @Transient
+ private String optimizerDateTime;
+
+ @Lob
+ @Column(name = "optimizer_message")
+ private String optimizerMessage;
+
+ @Column(name = "optimizer_status")
+ private String optimizerStatus;
+
+ @JsonIgnore
+ @Column(name = "optimizer_attempts_to_schedule")
+ private int optimizerAttemptsToSchedule;
+
+ @JsonIgnore
+ @Column(name = "optimizer_return_date_time")
+ private Long optimizerReturnDateTimeMillis;
+
+ @JsonProperty
+ @Transient
+ private String optimizerReturnDateTime;
+
+ @Column(name = "optimizer_transaction_id")
+ private String optimizerTransactionId;
+
+ @Lob
+ @Column(name = "schedule")
+ private String schedule;
+
+ @JsonIgnore
+ @Column(name = "schedule_id")
+ private String scheduleId;
+
+ @Column(name = "schedule_name")
+ private String scheduleName;
+
+ @Lob
+ @Column(name = "schedule_info")
+ private String scheduleInfo;
+
+ @Column(name = "status")
+ private String status;
+
+ @Column(name = "user_id")
+ private String userId;
+
+ @Column(name = "domain")
+ private String domain;
+
+ @JsonIgnore
+ @Column(name = "delete_date_time")
+ private Long deleteDateTimeMillis;
+
+ @JsonProperty
+ @Transient
+ private String deleteDateTime;
+
+ @OneToMany(cascade = CascadeType.ALL, orphanRemoval = true, mappedBy = "schedule")
+ @LazyCollection(value = LazyCollectionOption.FALSE)
+ // @JoinColumn(name="schedules_id")
+ private List<DomainData> domainData;
+ //
+ // //uni-directional many-to-one association to ScheduleApproval
+ @OneToMany(cascade = CascadeType.ALL, orphanRemoval = true, mappedBy = "schedule")
+ @LazyCollection(value = LazyCollectionOption.FALSE)
+ private List<ScheduleApproval> scheduleApprovals;
+ //
+ // //bi-directional many-to-one association to Domain
+ // @ManyToOne
+ // @JoinColumn(name="domain")
+ // private Domain domainBean;
+
+ @JsonProperty
+ @Transient
+ List<ChangeManagementGroup> groups;
+
+ public Schedule() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getCreateDateTime() {
+ if (createDateTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.createDateTimeMillis);
+ return null;
+ }
+
+ public void setCreateDateTime(String datetime) {
+ // only set time via setCreateDateTimeMillis
+ }
+
+ public void setCreateDateTimeMillis(Long millis) {
+ this.createDateTimeMillis = millis;
+ }
+
+ public long getCreateDateTimeMillis() {
+ return this.createDateTimeMillis;
+ }
+
+ public Long getDeleteDateTimeMillis() {
+ return deleteDateTimeMillis;
+ }
+
+ public void setDeleteDateTimeMillis(Long deleteDateTimeMillis) {
+ this.deleteDateTimeMillis = deleteDateTimeMillis;
+ }
+
+ public String getDeleteDateTime() {
+ if (deleteDateTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.deleteDateTimeMillis);
+ return null;
+ }
+
+ public void setDeleteDateTime(String deleteDateTime) {}
+
+ public String getOptimizerDateTime() {
+ if (optimizerDateTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.optimizerDateTimeMillis);
+ return null;
+ }
+
+ public void setOptimizerDateTime(String optimizerDateTime) {}
+
+ public String getOptimizerMessage() {
+ return this.optimizerMessage;
+ }
+
+ public void setOptimizerMessage(String optimizerMessage) {
+ this.optimizerMessage = optimizerMessage;
+ }
+
+ public String getOptimizerStatus() {
+ return this.optimizerStatus;
+ }
+
+ public void setOptimizerStatus(String optimizerStatus) {
+ this.optimizerStatus = optimizerStatus;
+ }
+
+ public String getSchedule() {
+ return this.schedule;
+ }
+
+ public void setSchedule(String schedule) {
+ this.schedule = schedule;
+ }
+
+ public String getScheduleId() {
+ return this.scheduleId;
+ }
+
+ public void setScheduleId(String scheduleId) {
+ this.scheduleId = scheduleId;
+ }
+
+ public String getScheduleName() {
+ return this.scheduleName;
+ }
+
+ public void setScheduleName(String scheduleName) {
+ this.scheduleName = scheduleName;
+ }
+
+ public String getScheduleInfo() {
+ return this.scheduleInfo;
+ }
+
+ public void setScheduleInfo(String scheduleInfo) {
+ this.scheduleInfo = scheduleInfo;
+ }
+
+ public String getStatus() {
+ return this.status;
+ }
+
+ public void setStatus(String status) {
+ this.status = status;
+ }
+
+ public String getUserId() {
+ return this.userId;
+ }
+
+ public void setUserId(String userId) {
+ this.userId = userId;
+ }
+
+ public String getDomain() {
+ return domain;
+ }
+
+ public void setDomain(String domain) {
+ this.domain = domain;
+ }
+
+ public List<DomainData> getDomainData() {
+ return domainData;
+ }
+
+ public List<ScheduleApproval> getScheduleApprovals() {
+ return scheduleApprovals;
+ }
+
+ public DomainData addDomainData(DomainData domainData) {
+ List<DomainData> list = getDomainData();
+ if (list == null)
+ list = new ArrayList<DomainData>();
+ list.add(domainData);
+ domainData.setSchedule(this);
+ return domainData;
+ }
+
+ public ScheduleApproval addScheduleApproval(ScheduleApproval sa) {
+ List<ScheduleApproval> list = getScheduleApprovals();
+ if (list == null)
+ list = new ArrayList<ScheduleApproval>();
+ list.add(sa);
+ sa.setSchedule(this);
+ return sa;
+ }
+
+ public int getOptimizerAttemptsToSchedule() {
+ return optimizerAttemptsToSchedule;
+ }
+
+ public void setOptimizerAttemptsToSchedule(int optimizerAttemptsToSchedule) {
+ this.optimizerAttemptsToSchedule = optimizerAttemptsToSchedule;
+ }
+
+ public String getOptimizerReturnDateTime() {
+ if (optimizerReturnDateTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.optimizerReturnDateTimeMillis);
+ return null;
+ }
+
+ public void setOptimizerReturnDateTime(String optimizerReturnDateTime) {
+
+ }
+
+ public String getOptimizerTransactionId() {
+ return optimizerTransactionId;
+ }
+
+ public void setOptimizerTransactionId(String optimizerTransactionId) {
+ this.optimizerTransactionId = optimizerTransactionId;
+ }
+
+ public Long getOptimizerDateTimeMillis() {
+ return optimizerDateTimeMillis;
+ }
+
+ public void setOptimizerDateTimeMillis(Long optimizerDateTimeMillis) {
+ this.optimizerDateTimeMillis = optimizerDateTimeMillis;
+ }
+
+ public Long getOptimizerReturnDateTimeMillis() {
+ return optimizerReturnDateTimeMillis;
+ }
+
+ public void setOptimizerReturnDateTimeMillis(Long optimizerReturnDateTimeMillis) {
+ this.optimizerReturnDateTimeMillis = optimizerReturnDateTimeMillis;
+ }
+
+ public List<ChangeManagementGroup> getGroups() {
+ return groups;
+ }
+
+ public void setGroups(List<ChangeManagementGroup> groups) {
+ this.groups = groups;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleApproval.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleApproval.java
new file mode 100644
index 0000000..adfafd1
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleApproval.java
@@ -0,0 +1,150 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+
+/**
+ * The persistent class for the schedule_approvals database table.
+ *
+ */
+@Entity
+@Table(name = "SCHEDULE_APPROVALS")
+@NamedQuery(name = "ScheduleApproval.findAll", query = "SELECT s FROM ScheduleApproval s")
+@ApiModel(value = "Schedule Approval", description = "Details of a schedule approval/rejection.")
+public class ScheduleApproval implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @Id
+ @GeneratedValue
+ @JsonIgnore
+ private int id;
+
+ @JsonIgnore
+ @Column(name = "approval_date_time")
+ private Long approvalDateTimeMillis;
+
+ @ApiModelProperty(value = "Date/time schedule time slot was accepted/rejected.")
+ @JsonProperty
+ @Transient
+ private String approvalDateTime;
+
+ @ApiModelProperty(value = "Approval status.", allowableValues = "Accepted,Rejected")
+ @Column(name = "status")
+ private String status;
+
+ @ApiModelProperty(value = "ATTUID of the user accepting/rejecting the time slot.")
+ @Column(name = "user_id")
+ private String userId;
+
+ @ManyToOne(optional = true)
+ @JoinColumn(name = "schedules_id", nullable = false, updatable = false)
+ @JsonIgnore
+ private Schedule schedule;
+
+ @JsonIgnore
+ @Column(name = "approval_type_id")
+ private Integer approvalTypeId;
+
+ public ScheduleApproval() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getApprovalDateTime() {
+ if (approvalDateTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.approvalDateTimeMillis);
+ return null;
+ }
+
+ public void setApprovalDateTime(String approvalDateTime) {}
+
+ public String getStatus() {
+ return this.status;
+ }
+
+ public void setStatus(String status) {
+ this.status = status;
+ }
+
+ public String getUserId() {
+ return this.userId;
+ }
+
+ public void setUserId(String userId) {
+ this.userId = userId;
+ }
+
+ public Integer getApprovalTypeId() {
+ return approvalTypeId;
+ }
+
+ public void setApprovalTypeId(Integer approvalTypeId) {
+ this.approvalTypeId = approvalTypeId;
+ }
+
+ public void setSchedule(Schedule schedule) {
+ this.schedule = schedule;
+ }
+
+ public Schedule getSchedule() {
+ return schedule;
+ }
+
+ public Long getApprovalDateTimeMillis() {
+ return approvalDateTimeMillis;
+ }
+
+ public void setApprovalDateTimeMillis(Long approvalDateTimeMillis) {
+ this.approvalDateTimeMillis = approvalDateTimeMillis;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleEvent.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleEvent.java
new file mode 100644
index 0000000..97a96f0
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleEvent.java
@@ -0,0 +1,160 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import java.io.Serializable;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.Id;
+import javax.persistence.Lob;
+import javax.persistence.NamedQuery;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import org.joda.time.format.ISODateTimeFormat;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+
+/**
+ * The persistent class for the schedule_events database table.
+ *
+ */
+@Entity
+@Table(name = "SCHEDULE_EVENTS")
+@NamedQuery(name = "ScheduleEvent.findAll", query = "SELECT s FROM ScheduleEvent s")
+public class ScheduleEvent implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ @Id
+ private int id;
+
+ private String domain;
+
+ @Lob
+ @Column(name = "event_text")
+ private String eventText;
+
+ @JsonIgnore
+ @Column(name = "event_time")
+ private Long eventTimeMillis;
+
+ @JsonProperty
+ @Transient
+ private String eventTime;
+
+ @JsonIgnore
+ @Column(name = "reminder_time")
+ private Long reminderTimeMillis;
+
+ @JsonProperty
+ @Transient
+ private String reminderTime;
+
+ @Column(name = "schedules_id")
+ private int schedulesId;
+
+ private String status;
+
+ public ScheduleEvent() {}
+
+ public int getId() {
+ return this.id;
+ }
+
+ public void setId(int id) {
+ this.id = id;
+ }
+
+ public String getDomain() {
+ return this.domain;
+ }
+
+ public void setDomain(String domain) {
+ this.domain = domain;
+ }
+
+ public String getEventText() {
+ return this.eventText;
+ }
+
+ public void setEventText(String eventText) {
+ this.eventText = eventText;
+ }
+
+ public int getSchedulesId() {
+ return this.schedulesId;
+ }
+
+ public void setSchedulesId(int schedulesId) {
+ this.schedulesId = schedulesId;
+ }
+
+ public String getStatus() {
+ return this.status;
+ }
+
+ public void setStatus(String status) {
+ this.status = status;
+ }
+
+ public Long getEventTimeMillis() {
+ return eventTimeMillis;
+ }
+
+ public void setEventTimeMillis(Long eventTimeMillis) {
+ this.eventTimeMillis = eventTimeMillis;
+ }
+
+ public String getEventTime() {
+ if (eventTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.eventTimeMillis);
+ return null;
+ }
+
+ public void setEventTime(String eventTime) {}
+
+ public Long getReminderTimeMillis() {
+ return reminderTimeMillis;
+ }
+
+ public void setReminderTimeMillis(Long reminderTimeMillis) {
+ this.reminderTimeMillis = reminderTimeMillis;
+ }
+
+ public String getReminderTime() {
+ if (reminderTimeMillis != null)
+ return ISODateTimeFormat.dateTimeNoMillis().print(this.reminderTimeMillis);
+ return null;
+ }
+
+ public void setReminderTime(String reminderTime) {}
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleQuery.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleQuery.java
new file mode 100644
index 0000000..84d3e5c
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/ScheduleQuery.java
@@ -0,0 +1,52 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model;
+
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.Id;
+
+@Entity
+public class ScheduleQuery {
+ @Id
+ @Column(name = "id")
+ private Integer id;
+
+ public Integer getId() {
+ return id;
+ }
+
+ public void setId(Integer id) {
+ this.id = id;
+ }
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ApprovalTypeDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ApprovalTypeDAO.java
new file mode 100644
index 0000000..7eb2430
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ApprovalTypeDAO.java
@@ -0,0 +1,52 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import java.util.Optional;
+import org.onap.optf.cmso.model.ApprovalType;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ApprovalTypeDAO extends PagingAndSortingRepository<ApprovalType, Integer> {
+ Optional<ApprovalType> findById(Integer id);
+
+ ApprovalType save(ApprovalType persisted);
+
+ void delete(ApprovalType toDelete);
+
+ @Query(value = "SELECT d FROM ApprovalType d WHERE d.domain = ?1 AND d.approvalType = ?2")
+ ApprovalType findByDomainAndType(String domain, String type);
+
+ @Query(value = "SELECT d FROM ApprovalType d WHERE d.domain = ?1")
+ List<ApprovalType> findByDomain(String domain);
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementChangeWindowDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementChangeWindowDAO.java
new file mode 100644
index 0000000..293209e
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementChangeWindowDAO.java
@@ -0,0 +1,56 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import java.util.Optional;
+import org.onap.optf.cmso.model.ChangeManagementChangeWindow;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ChangeManagementChangeWindowDAO
+ extends PagingAndSortingRepository<ChangeManagementChangeWindow, Integer> {
+ Optional<ChangeManagementChangeWindow> findById(Integer id);
+
+ ChangeManagementChangeWindow save(ChangeManagementChangeWindow persisted);
+
+ void delete(ChangeManagementChangeWindow toDelete);
+
+ @Query(value = "SELECT d FROM ChangeManagementChangeWindow d WHERE d.changeManagementGroupsId = ?1")
+ List<ChangeManagementChangeWindow> findByGroupsID(Integer id);
+
+ @Modifying
+ @Query(value = "DELETE FROM ChangeManagementChangeWindow d WHERE d.changeManagementGroupsId = ?1")
+ int deleteByChangeManagementGroupId(int id);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAO.java
new file mode 100644
index 0000000..7dabf5e
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAO.java
@@ -0,0 +1,41 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import org.onap.optf.cmso.model.ChangeManagementDetail;
+
+public interface ChangeManagementDetailDAO {
+
+ List<ChangeManagementDetail> searchScheduleDetails(String where, int limit);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAOImpl.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAOImpl.java
new file mode 100644
index 0000000..2c083d6
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementDetailDAOImpl.java
@@ -0,0 +1,75 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import javax.persistence.Query;
+import org.onap.optf.cmso.model.ChangeManagementDetail;
+import org.springframework.stereotype.Repository;
+
+@Repository
+public class ChangeManagementDetailDAOImpl implements ChangeManagementDetailDAO {
+ @PersistenceContext
+ private EntityManager manager;
+
+ @Override
+ public List<ChangeManagementDetail> searchScheduleDetails(String where, int limit) {
+ StringBuilder sql = new StringBuilder();
+ sql.append("select distinct" + " s.id as id," + " s.vnf_name as vnf_name," + " s.vnf_id as vnf_id,"
+ + " s.status as status," + " s.tm_change_id as tm_change_Id," + " s.start_time as start_time,"
+ + " s.finish_time as finish_time," + " s.mso_request_id as mso_request_id,"
+ + " s.mso_status as mso_status," + " s.mso_message as mso_message," + " s.mso_time as mso_time,"
+ + " s.dispatch_time as dispatch_time," + " s.execution_completed_time as execution_completed_time,"
+ + " s.status_message as status_message," + " s.tm_approval_status as tm_approval_status,"
+ + " s.tm_status as tm_status," + " g.group_id as group_id,"
+ + " g.last_instance_start_time as last_instance_start_time," + " g.policy_id as policy_id,"
+ + " g.schedules_id as schedules_id"
+ // + " ss.schedule_id as scheduleId,"
+ // + " dd.name"
+ + " from" + " CHANGE_MANAGEMENT_SCHEDULES s"
+ + " inner join CHANGE_MANAGEMENT_GROUPS g on s.change_management_groups_id = g.id"
+ + " inner join SCHEDULES ss on g.schedules_id = ss.id "
+ + " left outer join DOMAIN_DATA dd on ss.id = dd.schedules_id"
+ + " left outer join SCHEDULE_APPROVALS sa on ss.id = sa.schedules_id"
+ + " left outer join APPROVAL_TYPES at on sa.approval_type_id = at.id ");
+ sql.append(where);
+ sql.append(" order by id ");
+ if (limit > 0)
+ sql.append("LIMIT " + limit);
+
+ Query q = manager.createNativeQuery(sql.toString(), ChangeManagementDetail.class);
+ List<ChangeManagementDetail> list = q.getResultList();
+ return list;
+ }
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementGroupDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementGroupDAO.java
new file mode 100644
index 0000000..39f4baa
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementGroupDAO.java
@@ -0,0 +1,53 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import java.util.Optional;
+import org.onap.optf.cmso.model.ChangeManagementGroup;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ChangeManagementGroupDAO extends PagingAndSortingRepository<ChangeManagementGroup, Integer> {
+ Optional<ChangeManagementGroup> findById(Integer id);
+
+ ChangeManagementGroup save(ChangeManagementGroup persisted);
+
+ void delete(ChangeManagementGroup toDelete);
+
+ @Query(value = "SELECT d FROM ChangeManagementGroup d WHERE d.schedulesId = ?1")
+ List<ChangeManagementGroup> findBySchedulesID(Integer id);
+
+ @Query(value = "SELECT d FROM ChangeManagementGroup d WHERE d.schedulesId = ?1 AND d.groupId = ?2")
+ ChangeManagementGroup findOneBySchedulesIDGroupID(Integer id, String groupId);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementScheduleDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementScheduleDAO.java
new file mode 100644
index 0000000..a089c2b
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ChangeManagementScheduleDAO.java
@@ -0,0 +1,77 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import java.util.Optional;
+import javax.persistence.LockModeType;
+import org.onap.optf.cmso.model.ChangeManagementSchedule;
+import org.springframework.data.jpa.repository.Lock;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ChangeManagementScheduleDAO extends PagingAndSortingRepository<ChangeManagementSchedule, Integer> {
+ Optional<ChangeManagementSchedule> findById(Integer id);
+
+ ChangeManagementSchedule save(ChangeManagementSchedule persisted);
+
+ void delete(ChangeManagementSchedule toDelete);
+
+ @Query(value = "SELECT d FROM ChangeManagementSchedule d WHERE d.changeManagementGroupsId = ?1")
+ List<ChangeManagementSchedule> findByChangeManagementGroupId(Integer id);
+
+ @Modifying
+ @Query(value = "DELETE FROM ChangeManagementSchedule d WHERE d.changeManagementGroupsId = ?1")
+ public int deleteByChangeManagementGroupsId(Integer id);
+
+ @Query(value = "SELECT d FROM ChangeManagementSchedule d WHERE d.changeManagementGroupsId = ?1 AND d.vnfName = ?2")
+ ChangeManagementSchedule findOneByGroupIDAndVnfName(Integer id, String vnfName);
+
+ @Query(value = "SELECT d FROM ChangeManagementSchedule d WHERE (d.status = ?1 AND d.startTimeMillis <= ?2) or d.status = 'Scheduled Immediate' order by d.startTimeMillis")
+ List<ChangeManagementSchedule> findByStatusAndEndTime(String status, Long date);
+
+ @Modifying
+ @Query(value = "Update ChangeManagementSchedule d set d.status = 'Scheduled', d.dispatcherInstance = '' WHERE d.status = 'Queued for Dispatch' AND d.dispatcherInstance = ?1")
+ public int requeueQueuedForDispatch(String dispatcherInstance);
+
+ @Query(value = "SELECT d FROM ChangeManagementSchedule d WHERE d.status = 'Triggered'")
+ List<ChangeManagementSchedule> findAllTriggered();
+
+ @Query(value = "SELECT d FROM ChangeManagementSchedule d WHERE d.tmApprovalStatus = 'Pending Approval'")
+ List<ChangeManagementSchedule> findAllAwaitingTmApproval();
+
+ @Query(value = "SELECT d FROM ChangeManagementSchedule d WHERE d.id = ?1")
+ @Lock(LockModeType.PESSIMISTIC_WRITE)
+ ChangeManagementSchedule lockOne(Integer id);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/DomainDataDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/DomainDataDAO.java
new file mode 100644
index 0000000..9556938
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/DomainDataDAO.java
@@ -0,0 +1,45 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.Optional;
+import org.onap.optf.cmso.model.DomainData;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface DomainDataDAO extends PagingAndSortingRepository<DomainData, Integer> {
+ Optional<DomainData> findById(Integer id);
+
+ DomainData save(DomainData persisted);
+
+ void delete(DomainData toDelete);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleApprovalDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleApprovalDAO.java
new file mode 100644
index 0000000..d9badd0
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleApprovalDAO.java
@@ -0,0 +1,45 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.Optional;
+import org.onap.optf.cmso.model.ScheduleApproval;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ScheduleApprovalDAO extends PagingAndSortingRepository<ScheduleApproval, Integer> {
+ Optional<ScheduleApproval> findById(Integer id);
+
+ ScheduleApproval save(ScheduleApproval persisted);
+
+ void delete(ScheduleApproval toDelete);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleDAO.java
new file mode 100644
index 0000000..f68fd22
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleDAO.java
@@ -0,0 +1,69 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import java.util.Optional;
+import javax.persistence.LockModeType;
+import org.onap.optf.cmso.model.Schedule;
+import org.springframework.data.jpa.repository.Lock;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ScheduleDAO extends PagingAndSortingRepository<Schedule, Integer> {
+ Optional<Schedule> findById(Integer id);
+
+ Schedule save(Schedule persited);
+
+ void delete(Schedule toDelete);
+
+ @Query(value = "SELECT s FROM Schedule s WHERE s.domain = ?1 AND s.scheduleId= ?2 ")
+ Schedule findByDomainScheduleID(String domain, String scheduleId);
+
+ @Query(value = "SELECT s FROM Schedule s WHERE s.domain = ?1 AND s.status = ?2 ")
+ List<Schedule> findByDomainStatus(String domain, String Status);
+
+ @Query(value = "SELECT s FROM Schedule s WHERE s.optimizerTransactionId= ?1")
+ Schedule findOneByTransactionId(String transactionId);
+
+ @Query(value = "SELECT s FROM Schedule s WHERE s.domain = ?1 AND s.status = 'Notifications Initiated'")
+ List<Schedule> findAllInProgress(String string);
+
+ @Query(value = "SELECT d FROM Schedule d WHERE d.id = ?1")
+ @Lock(LockModeType.PESSIMISTIC_WRITE)
+ Schedule lockOne(Integer id);
+
+ @Query(value = "SELECT s FROM Schedule s WHERE s.optimizerTransactionId= ?1")
+ @Lock(LockModeType.PESSIMISTIC_WRITE)
+ Schedule lockOneByTransactionId(String transactionId);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleEventDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleEventDAO.java
new file mode 100644
index 0000000..c3c2483
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleEventDAO.java
@@ -0,0 +1,53 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import java.util.Optional;
+import org.onap.optf.cmso.model.ScheduleEvent;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.PagingAndSortingRepository;
+
+public interface ScheduleEventDAO extends PagingAndSortingRepository<ScheduleEvent, Integer> {
+ Optional<ScheduleEvent> findById(Integer id);
+
+ ScheduleEvent save(ScheduleEvent persisted);
+
+ void delete(ScheduleEvent toDelete);
+
+ @Query(value = "SELECT d FROM ScheduleEvent d WHERE d.schedulesId = ?1")
+ List<ScheduleEvent> findByScheduleId(Integer id);
+
+ @Query(value = "SELECT d FROM ScheduleEvent d WHERE d.status = ?1 AND d.reminderTimeMillis <= ?2")
+ List<ScheduleEvent> findByStatusAndEndTime(String status, Long date);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAO.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAO.java
new file mode 100644
index 0000000..f974eb5
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAO.java
@@ -0,0 +1,41 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import org.onap.optf.cmso.model.ScheduleQuery;
+
+public interface ScheduleQueryDAO {
+
+ List<ScheduleQuery> searchSchedules(String where, int limit);
+
+}
diff --git a/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAOImpl.java b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAOImpl.java
new file mode 100644
index 0000000..37fbf52
--- /dev/null
+++ b/cmso-service/src/main/java/org/onap/optf/cmso/model/dao/ScheduleQueryDAOImpl.java
@@ -0,0 +1,64 @@
+/*
+ * Copyright © 2017-2018 AT&T Intellectual Property.
+ * Modifications Copyright © 2018 IBM.
+ *
+ * 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.
+ *
+ *
+ * Unless otherwise specified, all documentation contained herein is licensed
+ * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+ * you may not use this documentation except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * https://creativecommons.org/licenses/by/4.0/
+ *
+ * Unless required by applicable law or agreed to in writing, documentation
+ * 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.
+*/
+
+package org.onap.optf.cmso.model.dao;
+
+import java.util.List;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import javax.persistence.Query;
+import org.onap.optf.cmso.model.ScheduleQuery;
+import org.springframework.stereotype.Repository;
+
+@Repository
+public class ScheduleQueryDAOImpl implements ScheduleQueryDAO {
+ @PersistenceContext
+ private EntityManager manager;
+
+ @Override
+ public List<ScheduleQuery> searchSchedules(String where, int limit) {
+ StringBuilder sql = new StringBuilder();
+ sql.append("select distinct" + " ss.id as id" + " from" + " SCHEDULES ss"
+ + " left outer join CHANGE_MANAGEMENT_GROUPS g on ss.id = g.schedules_id"
+ + " left outer join CHANGE_MANAGEMENT_SCHEDULES s on g.id = s.change_management_groups_id"
+ + " left outer join DOMAIN_DATA dd on ss.id = dd.schedules_id"
+ + " left outer join SCHEDULE_APPROVALS sa on ss.id = sa.schedules_id"
+ + " left outer join APPROVAL_TYPES at on sa.approval_type_id = at.id ");
+ sql.append(where);
+ sql.append(" order by id ");
+ if (limit > 0)
+ sql.append("LIMIT " + limit);
+
+ Query q = manager.createNativeQuery(sql.toString(), ScheduleQuery.class);
+ List<ScheduleQuery> list = q.getResultList();
+ return list;
+ }
+}