001 /**
002 * Licensed to the Apache Software Foundation (ASF) under one
003 * or more contributor license agreements. See the NOTICE file
004 * distributed with this work for additional information
005 * regarding copyright ownership. The ASF licenses this file
006 * to you under the Apache License, Version 2.0 (the
007 * "License"); you may not use this file except in compliance
008 * with the License. You may obtain a copy of the License at
009 *
010 * http://www.apache.org/licenses/LICENSE-2.0
011 *
012 * Unless required by applicable law or agreed to in writing, software
013 * distributed under the License is distributed on an "AS IS" BASIS,
014 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
015 * See the License for the specific language governing permissions and
016 * limitations under the License.
017 */
018 package org.apache.oozie.executor.jpa;
019
020 import java.util.List;
021
022 import javax.persistence.EntityManager;
023 import javax.persistence.Query;
024
025 import org.apache.oozie.ErrorCode;
026 import org.apache.oozie.service.JPAService;
027 import org.apache.oozie.service.Services;
028 import org.apache.oozie.sla.SLASummaryBean;
029
030 /**
031 * Query Executor for SLA Event
032 *
033 */
034 public class SLASummaryQueryExecutor extends QueryExecutor<SLASummaryBean, SLASummaryQueryExecutor.SLASummaryQuery> {
035
036 public enum SLASummaryQuery {
037 UPDATE_SLA_SUMMARY_FOR_STATUS_ACTUAL_TIMES,
038 UPDATE_SLA_SUMMARY_FOR_ACTUAL_TIMES,
039 UPDATE_SLA_SUMMARY_ALL,
040 UPDATE_SLA_SUMMARY_EVENTPROCESSED,
041 GET_SLA_SUMMARY,
042 GET_SLA_SUMMARY_EVENTPROCESSED
043 };
044
045 private static SLASummaryQueryExecutor instance = new SLASummaryQueryExecutor();
046
047 private SLASummaryQueryExecutor() {
048 }
049
050 public static QueryExecutor<SLASummaryBean, SLASummaryQueryExecutor.SLASummaryQuery> getInstance() {
051 return SLASummaryQueryExecutor.instance;
052 }
053
054 @Override
055 public Query getUpdateQuery(SLASummaryQuery namedQuery, SLASummaryBean bean, EntityManager em)
056 throws JPAExecutorException {
057 Query query = em.createNamedQuery(namedQuery.name());
058 switch (namedQuery) {
059 case UPDATE_SLA_SUMMARY_FOR_STATUS_ACTUAL_TIMES:
060 query.setParameter("jobId", bean.getId());
061 query.setParameter("slaStatus", bean.getSLAStatus().toString());
062 query.setParameter("lastModifiedTS", bean.getLastModifiedTimestamp());
063 query.setParameter("eventStatus", bean.getEventStatusString());
064 query.setParameter("jobStatus", bean.getJobStatus());
065 query.setParameter("eventProcessed", bean.getEventProcessed());
066 query.setParameter("actualStartTS", bean.getActualStartTimestamp());
067 query.setParameter("actualEndTS", bean.getActualEndTimestamp());
068 query.setParameter("actualDuration", bean.getActualDuration());
069 break;
070 case UPDATE_SLA_SUMMARY_FOR_ACTUAL_TIMES:
071 query.setParameter("jobId", bean.getId());
072 query.setParameter("eventProcessed", bean.getEventProcessed());
073 query.setParameter("actualStartTS", bean.getActualStartTimestamp());
074 query.setParameter("actualEndTS", bean.getActualEndTimestamp());
075 query.setParameter("actualDuration", bean.getActualDuration());
076 query.setParameter("lastModifiedTS", bean.getLastModifiedTimestamp());
077 break;
078 case UPDATE_SLA_SUMMARY_ALL:
079 query.setParameter("appName", bean.getAppName());
080 query.setParameter("appType", bean.getAppType().toString());
081 query.setParameter("nominalTime", bean.getNominalTimestamp());
082 query.setParameter("expectedStartTime", bean.getExpectedStartTimestamp());
083 query.setParameter("expectedEndTime", bean.getExpectedEndTimestamp());
084 query.setParameter("expectedDuration", bean.getExpectedDuration());
085 query.setParameter("jobStatus", bean.getJobStatus());
086 query.setParameter("slaStatus", bean.getSLAStatusString());
087 query.setParameter("eventStatus", bean.getEventStatusString());
088 query.setParameter("lastModTime", bean.getLastModifiedTimestamp());
089 query.setParameter("user", bean.getUser());
090 query.setParameter("parentId", bean.getParentId());
091 query.setParameter("eventProcessed", bean.getEventProcessed());
092 query.setParameter("actualDuration", bean.getActualDuration());
093 query.setParameter("actualEndTS", bean.getActualEndTimestamp());
094 query.setParameter("actualStartTS", bean.getActualStartTimestamp());
095 query.setParameter("jobId", bean.getId());
096 break;
097 case UPDATE_SLA_SUMMARY_EVENTPROCESSED:
098 query.setParameter("eventProcessed", bean.getEventProcessed());
099 query.setParameter("jobId", bean.getId());
100 break;
101 default:
102 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
103 + namedQuery.name());
104 }
105 return query;
106 }
107
108 @Override
109 public Query getSelectQuery(SLASummaryQuery namedQuery, EntityManager em, Object... parameters)
110 throws JPAExecutorException {
111 Query query = em.createNamedQuery(namedQuery.name());
112 switch (namedQuery) {
113 case GET_SLA_SUMMARY:
114 case GET_SLA_SUMMARY_EVENTPROCESSED:
115 query.setParameter("id", parameters[0]);
116 break;
117 }
118 return query;
119 }
120
121 @Override
122 public int executeUpdate(SLASummaryQuery namedQuery, SLASummaryBean jobBean) throws JPAExecutorException {
123 JPAService jpaService = Services.get().get(JPAService.class);
124 EntityManager em = jpaService.getEntityManager();
125 Query query = getUpdateQuery(namedQuery, jobBean, em);
126 int ret = jpaService.executeUpdate(namedQuery.name(), query, em);
127 return ret;
128 }
129
130 @Override
131 public SLASummaryBean get(SLASummaryQuery namedQuery, Object... parameters) throws JPAExecutorException {
132 JPAService jpaService = Services.get().get(JPAService.class);
133 EntityManager em = jpaService.getEntityManager();
134 Query query = getSelectQuery(namedQuery, em, parameters);
135 Object ret = jpaService.executeGet(namedQuery.name(), query, em);
136 if (ret == null && !namedQuery.equals(SLASummaryQuery.GET_SLA_SUMMARY)) {
137 throw new JPAExecutorException(ErrorCode.E0604, query.toString());
138 }
139 SLASummaryBean bean = constructBean(namedQuery, ret, parameters);
140 return bean;
141 }
142
143 @Override
144 public List<SLASummaryBean> getList(SLASummaryQuery namedQuery, Object... parameters) throws JPAExecutorException {
145 JPAService jpaService = Services.get().get(JPAService.class);
146 EntityManager em = jpaService.getEntityManager();
147 Query query = getSelectQuery(namedQuery, em, parameters);
148 @SuppressWarnings("unchecked")
149 List<SLASummaryBean> beanList = (List<SLASummaryBean>) jpaService.executeGetList(namedQuery.name(), query, em);
150 return beanList;
151 }
152
153 @Override
154 public Object getSingleValue(SLASummaryQuery namedQuery, Object... parameters) throws JPAExecutorException {
155 JPAService jpaService = Services.get().get(JPAService.class);
156 EntityManager em = jpaService.getEntityManager();
157 Query query = getSelectQuery(namedQuery, em, parameters);
158 Object ret = jpaService.executeGet(namedQuery.name(), query, em);
159 if (ret == null) {
160 throw new JPAExecutorException(ErrorCode.E0604, query.toString());
161 }
162 return ret;
163 }
164
165 private SLASummaryBean constructBean(SLASummaryQuery namedQuery, Object ret, Object... parameters)
166 throws JPAExecutorException {
167 SLASummaryBean bean;
168 switch (namedQuery) {
169 case GET_SLA_SUMMARY:
170 bean = (SLASummaryBean) ret;
171 break;
172 case GET_SLA_SUMMARY_EVENTPROCESSED:
173 bean = new SLASummaryBean();
174 bean.setEventProcessed(((Byte)ret).intValue());
175 break;
176 default:
177 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot construct job bean for "
178 + namedQuery.name());
179 }
180 return bean;
181 }
182
183 }