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.ValidationTestResultDAO;
23 import org.akraino.validation.ui.entity.LabInfo;
24 import org.akraino.validation.ui.entity.Submission;
25 import org.akraino.validation.ui.entity.ValidationDbTestResult;
26 import org.hibernate.Criteria;
27 import org.hibernate.Session;
28 import org.hibernate.SessionFactory;
29 import org.hibernate.criterion.Restrictions;
30 import org.onap.portalsdk.core.logging.logic.EELFLoggerDelegate;
31 import org.springframework.beans.factory.annotation.Autowired;
32 import org.springframework.stereotype.Repository;
35 public class ValidationTestResultDAOImpl implements ValidationTestResultDAO {
37 private static final EELFLoggerDelegate LOGGER = EELFLoggerDelegate.getLogger(ValidationTestResultDAOImpl.class);
40 private SessionFactory sessionFactory;
42 protected Session getSession() {
43 return sessionFactory.getCurrentSession();
47 public List<ValidationDbTestResult> getValidationTestResults() {
48 Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
49 return criteria.list();
53 public ValidationDbTestResult getValidationTestResult(@Nonnull Integer resultId) {
54 Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
55 criteria.add(Restrictions.eq("id", String.valueOf(resultId)));
56 return criteria.list() == null ? null : (ValidationDbTestResult) criteria.list().get(0);
60 public List<ValidationDbTestResult> getValidationTestResults(String blueprintName, String version, LabInfo labInfo,
61 Boolean allLayers, Boolean optional, Boolean outcome) {
62 Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
63 if (blueprintName != null) {
64 criteria.add(Restrictions.eq("blueprintName", String.valueOf(blueprintName)));
66 if (version != null) {
67 criteria.add(Restrictions.eq("version", String.valueOf(version)));
69 if (labInfo != null) {
70 criteria.add(Restrictions.eq("lab", labInfo));
72 if (allLayers != null) {
73 criteria.add(Restrictions.eq("allLayers", allLayers));
75 if (optional != null) {
76 criteria.add(Restrictions.eq("optional", optional));
78 if (outcome != null) {
79 criteria.add(Restrictions.eq("result", outcome));
81 return criteria.list() == null || criteria.list().size() == 0 ? null
82 : (List<ValidationDbTestResult>) criteria.list();
86 public ValidationDbTestResult getValidationTestResult(LabInfo labInfo, String timestamp) {
87 Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
88 if (labInfo != null) {
89 criteria.add(Restrictions.eq("lab", labInfo));
91 if (timestamp != null) {
92 criteria.add(Restrictions.eq("timestamp", timestamp));
94 return criteria.list() == null || criteria.list().size() == 0 ? null
95 : (ValidationDbTestResult) criteria.list().get(0);
99 public ValidationDbTestResult getValidationTestResult(@Nonnull Submission submission) {
100 Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
101 criteria.add(Restrictions.eq("submission", submission));
102 return criteria.list() == null || criteria.list().size() == 0 ? null
103 : (ValidationDbTestResult) criteria.list().get(0);
107 public void saveOrUpdate(@Nonnull ValidationDbTestResult vResult) {
108 getSession().saveOrUpdate(vResult);
109 getSession().flush();
113 public void merge(@Nonnull ValidationDbTestResult vResult) {
114 getSession().merge(vResult);
115 getSession().flush();
119 public void deleteValidationTestResult(@Nonnull ValidationDbTestResult vResult) {
120 getSession().delete(vResult);
121 getSession().flush();
125 public void deleteValidationTestResult(@Nonnull LabInfo labInfo, @Nonnull String timestamp) {
126 Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
127 criteria.add(Restrictions.eq("lab", labInfo));
128 criteria.add(Restrictions.eq("timestamp", timestamp));
129 if (criteria.list() == null || criteria.list().size() == 0) {
132 getSession().delete(criteria.list().get(0));
133 getSession().flush();
137 public void deleteAll() {
138 if (getSession().createQuery("delete from ValidationTestResult").executeUpdate() > 0) {
139 LOGGER.info(EELFLoggerDelegate.applicationLogger, "All validation test results are cleaned up");
140 getSession().flush();