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.SLARegistrationBean;
029    
030    /**
031     * Query Executor for SLA Event
032     *
033     */
034    public class SLARegistrationQueryExecutor extends QueryExecutor<SLARegistrationBean, SLARegistrationQueryExecutor.SLARegQuery> {
035    
036        public enum SLARegQuery {
037            UPDATE_SLA_REG_ALL,
038            GET_SLA_REG_ALL,
039            GET_SLA_REG_ON_RESTART
040        };
041    
042        private static SLARegistrationQueryExecutor instance = new SLARegistrationQueryExecutor();
043    
044        private SLARegistrationQueryExecutor() {
045        }
046    
047        public static QueryExecutor<SLARegistrationBean, SLARegistrationQueryExecutor.SLARegQuery> getInstance() {
048            return SLARegistrationQueryExecutor.instance;
049        }
050    
051        @Override
052        public Query getUpdateQuery(SLARegQuery namedQuery, SLARegistrationBean bean, EntityManager em)
053                throws JPAExecutorException {
054    
055            Query query = em.createNamedQuery(namedQuery.name());
056            switch (namedQuery) {
057                case UPDATE_SLA_REG_ALL:
058                    query.setParameter("jobId", bean.getId());
059                    query.setParameter("nominalTime", bean.getNominalTimestamp());
060                    query.setParameter("expectedStartTime", bean.getExpectedStartTimestamp());
061                    query.setParameter("expectedEndTime", bean.getExpectedEndTimestamp());
062                    query.setParameter("expectedDuration", bean.getExpectedDuration());
063                    query.setParameter("slaConfig", bean.getSlaConfig());
064                    query.setParameter("notificationMsg", bean.getNotificationMsg());
065                    query.setParameter("upstreamApps", bean.getUpstreamApps());
066                    query.setParameter("appType", bean.getAppType().toString());
067                    query.setParameter("appName", bean.getAppName());
068                    query.setParameter("user", bean.getUser());
069                    query.setParameter("parentId", bean.getParentId());
070                    query.setParameter("jobData", bean.getJobData());
071                    break;
072                default:
073                    throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
074                            + namedQuery.name());
075            }
076            return query;
077        }
078    
079        @Override
080        public Query getSelectQuery(SLARegQuery namedQuery, EntityManager em, Object... parameters)
081                throws JPAExecutorException {
082            Query query = em.createNamedQuery(namedQuery.name());
083            switch (namedQuery) {
084                case GET_SLA_REG_ALL:
085                case GET_SLA_REG_ON_RESTART:
086                    query.setParameter("id", parameters[0]);
087                    break;
088                default:
089                    throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot set parameters for "
090                            + namedQuery.name());
091            }
092            return query;
093        }
094    
095        @Override
096        public int executeUpdate(SLARegQuery namedQuery, SLARegistrationBean jobBean) throws JPAExecutorException {
097            JPAService jpaService = Services.get().get(JPAService.class);
098            EntityManager em = jpaService.getEntityManager();
099            Query query = getUpdateQuery(namedQuery, jobBean, em);
100            int ret = jpaService.executeUpdate(namedQuery.name(), query, em);
101            return ret;
102        }
103    
104        @Override
105        public SLARegistrationBean get(SLARegQuery namedQuery, Object... parameters) throws JPAExecutorException {
106            JPAService jpaService = Services.get().get(JPAService.class);
107            EntityManager em = jpaService.getEntityManager();
108            Query query = getSelectQuery(namedQuery, em, parameters);
109            Object ret = jpaService.executeGet(namedQuery.name(), query, em);
110            if (ret == null && !namedQuery.equals(SLARegQuery.GET_SLA_REG_ALL)) {
111                throw new JPAExecutorException(ErrorCode.E0604, query.toString());
112            }
113            SLARegistrationBean bean = constructBean(namedQuery, ret, parameters);
114            return bean;
115        }
116    
117        @Override
118        public List<SLARegistrationBean> getList(SLARegQuery namedQuery, Object... parameters) throws JPAExecutorException {
119            JPAService jpaService = Services.get().get(JPAService.class);
120            EntityManager em = jpaService.getEntityManager();
121            Query query = getSelectQuery(namedQuery, em, parameters);
122            @SuppressWarnings("unchecked")
123            List<SLARegistrationBean> beanList = (List<SLARegistrationBean>) jpaService.executeGetList(namedQuery.name(),
124                    query, em);
125            return beanList;
126        }
127    
128        private SLARegistrationBean constructBean(SLARegQuery namedQuery, Object ret, Object... parameters)
129                throws JPAExecutorException {
130            SLARegistrationBean bean;
131            Object[] arr;
132            switch (namedQuery) {
133                case GET_SLA_REG_ALL:
134                    bean = (SLARegistrationBean) ret;
135                    if(bean != null) {
136                        bean.setSlaConfig(bean.getSlaConfig());
137                    }
138                    break;
139                case GET_SLA_REG_ON_RESTART:
140                    bean = new SLARegistrationBean();
141                    arr = (Object[]) ret;
142                    bean.setNotificationMsg((String) arr[0]);
143                    bean.setUpstreamApps((String) arr[1]);
144                    bean.setSlaConfig((String) arr[2]);
145                    bean.setJobData((String) arr[3]);
146                    break;
147                default:
148                    throw new JPAExecutorException(ErrorCode.E0603, "QueryExecutor cannot construct job bean for "
149                            + namedQuery.name());
150            }
151            return bean;
152        }
153    
154        @Override
155        public Object getSingleValue(SLARegQuery namedQuery, Object... parameters) throws JPAExecutorException {
156            throw new UnsupportedOperationException();
157        }
158    }