2 * ============LICENSE_START=======================================================
\r
4 * ================================================================================
\r
5 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
\r
6 * ================================================================================
\r
7 * Licensed under the Apache License, Version 2.0 (the "License");
\r
8 * you may not use this file except in compliance with the License.
\r
9 * You may obtain a copy of the License at
\r
11 * http://www.apache.org/licenses/LICENSE-2.0
\r
13 * Unless required by applicable law or agreed to in writing, software
\r
14 * distributed under the License is distributed on an "AS IS" BASIS,
\r
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
16 * See the License for the specific language governing permissions and
\r
17 * limitations under the License.
\r
18 * ============LICENSE_END=========================================================
\r
21 package org.openecomp.mso.requestsdb;
\r
24 import java.sql.Timestamp;
\r
26 import org.hibernate.Query;
\r
27 import org.hibernate.Session;
\r
28 import org.openecomp.mso.db.AbstractSessionFactoryManager;
\r
29 import org.openecomp.mso.logger.MessageEnum;
\r
30 import org.openecomp.mso.logger.MsoLogger;
\r
32 public class WatchdogDistributionStatusDb {
\r
34 protected final AbstractSessionFactoryManager sessionFactoryRequestDB;
\r
36 protected static MsoLogger msoLogger = MsoLogger.getMsoLogger (MsoLogger.Catalog.GENERAL);
\r
39 protected static final String DISTRIBUTION_ID = "distributionId";
\r
40 protected static final String DISTRIBUTION_ID_STATUS = "distributionIdStatus";
\r
41 protected static final String CREATE_TIME = "startTime";
\r
42 protected static final String MODIFY_TIME = "modifyTime";
\r
45 public static WatchdogDistributionStatusDb getInstance() {
\r
46 return new WatchdogDistributionStatusDb(new RequestsDbSessionFactoryManager ());
\r
49 protected WatchdogDistributionStatusDb (AbstractSessionFactoryManager sessionFactoryRequest) {
\r
50 sessionFactoryRequestDB = sessionFactoryRequest;
\r
55 * Insert into WATCHDOG_DISTRIBUTIONID_STATUS.
\r
57 * @param distributionId
\r
60 public void insertWatchdogDistributionId(String distributionId ) {
\r
61 long startTime = System.currentTimeMillis ();
\r
62 Timestamp startTimeStamp = new Timestamp (System.currentTimeMillis());
\r
63 msoLogger.debug ("Insert into WatchdogDistributionStatus - DistributionId: " + distributionId);
\r
65 if(getWatchdogDistributionId(distributionId) == null){
\r
67 Session session = sessionFactoryRequestDB.getSessionFactory ().openSession ();
\r
68 WatchdogDistributionStatus wds = new WatchdogDistributionStatus ();
\r
71 session.beginTransaction ();
\r
73 wds.setDistributionId (distributionId);
\r
74 wds.setCreateTime (startTimeStamp);
\r
75 Timestamp modifyTimeStamp = new Timestamp (System.currentTimeMillis());
\r
76 wds.setModifyTime (modifyTimeStamp);
\r
78 msoLogger.debug ("About to insert a record into WatchdogDistributionStatus ");
\r
81 session.getTransaction ().commit ();
\r
82 } catch (Exception e) {
\r
83 msoLogger.error (MessageEnum.APIH_DB_INSERT_EXC, "", "", MsoLogger.ErrorCode.SchemaError, "Exception in insertWatchdogDistributionId", e);
\r
84 msoLogger.recordMetricEvent (startTime, MsoLogger.StatusCode.ERROR, MsoLogger.ResponseCode.DBAccessError, e.getMessage (), "WatchdogDistributionStatusDB", "saveRequest", null);
\r
85 if (session != null) {
\r
88 // throw an Exception in the event of a DB insert failure so that the calling routine can exit
\r
91 if (session != null && session.isOpen ()) {
\r
94 msoLogger.recordMetricEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc, "Successfully", "WatchdogDistributionStatusDB", "insertWatchdogDistributionId", null);
\r
103 * Update WATCHDOG_DISTRIBUTIONID_STATUS with new status for a given distributionid.
\r
105 * @param distributionId
\r
106 * @param distributionStatus
\r
109 public void updateWatchdogDistributionIdStatus(String distributionId, String distributionIdStatus ) {
\r
110 long startTime = System.currentTimeMillis ();
\r
111 msoLogger.debug ("Update WatchdogDistributionStatus status with distributionId: " + distributionId + " and distributionStatus: " + distributionIdStatus );
\r
113 Session session = sessionFactoryRequestDB.getSessionFactory ().openSession ();
\r
116 session.beginTransaction ();
\r
117 Query query = session.createQuery ("update WatchdogDistributionStatus set distributionIdStatus = :distributionIdStatus where "
\r
118 + "distributionId = :distributionId ");
\r
120 query.setParameter ("distributionId", distributionId);
\r
121 query.setParameter ("distributionIdStatus", distributionIdStatus);
\r
123 //Timestamp modifyTimeStamp = new Timestamp (System.currentTimeMillis());
\r
124 //query.setParameter ("modifyTime", modifyTimeStamp);
\r
125 query.executeUpdate ();
\r
126 session.getTransaction ().commit ();
\r
128 } catch (Exception e) {
\r
129 msoLogger.error (MessageEnum.APIH_DB_INSERT_EXC, "", "", MsoLogger.ErrorCode.SchemaError, "Exception in updateWatchdogDistributionStatus", e);
\r
130 msoLogger.recordMetricEvent (startTime, MsoLogger.StatusCode.ERROR, MsoLogger.ResponseCode.DBAccessError, e.getMessage (), "WatchdogDistributionStatusDB", "saveRequest", null);
\r
131 if (session != null) {
\r
134 // throw an Exception in the event of a DB insert failure so that the calling routine can exit
\r
137 if (session != null && session.isOpen ()) {
\r
140 msoLogger.recordMetricEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc, "Successfully", "WatchdogDistributionStatusDB", "insertWatchdogDistributionStatus", null);
\r
145 * Retrieve records from WatchdogDistributionIdStatus.
\r
147 * @param distributionId
\r
148 * @return WatchdogDistributionIdStatus
\r
150 public String getWatchdogDistributionIdStatus(String distributionId) {
\r
151 long startTime = System.currentTimeMillis ();
\r
152 msoLogger.debug ("Retrieve records from WatchdogDistributionStatus for distributionId : " + distributionId );
\r
154 Session session = sessionFactoryRequestDB.getSessionFactory ().openSession ();
\r
155 String distributionStatus = null;
\r
157 session.beginTransaction ();
\r
158 Query query = session.createQuery ("SELECT distributionIdStatus FROM WatchdogDistributionStatus WHERE distributionId = :distributionId ");
\r
159 query.setParameter ("distributionId", distributionId);
\r
160 distributionStatus = (String) query.uniqueResult();
\r
162 if (session != null && session.isOpen ()) {
\r
165 msoLogger.recordMetricEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc,
\r
166 "Successfully", "WatchdogDistributionStatusDB", "getWatchdogDistributionIdStatus", null);
\r
168 return distributionStatus;
\r
172 * Retrieve records from WatchdogDistributionId.
\r
174 * @param distributionId
\r
175 * @return WatchdogDistributionIdStatus
\r
177 public String getWatchdogDistributionId(String distributionId) {
\r
178 long startTime = System.currentTimeMillis ();
\r
179 msoLogger.debug ("Retrieve distributionId from WatchdogDistributionStatus for distributionId : " + distributionId );
\r
181 Session session = sessionFactoryRequestDB.getSessionFactory ().openSession ();
\r
182 String existingDistributionId = null;
\r
184 session.beginTransaction ();
\r
185 Query query = session.createQuery ("SELECT distributionId FROM WatchdogDistributionStatus WHERE distributionId = :distributionId ");
\r
186 query.setParameter ("distributionId", distributionId);
\r
187 existingDistributionId = (String) query.uniqueResult();
\r
189 if (session != null && session.isOpen ()) {
\r
192 msoLogger.recordMetricEvent (startTime, MsoLogger.StatusCode.COMPLETE, MsoLogger.ResponseCode.Suc,
\r
193 "Successfully", "WatchdogDistributionStatusDB", "getWatchdogDistributionIdStatus", null);
\r
195 return existingDistributionId;
\r