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.List;
023
024 import javax.persistence.EntityManager;
025 import javax.persistence.Query;
026
027 import org.apache.oozie.BundleJobBean;
028 import org.apache.oozie.ErrorCode;
029 import org.apache.oozie.StringBlob;
030 import org.apache.oozie.service.JPAService;
031 import org.apache.oozie.service.Services;
032 import org.apache.oozie.util.DateUtils;
033
034 /**
035 * Query Executor that provides API to run query for Bundle Job
036 */
037 public class BundleJobQueryExecutor extends QueryExecutor<BundleJobBean, BundleJobQueryExecutor.BundleJobQuery> {
038
039 public enum BundleJobQuery {
040 UPDATE_BUNDLE_JOB,
041 UPDATE_BUNDLE_JOB_STATUS,
042 UPDATE_BUNDLE_JOB_STATUS_PENDING,
043 UPDATE_BUNDLE_JOB_STATUS_PENDING_MODTIME,
044 UPDATE_BUNDLE_JOB_STATUS_PENDING_SUSP_MOD_TIME,
045 UPDATE_BUNDLE_JOB_STATUS_PAUSE_ENDTIME,
046 UPDATE_BUNDLE_JOB_PAUSE_KICKOFF,
047 GET_BUNDLE_JOB,
048 GET_BUNDLE_JOB_STATUS,
049 GET_BUNDLE_JOB_ID_STATUS_PENDING_MODTIME,
050 GET_BUNDLE_JOB_ID_JOBXML_CONF
051 };
052
053 private static BundleJobQueryExecutor instance = new BundleJobQueryExecutor();
054
055 private BundleJobQueryExecutor() {
056 }
057
058 public static QueryExecutor<BundleJobBean, BundleJobQueryExecutor.BundleJobQuery> getInstance() {
059 return BundleJobQueryExecutor.instance;
060 }
061
062 @Override
063 public Query getUpdateQuery(BundleJobQuery namedQuery, BundleJobBean bjBean, EntityManager em)
064 throws JPAExecutorException {
065 Query query = em.createNamedQuery(namedQuery.name());
066 switch (namedQuery) {
067 case UPDATE_BUNDLE_JOB:
068 query.setParameter("appName", bjBean.getAppName());
069 query.setParameter("appPath", bjBean.getAppPath());
070 query.setParameter("conf", bjBean.getConfBlob());
071 query.setParameter("timeOut", bjBean.getTimeout());
072 query.setParameter("createdTime", bjBean.getCreatedTimestamp());
073 query.setParameter("endTime", bjBean.getEndTimestamp());
074 query.setParameter("jobXml", bjBean.getJobXmlBlob());
075 query.setParameter("lastModifiedTime", bjBean.getLastModifiedTimestamp());
076 query.setParameter("origJobXml", bjBean.getOrigJobXmlBlob());
077 query.setParameter("startTime", bjBean.getstartTimestamp());
078 query.setParameter("status", bjBean.getStatus().toString());
079 query.setParameter("timeUnit", bjBean.getTimeUnit());
080 query.setParameter("pending", bjBean.isPending() ? 1 : 0);
081 query.setParameter("id", bjBean.getId());
082 break;
083 case UPDATE_BUNDLE_JOB_STATUS:
084 query.setParameter("status", bjBean.getStatus().toString());
085 query.setParameter("lastModifiedTime", bjBean.getLastModifiedTimestamp());
086 query.setParameter("pending", bjBean.getPending());
087 query.setParameter("id", bjBean.getId());
088 break;
089 case UPDATE_BUNDLE_JOB_STATUS_PENDING:
090 query.setParameter("status", bjBean.getStatus().toString());
091 query.setParameter("pending", bjBean.getPending());
092 query.setParameter("id", bjBean.getId());
093 break;
094 case UPDATE_BUNDLE_JOB_STATUS_PENDING_SUSP_MOD_TIME:
095 query.setParameter("status", bjBean.getStatus().toString());
096 query.setParameter("lastModifiedTime", bjBean.getLastModifiedTimestamp());
097 query.setParameter("pending", bjBean.getPending());
098 query.setParameter("suspendedTime", bjBean.getSuspendedTimestamp());
099 query.setParameter("id", bjBean.getId());
100 break;
101 case UPDATE_BUNDLE_JOB_STATUS_PENDING_MODTIME:
102 query.setParameter("status", bjBean.getStatus().toString());
103 query.setParameter("lastModifiedTime", bjBean.getLastModifiedTimestamp());
104 query.setParameter("pending", bjBean.getPending());
105 query.setParameter("id", bjBean.getId());
106 break;
107 case UPDATE_BUNDLE_JOB_STATUS_PAUSE_ENDTIME:
108 query.setParameter("status", bjBean.getStatus().toString());
109 query.setParameter("pauseTime", bjBean.getPauseTimestamp());
110 query.setParameter("endTime", bjBean.getEndTimestamp());
111 query.setParameter("id", bjBean.getId());
112 break;
113 case UPDATE_BUNDLE_JOB_PAUSE_KICKOFF:
114 query.setParameter("pauseTime", bjBean.getPauseTimestamp());
115 query.setParameter("kickoffTime", bjBean.getKickoffTimestamp());
116 query.setParameter("id", bjBean.getId());
117 break;
118 default:
119 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
120 + namedQuery.name());
121 }
122 return query;
123 }
124
125 @Override
126 public Query getSelectQuery(BundleJobQuery namedQuery, EntityManager em, Object... parameters)
127 throws JPAExecutorException {
128 Query query = em.createNamedQuery(namedQuery.name());
129 switch (namedQuery) {
130 case GET_BUNDLE_JOB:
131 case GET_BUNDLE_JOB_ID_STATUS_PENDING_MODTIME:
132 case GET_BUNDLE_JOB_ID_JOBXML_CONF:
133 case GET_BUNDLE_JOB_STATUS:
134 query.setParameter("id", parameters[0]);
135 break;
136 default:
137 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
138 + namedQuery.name());
139 }
140 return query;
141 }
142
143 @Override
144 public int executeUpdate(BundleJobQuery namedQuery, BundleJobBean jobBean) throws JPAExecutorException {
145 JPAService jpaService = Services.get().get(JPAService.class);
146 EntityManager em = jpaService.getEntityManager();
147 Query query = getUpdateQuery(namedQuery, jobBean, em);
148 int ret = jpaService.executeUpdate(namedQuery.name(), query, em);
149 return ret;
150 }
151
152 @Override
153 public BundleJobBean get(BundleJobQuery namedQuery, Object... parameters) throws JPAExecutorException {
154 JPAService jpaService = Services.get().get(JPAService.class);
155 EntityManager em = jpaService.getEntityManager();
156 Query query = getSelectQuery(namedQuery, em, parameters);
157 Object ret = jpaService.executeGet(namedQuery.name(), query, em);
158 if (ret == null) {
159 throw new JPAExecutorException(ErrorCode.E0604, query.toString());
160 }
161 BundleJobBean bean = constructBean(namedQuery, ret, parameters);
162 return bean;
163 }
164
165 @Override
166 public List<BundleJobBean> getList(BundleJobQuery namedQuery, Object... parameters) throws JPAExecutorException {
167 JPAService jpaService = Services.get().get(JPAService.class);
168 EntityManager em = jpaService.getEntityManager();
169 Query query = getSelectQuery(namedQuery, em, parameters);
170 List<?> retList = (List<?>) jpaService.executeGetList(namedQuery.name(), query, em);
171 List<BundleJobBean> beanList = new ArrayList<BundleJobBean>();
172 if (retList != null) {
173 for (Object ret : retList) {
174 beanList.add(constructBean(namedQuery, ret));
175 }
176 }
177 return beanList;
178 }
179
180 private BundleJobBean constructBean(BundleJobQuery namedQuery, Object ret, Object... parameters)
181 throws JPAExecutorException {
182 BundleJobBean bean;
183 Object[] arr;
184 switch (namedQuery) {
185 case GET_BUNDLE_JOB:
186 bean = (BundleJobBean) ret;
187 break;
188 case GET_BUNDLE_JOB_STATUS:
189 bean = new BundleJobBean();
190 bean.setId((String) parameters[0]);
191 bean.setStatus((String) ret);
192 break;
193 case GET_BUNDLE_JOB_ID_STATUS_PENDING_MODTIME:
194 bean = new BundleJobBean();
195 arr = (Object[]) ret;
196 bean.setId((String) arr[0]);
197 bean.setStatus((String) arr[1]);
198 bean.setPending((Integer) arr[2]);
199 bean.setLastModifiedTime(DateUtils.toDate((Timestamp) arr[3]));
200 break;
201 case GET_BUNDLE_JOB_ID_JOBXML_CONF:
202 bean = new BundleJobBean();
203 arr = (Object[]) ret;
204 bean.setId((String) arr[0]);
205 bean.setJobXmlBlob((StringBlob) arr[1]);
206 bean.setConfBlob((StringBlob) arr[2]);
207 break;
208 default:
209 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot construct job bean for "
210 + namedQuery.name());
211 }
212 return bean;
213 }
214
215 @Override
216 public Object getSingleValue(BundleJobQuery namedQuery, Object... parameters) throws JPAExecutorException {
217 throw new UnsupportedOperationException();
218 }
219 }