X-Git-Url: https://gerrit.akraino.org/r/gitweb?p=validation.git;a=blobdiff_plain;f=ui%2Fsrc%2Fmain%2Fjava%2Forg%2Fakraino%2Fvalidation%2Fui%2Fdaoimpl%2FValidationTestResultDAOImpl.java;fp=ui%2Fsrc%2Fmain%2Fjava%2Forg%2Fakraino%2Fvalidation%2Fui%2Fdaoimpl%2FValidationTestResultDAOImpl.java;h=ab5e180561a170af879f3e3b89462a0f3373a896;hp=0000000000000000000000000000000000000000;hb=2eba847ebb6acb2686be08eb1cdafc1b12071e7d;hpb=f86b9715d156238532fcb0bf464bd72e9cf7ce96

diff --git a/ui/src/main/java/org/akraino/validation/ui/daoimpl/ValidationTestResultDAOImpl.java b/ui/src/main/java/org/akraino/validation/ui/daoimpl/ValidationTestResultDAOImpl.java
new file mode 100644
index 0000000..ab5e180
--- /dev/null
+++ b/ui/src/main/java/org/akraino/validation/ui/daoimpl/ValidationTestResultDAOImpl.java
@@ -0,0 +1,144 @@
+/*
+ * Copyright (c) 2019 AT&T Intellectual Property. All rights reserved.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License"); you may
+ * not use this file except in compliance with the License. You may obtain
+ * a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+ * implied. See the License for the specific language governing
+ * permissions and limitations under the License.
+ */
+package org.akraino.validation.ui.daoimpl;
+
+import java.util.List;
+
+import javax.annotation.Nonnull;
+
+import org.akraino.validation.ui.dao.ValidationTestResultDAO;
+import org.akraino.validation.ui.entity.LabInfo;
+import org.akraino.validation.ui.entity.Submission;
+import org.akraino.validation.ui.entity.ValidationDbTestResult;
+import org.hibernate.Criteria;
+import org.hibernate.Session;
+import org.hibernate.SessionFactory;
+import org.hibernate.criterion.Restrictions;
+import org.onap.portalsdk.core.logging.logic.EELFLoggerDelegate;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Repository;
+
+@Repository
+public class ValidationTestResultDAOImpl implements ValidationTestResultDAO {
+
+    private static final EELFLoggerDelegate LOGGER = EELFLoggerDelegate.getLogger(ValidationTestResultDAOImpl.class);
+
+    @Autowired
+    private SessionFactory sessionFactory;
+
+    protected Session getSession() {
+        return sessionFactory.getCurrentSession();
+    }
+
+    @Override
+    public List<ValidationDbTestResult> getValidationTestResults() {
+        Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
+        return criteria.list();
+    }
+
+    @Override
+    public ValidationDbTestResult getValidationTestResult(@Nonnull Integer resultId) {
+        Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
+        criteria.add(Restrictions.eq("id", String.valueOf(resultId)));
+        return criteria.list() == null ? null : (ValidationDbTestResult) criteria.list().get(0);
+    }
+
+    @Override
+    public List<ValidationDbTestResult> getValidationTestResults(String blueprintName, String version, LabInfo labInfo,
+            Boolean allLayers, Boolean optional, Boolean outcome) {
+        Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
+        if (blueprintName != null) {
+            criteria.add(Restrictions.eq("blueprintName", String.valueOf(blueprintName)));
+        }
+        if (version != null) {
+            criteria.add(Restrictions.eq("version", String.valueOf(version)));
+        }
+        if (labInfo != null) {
+            criteria.add(Restrictions.eq("lab", labInfo));
+        }
+        if (allLayers != null) {
+            criteria.add(Restrictions.eq("allLayers", allLayers));
+        }
+        if (optional != null) {
+            criteria.add(Restrictions.eq("optional", optional));
+        }
+        if (outcome != null) {
+            criteria.add(Restrictions.eq("result", outcome));
+        }
+        return criteria.list() == null || criteria.list().size() == 0 ? null
+                : (List<ValidationDbTestResult>) criteria.list();
+    }
+
+    @Override
+    public ValidationDbTestResult getValidationTestResult(LabInfo labInfo, String timestamp) {
+        Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
+        if (labInfo != null) {
+            criteria.add(Restrictions.eq("lab", labInfo));
+        }
+        if (timestamp != null) {
+            criteria.add(Restrictions.eq("timestamp", timestamp));
+        }
+        return criteria.list() == null || criteria.list().size() == 0 ? null
+                : (ValidationDbTestResult) criteria.list().get(0);
+    }
+
+    @Override
+    public ValidationDbTestResult getValidationTestResult(@Nonnull Submission submission) {
+        Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
+        criteria.add(Restrictions.eq("submission", submission));
+        return criteria.list() == null || criteria.list().size() == 0 ? null
+                : (ValidationDbTestResult) criteria.list().get(0);
+    }
+
+    @Override
+    public void saveOrUpdate(@Nonnull ValidationDbTestResult vResult) {
+        getSession().saveOrUpdate(vResult);
+        getSession().flush();
+    }
+
+    @Override
+    public void merge(@Nonnull ValidationDbTestResult vResult) {
+        getSession().merge(vResult);
+        getSession().flush();
+    }
+
+    @Override
+    public void deleteValidationTestResult(@Nonnull ValidationDbTestResult vResult) {
+        getSession().delete(vResult);
+        getSession().flush();
+    }
+
+    @Override
+    public void deleteValidationTestResult(@Nonnull LabInfo labInfo, @Nonnull String timestamp) {
+        Criteria criteria = getSession().createCriteria(ValidationDbTestResult.class);
+        criteria.add(Restrictions.eq("lab", labInfo));
+        criteria.add(Restrictions.eq("timestamp", timestamp));
+        if (criteria.list() == null || criteria.list().size() == 0) {
+            return;
+        }
+        getSession().delete(criteria.list().get(0));
+        getSession().flush();
+    }
+
+    @Override
+    public void deleteAll() {
+        if (getSession().createQuery("delete from ValidationTestResult").executeUpdate() > 0) {
+            LOGGER.info(EELFLoggerDelegate.applicationLogger, "All validation test results are cleaned up");
+            getSession().flush();
+        }
+    }
+
+}