/*
* Tanaguru - Automated webpage assessment
* Copyright (C) 2008-2015 Tanaguru.org
*
* This file is part of Tanaguru.
*
* Tanaguru is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
* Contact us by mail: tanaguru AT tanaguru DOT org
*/
package org.tanaguru.entity.dao.audit;
import java.util.List;
import javax.persistence.NoResultException;
import javax.persistence.Query;
import org.tanaguru.entity.audit.Audit;
import org.tanaguru.entity.audit.AuditImpl;
import org.tanaguru.entity.audit.AuditStatus;
import org.tanaguru.sdk.entity.dao.jpa.AbstractJPADAO;
/**
*
* @author jkowalczyk
*/
public class AuditDAOImpl extends AbstractJPADAO<Audit, Long> implements
AuditDAO {
public AuditDAOImpl() {
super();
}
@Override
public List<Audit> findAll() {
List<Audit> auditList = super.findAll();
return auditList;
}
@Override
public List<Audit> findAll(AuditStatus status) {
Query query = entityManager.createQuery("SELECT o FROM "
+ getEntityClass().getName() + " o"
+ " LEFT JOIN FETCH o.subject"
+ " WHERE o.status = :status");
query.setParameter("status", status);
return (List<Audit>)query.getResultList();
}
@Override
protected Class<AuditImpl> getEntityClass() {
return AuditImpl.class;
}
@Override
public Audit findAuditWithTest(Long id) {
Query query = entityManager.createQuery("SELECT a FROM "
+ getEntityClass().getName() + " a"
+ " LEFT JOIN FETCH a.testList"
+ " WHERE a.id = :id");
query.setParameter("id", id);
try {
return (Audit)query.getSingleResult();
} catch (NoResultException nre) {
return null;
}
}
}