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.CoordinatorActionBean;
029 import org.apache.oozie.ErrorCode;
030 import org.apache.oozie.service.JPAService;
031 import org.apache.oozie.service.Services;
032
033 /**
034 * Query Executor that provides API to run query for Coordinator Action
035 */
036 public class CoordActionQueryExecutor extends
037 QueryExecutor<CoordinatorActionBean, CoordActionQueryExecutor.CoordActionQuery> {
038
039 public enum CoordActionQuery {
040 UPDATE_COORD_ACTION,
041 UPDATE_COORD_ACTION_STATUS_PENDING_TIME,
042 UPDATE_COORD_ACTION_FOR_INPUTCHECK,
043 UPDATE_COORD_ACTION_FOR_PUSH_INPUTCHECK,
044 UPDATE_COORD_ACTION_DEPENDENCIES,
045 UPDATE_COORD_ACTION_FOR_START,
046 UPDATE_COORD_ACTION_FOR_MODIFIED_DATE,
047 UPDATE_COORD_ACTION_RERUN,
048 GET_COORD_ACTION,
049 GET_COORD_ACTION_STATUS,
050 GET_COORD_ACTIVE_ACTIONS_COUNT_BY_JOBID,
051 GET_COORD_ACTIONS_BY_LAST_MODIFIED_TIME
052 };
053
054 private static CoordActionQueryExecutor instance = new CoordActionQueryExecutor();
055
056 private CoordActionQueryExecutor() {
057 }
058
059 public static QueryExecutor<CoordinatorActionBean, CoordActionQueryExecutor.CoordActionQuery> getInstance() {
060 return CoordActionQueryExecutor.instance;
061 }
062
063 @Override
064 public Query getUpdateQuery(CoordActionQuery namedQuery, CoordinatorActionBean actionBean, EntityManager em)
065 throws JPAExecutorException {
066
067 Query query = em.createNamedQuery(namedQuery.name());
068 switch (namedQuery) {
069 case UPDATE_COORD_ACTION:
070 query.setParameter("actionNumber", actionBean.getActionNumber());
071 query.setParameter("actionXml", actionBean.getActionXmlBlob());
072 query.setParameter("consoleUrl", actionBean.getConsoleUrl());
073 query.setParameter("createdConf", actionBean.getCreatedConfBlob());
074 query.setParameter("errorCode", actionBean.getErrorCode());
075 query.setParameter("errorMessage", actionBean.getErrorMessage());
076 query.setParameter("externalStatus", actionBean.getExternalStatus());
077 query.setParameter("missingDependencies", actionBean.getMissingDependenciesBlob());
078 query.setParameter("runConf", actionBean.getRunConfBlob());
079 query.setParameter("timeOut", actionBean.getTimeOut());
080 query.setParameter("trackerUri", actionBean.getTrackerUri());
081 query.setParameter("type", actionBean.getType());
082 query.setParameter("createdTime", actionBean.getCreatedTimestamp());
083 query.setParameter("externalId", actionBean.getExternalId());
084 query.setParameter("jobId", actionBean.getJobId());
085 query.setParameter("lastModifiedTime", new Date());
086 query.setParameter("nominalTime", actionBean.getNominalTimestamp());
087 query.setParameter("slaXml", actionBean.getSlaXmlBlob());
088 query.setParameter("status", actionBean.getStatus().toString());
089 query.setParameter("id", actionBean.getId());
090 break;
091
092 case UPDATE_COORD_ACTION_STATUS_PENDING_TIME:
093 query.setParameter("status", actionBean.getStatus().toString());
094 query.setParameter("pending", actionBean.getPending());
095 query.setParameter("lastModifiedTime", new Date());
096 query.setParameter("id", actionBean.getId());
097 break;
098
099 case UPDATE_COORD_ACTION_FOR_INPUTCHECK:
100 query.setParameter("status", actionBean.getStatus().toString());
101 query.setParameter("lastModifiedTime", new Date());
102 query.setParameter("actionXml", actionBean.getActionXmlBlob());
103 query.setParameter("missingDependencies", actionBean.getMissingDependenciesBlob());
104 query.setParameter("id", actionBean.getId());
105 break;
106
107 case UPDATE_COORD_ACTION_FOR_PUSH_INPUTCHECK:
108 query.setParameter("status", actionBean.getStatus().toString());
109 query.setParameter("lastModifiedTime", new Date());
110 query.setParameter("actionXml", actionBean.getActionXmlBlob());
111 query.setParameter("pushMissingDependencies", actionBean.getPushMissingDependenciesBlob());
112 query.setParameter("id", actionBean.getId());
113 break;
114
115 case UPDATE_COORD_ACTION_DEPENDENCIES:
116 query.setParameter("missingDependencies", actionBean.getMissingDependenciesBlob());
117 query.setParameter("pushMissingDependencies", actionBean.getPushMissingDependenciesBlob());
118 query.setParameter("id", actionBean.getId());
119 break;
120
121 case UPDATE_COORD_ACTION_FOR_START:
122 query.setParameter("status", actionBean.getStatus().toString());
123 query.setParameter("lastModifiedTime", new Date());
124 query.setParameter("runConf", actionBean.getRunConfBlob());
125 query.setParameter("externalId", actionBean.getExternalId());
126 query.setParameter("pending", actionBean.getPending());
127 query.setParameter("errorCode", actionBean.getErrorCode());
128 query.setParameter("errorMessage", actionBean.getErrorMessage());
129 query.setParameter("id", actionBean.getId());
130 break;
131
132 case UPDATE_COORD_ACTION_FOR_MODIFIED_DATE:
133 query.setParameter("lastModifiedTime", actionBean.getLastModifiedTimestamp());
134 query.setParameter("id", actionBean.getId());
135 break;
136
137 case UPDATE_COORD_ACTION_RERUN:
138 query.setParameter("actionXml", actionBean.getActionXmlBlob());
139 query.setParameter("status", actionBean.getStatusStr());
140 query.setParameter("externalId", actionBean.getExternalId());
141 query.setParameter("externalStatus", actionBean.getExternalStatus());
142 query.setParameter("rerunTime", actionBean.getRerunTimestamp());
143 query.setParameter("lastModifiedTime", actionBean.getLastModifiedTimestamp());
144 query.setParameter("createdTime", actionBean.getCreatedTimestamp());
145 query.setParameter("createdConf", actionBean.getCreatedConfBlob());
146 query.setParameter("runConf", actionBean.getRunConfBlob());
147 query.setParameter("missingDependencies", actionBean.getMissingDependenciesBlob());
148 query.setParameter("pushMissingDependencies", actionBean.getPushMissingDependenciesBlob());
149 query.setParameter("errorCode", actionBean.getErrorCode());
150 query.setParameter("errorMessage", actionBean.getErrorMessage());
151 query.setParameter("id", actionBean.getId());
152 break;
153
154 default:
155 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
156 + namedQuery.name());
157 }
158 return query;
159 }
160
161 @Override
162 public Query getSelectQuery(CoordActionQuery namedQuery, EntityManager em, Object... parameters)
163 throws JPAExecutorException {
164 Query query = em.createNamedQuery(namedQuery.name());
165 CoordActionQuery caQuery = (CoordActionQuery) namedQuery;
166 switch (caQuery) {
167 case GET_COORD_ACTION:
168 case GET_COORD_ACTION_STATUS:
169 query.setParameter("id", parameters[0]);
170 break;
171 case GET_COORD_ACTIONS_BY_LAST_MODIFIED_TIME:
172 query.setParameter("lastModifiedTime", new Timestamp(((Date) parameters[0]).getTime()));
173 break;
174 default:
175 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
176 + caQuery.name());
177 }
178 return query;
179 }
180
181 @Override
182 public int executeUpdate(CoordActionQuery namedQuery, CoordinatorActionBean jobBean) throws JPAExecutorException {
183 JPAService jpaService = Services.get().get(JPAService.class);
184 EntityManager em = jpaService.getEntityManager();
185 Query query = getUpdateQuery(namedQuery, jobBean, em);
186 int ret = jpaService.executeUpdate(namedQuery.name(), query, em);
187 return ret;
188 }
189
190 @Override
191 public CoordinatorActionBean get(CoordActionQuery namedQuery, Object... parameters) throws JPAExecutorException {
192 JPAService jpaService = Services.get().get(JPAService.class);
193 EntityManager em = jpaService.getEntityManager();
194 Query query = getSelectQuery(namedQuery, em, parameters);
195 Object ret = jpaService.executeGet(namedQuery.name(), query, em);
196 if (ret == null) {
197 throw new JPAExecutorException(ErrorCode.E0605, query.toString());
198 }
199 CoordinatorActionBean bean = constructBean(namedQuery, ret);
200 return bean;
201 }
202
203 @Override
204 public List<CoordinatorActionBean> getList(CoordActionQuery namedQuery, Object... parameters)
205 throws JPAExecutorException {
206 JPAService jpaService = Services.get().get(JPAService.class);
207 EntityManager em = jpaService.getEntityManager();
208 Query query = getSelectQuery(namedQuery, em, parameters);
209 List<?> retList = (List<?>) jpaService.executeGetList(namedQuery.name(), query, em);
210 List<CoordinatorActionBean> beanList = new ArrayList<CoordinatorActionBean>();
211 if (retList != null) {
212 for (Object ret : retList) {
213 beanList.add(constructBean(namedQuery, ret));
214 }
215 }
216 return beanList;
217 }
218
219 private CoordinatorActionBean constructBean(CoordActionQuery namedQuery, Object ret) throws JPAExecutorException {
220 CoordinatorActionBean bean;
221 Object[] arr;
222 switch (namedQuery) {
223 case GET_COORD_ACTION:
224 bean = (CoordinatorActionBean) ret;
225 break;
226 case GET_COORD_ACTIONS_BY_LAST_MODIFIED_TIME:
227 bean = new CoordinatorActionBean();
228 bean.setJobId((String) ret);
229 break;
230 case GET_COORD_ACTION_STATUS:
231 bean = new CoordinatorActionBean();
232 bean.setStatusStr((String)ret);
233 break;
234 default:
235 throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot construct action bean for "
236 + namedQuery.name());
237 }
238 return bean;
239 }
240
241 @Override
242 public Object getSingleValue(CoordActionQuery namedQuery, Object... parameters) throws JPAExecutorException {
243 throw new UnsupportedOperationException();
244 }
245 }