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.sql.Timestamp;
021 import java.util.ArrayList;
022 import java.util.Date;
023 import java.util.List;
024
025 import javax.persistence.EntityManager;
026 import javax.persistence.Query;
027
028 import org.apache.oozie.CoordinatorJobBean;
029 import org.apache.oozie.ErrorCode;
030 import org.apache.oozie.StringBlob;
031 import org.apache.oozie.service.JPAService;
032 import org.apache.oozie.service.Services;
033 import org.apache.oozie.util.DateUtils;
034
035 /**
036 * Query Executor that provides API to run query for Coordinator Job
037 */
038
039 public class CoordJobQueryExecutor extends QueryExecutor<CoordinatorJobBean, CoordJobQueryExecutor.CoordJobQuery> {
040
041 public enum CoordJobQuery {
042 UPDATE_COORD_JOB,
043 UPDATE_COORD_JOB_STATUS,
044 UPDATE_COORD_JOB_BUNDLEID,
045 UPDATE_COORD_JOB_APPNAMESPACE,
046 UPDATE_COORD_JOB_STATUS_PENDING,
047 UPDATE_COORD_JOB_BUNDLEID_APPNAMESPACE_PAUSETIME,
048 UPDATE_COORD_JOB_STATUS_MODTIME,
049 UPDATE_COORD_JOB_STATUS_PENDING_MODTIME,
050 UPDATE_COORD_JOB_LAST_MODIFIED_TIME,
051 UPDATE_COORD_JOB_STATUS_PENDING_TIME,
052 UPDATE_COORD_JOB_MATERIALIZE,
053 UPDATE_COORD_JOB_CHANGE,
054 GET_COORD_JOB,
055 GET_COORD_JOB_USER_APPNAME,
056 GET_COORD_JOB_INPUT_CHECK,
057 GET_COORD_JOB_ACTION_READY,
058 GET_COORD_JOB_ACTION_KILL,
059 GET_COORD_JOB_MATERIALIZE,
060 GET_COORD_JOB_SUSPEND_KILL,
061 GET_COORD_JOB_STATUS_PARENTID,
062 GET_COORD_JOBS_CHANGED,
063 GET_COORD_JOBS_OLDER_FOR_MATERILZATION
064 };
065
066 private static CoordJobQueryExecutor instance = new CoordJobQueryExecutor();
067
068 private CoordJobQueryExecutor() {
069 }
070
071 public static CoordJobQueryExecutor getInstance() {
072 return CoordJobQueryExecutor.instance;
073 }
074
075 @Override
076 public Query getUpdateQuery(CoordJobQuery namedQuery, CoordinatorJobBean cjBean, EntityManager em)
077 throws JPAExecutorException {
078 Query query = em.createNamedQuery(namedQuery.name());
079 switch (namedQuery) {
080 case UPDATE_COORD_JOB:
081 query.setParameter("appName", cjBean.getAppName());
082 query.setParameter("appPath", cjBean.getAppPath());
083 query.setParameter("concurrency", cjBean.getConcurrency());
084 query.setParameter("conf", cjBean.getConfBlob());
085 query.setParameter("externalId", cjBean.getExternalId());
086 query.setParameter("frequency", cjBean.getFrequency());
087 query.setParameter("lastActionNumber", cjBean.getLastActionNumber());
088 query.setParameter("timeOut", cjBean.getTimeout());
089 query.setParameter("timeZone", cjBean.getTimeZone());
090 query.setParameter("createdTime", cjBean.getCreatedTimestamp());
091 query.setParameter("endTime", cjBean.getEndTimestamp());
092 query.setParameter("execution", cjBean.getExecution());
093 query.setParameter("jobXml", cjBean.getJobXmlBlob());
094 query.setParameter("lastAction", cjBean.getLastActionTimestamp());
095 query.setParameter("lastModifiedTime", cjBean.getLastModifiedTimestamp());
096 query.setParameter("nextMaterializedTime", cjBean.getNextMaterializedTimestamp());
097 query.setParameter("origJobXml", cjBean.getOrigJobXmlBlob());
098 query.setParameter("slaXml", cjBean.getSlaXmlBlob());
099 query.setParameter("startTime", cjBean.getStartTimestamp());
100 query.setParameter("status", cjBean.getStatus().toString());
101 query.setParameter("timeUnit", cjBean.getTimeUnitStr());
102 query.setParameter("appNamespace", cjBean.getAppNamespace());
103 query.setParameter("bundleId", cjBean.getBundleId());
104 query.setParameter("matThrottling", cjBean.getMatThrottling());
105 query.setParameter("id", cjBean.getId());
106 break;
107 case UPDATE_COORD_JOB_STATUS:
108 query.setParameter("status", cjBean.getStatus().toString());
109 query.setParameter("id", cjBean.getId());
110 break;
111 case UPDATE_COORD_JOB_BUNDLEID:
112 query.setParameter("bundleId", cjBean.getBundleId());
113 query.setParameter("id", cjBean.getId());
114 break;
115 case UPDATE_COORD_JOB_APPNAMESPACE:
116 query.setParameter("appNamespace", cjBean.getAppNamespace());
117 query.setParameter("id", cjBean.getId());
118 break;
119 case UPDATE_COORD_JOB_STATUS_PENDING:
120 query.setParameter("status", cjBean.getStatus().toString());
121 query.setParameter("pending", cjBean.isPending() ? 1 : 0);
122 query.setParameter("id", cjBean.getId());
123 break;
124 case UPDATE_COORD_JOB_BUNDLEID_APPNAMESPACE_PAUSETIME:
125 query.setParameter("bundleId", cjBean.getBundleId());
126 query.setParameter("appNamespace", cjBean.getAppNamespace());
127 query.setParameter("pauseTime", cjBean.getPauseTimestamp());
128 query.setParameter("id", cjBean.getId());
129 break;
130 case UPDATE_COORD_JOB_STATUS_MODTIME:
131 query.setParameter("status", cjBean.getStatus().toString());
132 query.setParameter("lastModifiedTime", cjBean.getLastModifiedTimestamp());
133 query.setParameter("id", cjBean.getId());
134 break;
135 case UPDATE_COORD_JOB_STATUS_PENDING_MODTIME:
136 query.setParameter("status", cjBean.getStatus().toString());
137 query.setParameter("pending", cjBean.isPending() ? 1 : 0);
138 query.setParameter("lastModifiedTime", cjBean.getLastModifiedTimestamp());
139 query.setParameter("id", cjBean.getId());
140 break;
141 case UPDATE_COORD_JOB_LAST_MODIFIED_TIME:
142 query.setParameter("lastModifiedTime", cjBean.getLastModifiedTimestamp());
143 query.setParameter("id", cjBean.getId());
144 break;
145 case UPDATE_COORD_JOB_STATUS_PENDING_TIME:
146 query.setParameter("status", cjBean.getStatus().toString());
147 query.setParameter("pending", cjBean.isPending() ? 1 : 0);
148 query.setParameter("doneMaterialization", cjBean.isDoneMaterialization() ? 1 : 0);
149 query.setParameter("lastModifiedTime", cjBean.getLastModifiedTimestamp());
150 query.setParameter("suspendedTime", cjBean.getSuspendedTimestamp());
151 query.setParameter("id", cjBean.getId());
152 break;
153 case UPDATE_COORD_JOB_MATERIALIZE:
154 query.setParameter("status", cjBean.getStatus().toString());
155 query.setParameter("pending", cjBean.isPending() ? 1 : 0);
156 query.setParameter("doneMaterialization", cjBean.isDoneMaterialization() ? 1 : 0);
157 query.setParameter("lastActionTime", cjBean.getLastActionTimestamp());
158 query.setParameter("lastActionNumber", cjBean.getLastActionNumber());
159 query.setParameter("nextMatdTime", cjBean.getNextMaterializedTimestamp());
160 query.setParameter("id", cjBean.getId());
161 break;
162 case UPDATE_COORD_JOB_CHANGE:
163 query.setParameter("endTime", cjBean.getEndTimestamp());
164 query.setParameter("status", cjBean.getStatus().toString());
165 query.setParameter("pending", cjBean.isPending() ? 1 : 0);
166 query.setParameter("doneMaterialization", cjBean.isDoneMaterialization() ? 1 : 0);
167 query.setParameter("concurrency", cjBean.getConcurrency());
168 query.setParameter("pauseTime", cjBean.getPauseTimestamp());
169 query.setParameter("lastActionNumber", cjBean.getLastActionNumber());
170 query.setParameter("lastActionTime", cjBean.getLastActionTimestamp());
171 query.setParameter("nextMatdTime", cjBean.getNextMaterializedTimestamp());
172 query.setParameter("lastModifiedTime", cjBean.getLastModifiedTimestamp());
173 query.setParameter("id", cjBean.getId());
174 break;
175 default:
176 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
177 + namedQuery.name());
178 }
179 return query;
180 }
181
182 @Override
183 public Query getSelectQuery(CoordJobQuery namedQuery, EntityManager em, Object... parameters)
184 throws JPAExecutorException {
185 Query query = em.createNamedQuery(namedQuery.name());
186 switch (namedQuery) {
187 case GET_COORD_JOB:
188 case GET_COORD_JOB_USER_APPNAME:
189 case GET_COORD_JOB_INPUT_CHECK:
190 case GET_COORD_JOB_ACTION_READY:
191 case GET_COORD_JOB_ACTION_KILL:
192 case GET_COORD_JOB_MATERIALIZE:
193 case GET_COORD_JOB_SUSPEND_KILL:
194 case GET_COORD_JOB_STATUS_PARENTID:
195 query.setParameter("id", parameters[0]);
196 break;
197 case GET_COORD_JOBS_CHANGED:
198 query.setParameter("lastModifiedTime", new Timestamp(((Date)parameters[0]).getTime()));
199 break;
200 case GET_COORD_JOBS_OLDER_FOR_MATERILZATION:
201 query.setParameter("matTime", new Timestamp(((Date)parameters[0]).getTime()));
202 int limit = (Integer) parameters[1];
203 if (limit > 0) {
204 query.setMaxResults(limit);
205 }
206 break;
207
208 default:
209 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
210 + namedQuery.name());
211 }
212 return query;
213 }
214
215 @Override
216 public int executeUpdate(CoordJobQuery namedQuery, CoordinatorJobBean jobBean) throws JPAExecutorException {
217 JPAService jpaService = Services.get().get(JPAService.class);
218 EntityManager em = jpaService.getEntityManager();
219 Query query = getUpdateQuery(namedQuery, jobBean, em);
220 int ret = jpaService.executeUpdate(namedQuery.name(), query, em);
221 return ret;
222 }
223
224 private CoordinatorJobBean constructBean(CoordJobQuery namedQuery, Object ret, Object... parameters)
225 throws JPAExecutorException {
226 CoordinatorJobBean bean;
227 Object[] arr;
228 switch (namedQuery) {
229 case GET_COORD_JOB:
230 bean = (CoordinatorJobBean) ret;
231 break;
232 case GET_COORD_JOB_USER_APPNAME:
233 bean = new CoordinatorJobBean();
234 arr = (Object[]) ret;
235 bean.setUser((String) arr[0]);
236 bean.setAppName((String) arr[1]);
237 break;
238 case GET_COORD_JOB_INPUT_CHECK:
239 bean = new CoordinatorJobBean();
240 arr = (Object[]) ret;
241 bean.setUser((String) arr[0]);
242 bean.setAppName((String) arr[1]);
243 bean.setStatusStr((String) arr[2]);
244 bean.setAppNamespace((String) arr[3]);
245 bean.setExecution((String) arr[4]);
246 bean.setFrequency((String) arr[5]);
247 bean.setTimeUnitStr((String) arr[6]);
248 bean.setTimeZone((String) arr[7]);
249 bean.setEndTime(DateUtils.toDate((Timestamp) arr[8]));
250 break;
251 case GET_COORD_JOB_ACTION_READY:
252 bean = new CoordinatorJobBean();
253 arr = (Object[]) ret;
254 bean.setId((String) arr[0]);
255 bean.setUser((String) arr[1]);
256 bean.setGroup((String) arr[2]);
257 bean.setAppName((String) arr[3]);
258 bean.setStatusStr((String) arr[4]);
259 bean.setExecution((String) arr[5]);
260 bean.setConcurrency((Integer) arr[6]);
261 break;
262 case GET_COORD_JOB_ACTION_KILL:
263 bean = new CoordinatorJobBean();
264 arr = (Object[]) ret;
265 bean.setId((String) arr[0]);
266 bean.setUser((String) arr[1]);
267 bean.setGroup((String) arr[2]);
268 bean.setAppName((String) arr[3]);
269 bean.setStatusStr((String) arr[4]);
270 break;
271 case GET_COORD_JOB_MATERIALIZE:
272 bean = new CoordinatorJobBean();
273 arr = (Object[]) ret;
274 bean.setId((String) arr[0]);
275 bean.setUser((String) arr[1]);
276 bean.setGroup((String) arr[2]);
277 bean.setAppName((String) arr[3]);
278 bean.setStatusStr((String) arr[4]);
279 bean.setFrequency((String) arr[5]);
280 bean.setMatThrottling((Integer) arr[6]);
281 bean.setTimeout((Integer) arr[7]);
282 bean.setTimeZone((String) arr[8]);
283 bean.setStartTime(DateUtils.toDate((Timestamp) arr[9]));
284 bean.setEndTime(DateUtils.toDate((Timestamp) arr[10]));
285 bean.setPauseTime(DateUtils.toDate((Timestamp) arr[11]));
286 bean.setNextMaterializedTime(DateUtils.toDate((Timestamp) arr[12]));
287 bean.setLastActionTime(DateUtils.toDate((Timestamp) arr[13]));
288 bean.setLastActionNumber((Integer) arr[14]);
289 bean.setDoneMaterialization((Integer) arr[15]);
290 bean.setBundleId((String) arr[16]);
291 bean.setConfBlob((StringBlob) arr[17]);
292 bean.setJobXmlBlob((StringBlob) arr[18]);
293 bean.setAppNamespace((String) arr[19]);
294 bean.setTimeUnitStr((String) arr[20]);
295 bean.setExecution((String) arr[21]);
296 break;
297 case GET_COORD_JOB_SUSPEND_KILL:
298 bean = new CoordinatorJobBean();
299 arr = (Object[]) ret;
300 bean.setId((String) arr[0]);
301 bean.setUser((String) arr[1]);
302 bean.setGroup((String) arr[2]);
303 bean.setAppName((String) arr[3]);
304 bean.setStatusStr((String) arr[4]);
305 bean.setBundleId((String) arr[5]);
306 bean.setAppNamespace((String) arr[6]);
307 bean.setDoneMaterialization((Integer) arr[7]);
308 break;
309 case GET_COORD_JOB_STATUS_PARENTID:
310 bean = new CoordinatorJobBean();
311 arr = (Object[]) ret;
312 bean.setId((String) parameters[0]);
313 bean.setStatusStr((String) arr[0]);
314 bean.setBundleId((String) arr[1]);
315 break;
316 case GET_COORD_JOBS_CHANGED:
317 bean = (CoordinatorJobBean) ret;
318 break;
319 case GET_COORD_JOBS_OLDER_FOR_MATERILZATION:
320 bean = new CoordinatorJobBean();
321 bean.setId((String) ret);
322 break;
323 default:
324 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot construct job bean for "
325 + namedQuery.name());
326 }
327 return bean;
328 }
329
330 @Override
331 public CoordinatorJobBean get(CoordJobQuery namedQuery, Object... parameters) throws JPAExecutorException {
332 JPAService jpaService = Services.get().get(JPAService.class);
333 EntityManager em = jpaService.getEntityManager();
334 Query query = getSelectQuery(namedQuery, em, parameters);
335 Object ret = jpaService.executeGet(namedQuery.name(), query, em);
336 if (ret == null) {
337 throw new JPAExecutorException(ErrorCode.E0604, query.toString());
338 }
339 CoordinatorJobBean bean = constructBean(namedQuery, ret, parameters);
340 return bean;
341 }
342
343 @Override
344 public List<CoordinatorJobBean> getList(CoordJobQuery namedQuery, Object... parameters) throws JPAExecutorException {
345 JPAService jpaService = Services.get().get(JPAService.class);
346 EntityManager em = jpaService.getEntityManager();
347 Query query = getSelectQuery(namedQuery, em, parameters);
348 List<?> retList = (List<?>) jpaService.executeGetList(namedQuery.name(), query, em);
349 List<CoordinatorJobBean> beanList = new ArrayList<CoordinatorJobBean>();
350 if (retList != null) {
351 for (Object ret : retList) {
352 beanList.add(constructBean(namedQuery, ret, parameters));
353 }
354 }
355 return beanList;
356 }
357
358 @Override
359 public Object getSingleValue(CoordJobQuery namedQuery, Object... parameters) throws JPAExecutorException {
360 throw new UnsupportedOperationException();
361 }
362
363 }