2 * Copyright (c) 2019 AT&T Intellectual Property. All rights reserved.
4 * Licensed under the Apache License, Version 2.0 (the "License"); you may
5 * not use this file except in compliance with the License. You may obtain
6 * a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
13 * implied. See the License for the specific language governing
14 * permissions and limitations under the License.
16 package org.akraino.validation.ui.daoimpl;
18 import java.util.List;
20 import javax.annotation.Nonnull;
22 import org.akraino.validation.ui.dao.SubmissionDAO;
23 import org.akraino.validation.ui.entity.Submission;
24 import org.hibernate.Criteria;
25 import org.hibernate.Session;
26 import org.hibernate.SessionFactory;
27 import org.hibernate.criterion.Restrictions;
28 import org.onap.portalsdk.core.logging.logic.EELFLoggerDelegate;
29 import org.springframework.beans.factory.annotation.Autowired;
30 import org.springframework.stereotype.Repository;
33 public class SubmissionDAOImpl implements SubmissionDAO {
35 private static final EELFLoggerDelegate LOGGER = EELFLoggerDelegate.getLogger(SubmissionDAOImpl.class);
38 private SessionFactory sessionFactory;
40 protected Session getSession() {
41 return sessionFactory.getCurrentSession();
45 public List<Submission> getSubmissions() {
46 Criteria criteria = getSession().createCriteria(Submission.class);
47 criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
48 return criteria.list();
52 public Submission getSubmission(@Nonnull Integer submissionId) {
53 Criteria criteria = getSession().createCriteria(Submission.class);
54 criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
55 criteria.add(Restrictions.eq("id", submissionId));
56 return criteria.list() == null || criteria.list().size() < 1 ? null : (Submission) criteria.list().get(0);
60 public void saveOrUpdate(@Nonnull Submission submission) {
61 getSession().saveOrUpdate(submission);
66 public void merge(@Nonnull Submission submission) {
67 getSession().merge(submission);
72 public void deleteSubmission(@Nonnull Submission submission) {
73 getSession().delete(submission);
78 public void deleteSubmission(@Nonnull Integer submissionId) {
79 getSession().delete(this.getSubmission(submissionId));
84 public void deleteAll() {
85 if (getSession().createQuery("delete from Submission").executeUpdate() > 0) {
86 LOGGER.info(EELFLoggerDelegate.applicationLogger, "All submission entries are cleaned up");