2 * ============LICENSE_START=======================================================
4 * ================================================================================
5 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
6 * ================================================================================
7 * Licensed under the Apache License, Version 2.0 (the "License");
8 * you may not use this file except in compliance with the License.
9 * You may obtain a copy of the License at
11 * http://www.apache.org/licenses/LICENSE-2.0
13 * Unless required by applicable law or agreed to in writing, software
14 * distributed under the License is distributed on an "AS IS" BASIS,
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 * See the License for the specific language governing permissions and
17 * limitations under the License.
18 * ============LICENSE_END=========================================================
21 package org.openecomp.mso.adapters.requestsdb;
23 import java.sql.Timestamp;
24 import java.util.List;
26 import javax.jws.WebService;
28 import org.openecomp.mso.requestsdb.SiteStatus;
29 import org.openecomp.mso.utils.UUIDChecker;
30 import org.hibernate.HibernateException;
31 import org.hibernate.Query;
32 import org.hibernate.Session;
34 import org.openecomp.mso.adapters.requestsdb.exceptions.MsoRequestsDbException;
35 import org.openecomp.mso.logger.MessageEnum;
36 import org.openecomp.mso.logger.MsoLogger;
37 import org.openecomp.mso.db.HibernateUtils;
38 import org.openecomp.mso.requestsdb.HibernateUtilsRequestsDb;
39 import org.openecomp.mso.requestsdb.InfraActiveRequests;
41 @WebService(serviceName = "RequestsDbAdapter", endpointInterface = "org.openecomp.mso.adapters.requestsdb.MsoRequestsDbAdapter", targetNamespace = "http://org.openecomp.mso/requestsdb")
42 public class MsoRequestsDbAdapterImpl implements MsoRequestsDbAdapter {
44 protected HibernateUtils hibernateUtils = new HibernateUtilsRequestsDb ();
46 private static MsoLogger LOGGER = MsoLogger.getMsoLogger (MsoLogger.Catalog.RA);
49 public void updateInfraRequest (String requestId,
50 String lastModifiedBy,
53 RequestStatusType requestStatus,
56 String serviceInstanceId,
61 String serviceInstanceName) throws MsoRequestsDbException {
62 MsoLogger.setLogContext (requestId, null);
63 Session session = hibernateUtils.getSessionFactory ().openSession ();
65 long startTime = System.currentTimeMillis ();
67 session.beginTransaction ();
68 String queryString = "update InfraActiveRequests set ";
69 if (statusMessage != null) {
70 queryString += "statusMessage = :statusMessage, ";
72 if (responseBody != null) {
73 queryString += "responseBody = :responseBody, ";
75 if (requestStatus != null) {
76 queryString += "requestStatus = :requestStatus, ";
78 if (progress != null) {
79 queryString += "progress = :progress, ";
81 if (vnfOutputs != null) {
82 queryString += "vnfOutputs = :vnfOutputs, ";
84 if (serviceInstanceId != null) {
85 queryString += "serviceInstanceId = :serviceInstanceId, ";
87 if (networkId != null) {
88 queryString += "networkId = :networkId, ";
91 queryString += "vnfId = :vnfId, ";
93 if (vfModuleId != null) {
94 queryString += "vfModuleId = :vfModuleId, ";
96 if (volumeGroupId != null) {
97 queryString += "volumeGroupId = :volumeGroupId, ";
99 if (serviceInstanceName != null) {
100 queryString += "serviceInstanceName = :serviceInstanceName, ";
102 if (requestStatus == RequestStatusType.COMPLETE || requestStatus == RequestStatusType.FAILED) {
103 queryString += "endTime = :endTime, ";
105 queryString += "modifyTime = :modifyTime, ";
107 queryString += "lastModifiedBy = :lastModifiedBy where requestId = :requestId OR clientRequestId = :requestId";
109 LOGGER.debug("Executing update: " + queryString);
111 Query query = session.createQuery (queryString);
112 query.setParameter ("requestId", requestId);
113 if (statusMessage != null) {
114 query.setParameter ("statusMessage", statusMessage);
115 LOGGER.debug ("StatusMessage in updateInfraRequest is set to: " + statusMessage);
117 if (responseBody != null) {
118 query.setParameter ("responseBody", responseBody);
119 LOGGER.debug ("ResponseBody in updateInfraRequest is set to: " + responseBody);
121 if (requestStatus != null) {
122 query.setParameter ("requestStatus", requestStatus.toString ());
123 LOGGER.debug ("RequestStatus in updateInfraRequest is set to: " + requestStatus.toString());
126 if (progress != null) {
127 query.setParameter ("progress", Long.parseLong (progress));
128 LOGGER.debug ("Progress in updateInfraRequest is set to: " + progress);
130 if (vnfOutputs != null) {
131 query.setParameter ("vnfOutputs", vnfOutputs);
132 LOGGER.debug ("VnfOutputs in updateInfraRequest is set to: " + vnfOutputs);
134 if (serviceInstanceId != null) {
135 query.setParameter ("serviceInstanceId", serviceInstanceId);
136 LOGGER.debug ("ServiceInstanceId in updateInfraRequest is set to: " + serviceInstanceId);
138 if (networkId != null) {
139 query.setParameter ("networkId", networkId);
140 LOGGER.debug ("NetworkId in updateInfraRequest is set to: " + networkId);
143 query.setParameter ("vnfId", vnfId);
144 LOGGER.debug ("VnfId in updateInfraRequest is set to: " + vnfId);
146 if (vfModuleId != null) {
147 query.setParameter ("vfModuleId", vfModuleId);
148 LOGGER.debug ("vfModuleId in updateInfraRequest is set to: " + vfModuleId);
150 if (volumeGroupId != null) {
151 query.setParameter ("volumeGroupId", volumeGroupId);
152 LOGGER.debug ("VolumeGroupId in updateInfraRequest is set to: " + volumeGroupId);
154 if (serviceInstanceName != null) {
155 query.setParameter ("serviceInstanceName", serviceInstanceName);
156 LOGGER.debug ("ServiceInstanceName in updateInfraRequest is set to: " + serviceInstanceName);
158 Timestamp nowTimeStamp = new Timestamp (System.currentTimeMillis ());
159 if (requestStatus == RequestStatusType.COMPLETE || requestStatus == RequestStatusType.FAILED) {
160 query.setParameter ("endTime", nowTimeStamp);
161 LOGGER.debug ("EndTime in updateInfraRequest is set to: " + nowTimeStamp);
163 query.setParameter ("modifyTime", nowTimeStamp);
164 LOGGER.debug ("ModifyTime in updateInfraRequest is set to: " + nowTimeStamp);
166 query.setParameter ("lastModifiedBy", lastModifiedBy);
167 LOGGER.debug ("LastModifiedBy in updateInfraRequest is set to: " + lastModifiedBy);
168 result = query.executeUpdate ();
169 checkIfExists (result, requestId, startTime);
170 session.getTransaction ().commit ();
171 } catch (HibernateException e) {
172 String error = "Unable to update MSO Requests DB: " + e.getMessage ();
173 LOGGER.error (MessageEnum.RA_CANT_UPDATE_REQUEST, "infra request parameters", requestId, "", "", MsoLogger.ErrorCode.BusinessProcesssError, "HibernateException - " + error, e);
174 LOGGER.recordAuditEvent (startTime, MsoLogger.StatusCode.ERROR, MsoLogger.ResponseCode.DBAccessError, error);
175 throw new MsoRequestsDbException (error, e);
177 if (session != null && session.isOpen ()) {
181 LOGGER.recordAuditEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc, "Successful");
185 private void checkIfExists (int result, String requestId, long startTime) throws MsoRequestsDbException {
187 String error = "Request ID does not exist in MSO Requests DB: " + requestId;
188 LOGGER.error (MessageEnum.RA_DB_REQUEST_NOT_EXIST, requestId, "", "", MsoLogger.ErrorCode.DataError, error);
189 throw new MsoRequestsDbException (error);
195 public InfraActiveRequests getInfraRequest (String requestId) throws MsoRequestsDbException {
196 long startTime = System.currentTimeMillis ();
197 MsoLogger.setLogContext (requestId, null);
198 Session session = hibernateUtils.getSessionFactory ().openSession ();
200 LOGGER.debug ("Call to MSO Infra RequestsDb adapter get method with request Id: " + requestId);
202 InfraActiveRequests request = null;
204 session.beginTransaction ();
205 Query query = session.createQuery ("FROM InfraActiveRequests where requestId = :requestId OR clientRequestId = :requestId");
206 query.setParameter ("requestId", requestId);
207 request = (InfraActiveRequests) query.uniqueResult();
208 } catch (HibernateException e) {
209 String error = "Unable to retrieve MSO Infra Requests DB for Request ID "
211 LOGGER.error (MessageEnum.RA_DB_REQUEST_NOT_EXIST, "Get Infra request", requestId, "", "", MsoLogger.ErrorCode.BusinessProcesssError, "HibernateException - " + error, e);
212 LOGGER.recordAuditEvent (startTime, MsoLogger.StatusCode.ERROR, MsoLogger.ResponseCode.DBAccessError, error);
213 throw new MsoRequestsDbException (error, e);
215 if (session != null && session.isOpen ()) {
219 LOGGER.recordAuditEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc, "Successful");
225 * Get SiteStatus by SiteName.
227 * @param siteName The unique name of the site
228 * @return Status of that site
230 public boolean getSiteStatus (String siteName) {
231 UUIDChecker.generateUUID (LOGGER);
232 Session session = hibernateUtils.getSessionFactory ().openSession ();
234 long startTime = System.currentTimeMillis ();
235 SiteStatus siteStatus = null;
236 LOGGER.debug ("Request database - get Site Status with Site name:" + siteName);
238 String hql = "FROM SiteStatus WHERE siteName = :site_name";
239 Query query = session.createQuery (hql);
240 query.setParameter ("site_name", siteName);
242 siteStatus = (SiteStatus) query.uniqueResult ();
244 if (session != null && session.isOpen ()) {
248 if (siteStatus == null) {
249 // if not exist in DB, it means the site is not disabled, thus return true
250 LOGGER.recordAuditEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc, "Successful");
253 LOGGER.recordAuditEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc, "Successful");
254 return siteStatus.getStatus();