SceneActionConditionDAO.java

/**
 *  C-Nery - A home automation web application for C-Bus.
 *  Copyright (C) 2008,2009,2012  Dave Oxley <dave@daveoxley.co.uk>.
 *
 *  This program 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/>.
 *
 */

package com.daveoxley.cnery.dao;

import com.daveoxley.cnery.entities.AbstractCondition;
import com.daveoxley.cnery.entities.AbstractCondition.ActionType;
import com.daveoxley.cnery.entities.SceneAction;
import com.daveoxley.cnery.entities.SceneActionCondition;
import java.io.Serializable;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityNotFoundException;
import javax.persistence.NoResultException;
import org.jboss.seam.annotations.AutoCreate;
import org.jboss.seam.annotations.In;
import org.jboss.seam.annotations.Name;

/**
 *
 * @author Dave Oxley <dave@daveoxley.co.uk>
 */
@Name("sceneActionConditionDAO")
@AutoCreate
public class SceneActionConditionDAO implements Serializable {

    @In
    protected EntityManager entityManager;

    public SceneActionCondition findSceneActionCondition(Long sceneActionConditionId) {
        try {
            StringBuilder query = new StringBuilder("select sac from SceneActionCondition sac where sac.id = :sceneActionConditionId");
            return (SceneActionCondition) entityManager
                    .createQuery(query.toString())
                    .setParameter("sceneActionConditionId", sceneActionConditionId)
                    .getSingleResult();
        } catch (EntityNotFoundException ex) {
        } catch (NoResultException ex) {
        }
        return null;
    }

    public List<SceneActionCondition> findSceneActionConditions() {
        try {
            return entityManager
                    .createQuery("select sac from SceneActionCondition sac")
                    .getResultList();
        } catch (EntityNotFoundException ex) {
        } catch (NoResultException ex) {
        }
        return null;
    }

    public List<SceneActionCondition> findSceneActionConditionsBySceneAction(SceneAction sceneAction) {
        try {
            return entityManager
                    .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction")
                    .setParameter("sceneAction", sceneAction)
                    .getResultList();
        } catch (EntityNotFoundException ex) {
        } catch (NoResultException ex) {
        }
        return null;
    }

    public List<SceneActionCondition> findLogicSceneActionConditions(SceneAction sceneAction, SceneActionCondition parent) {
        try {
            if (parent == null) {
                return entityManager
                        .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction and sac.actionType = :actionType and sac.parent is null")
                        .setParameter("sceneAction", sceneAction)
                        .setParameter("actionType", ActionType.LOGIC)
                        .getResultList();
            }
            else {
                return entityManager
                        .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction and sac.actionType = :actionType and sac.parent = :parent")
                        .setParameter("sceneAction", sceneAction)
                        .setParameter("actionType", ActionType.LOGIC)
                        .setParameter("parent", parent)
                        .getResultList();
            }
        } catch (EntityNotFoundException ex) {
        } catch (NoResultException ex) {
        }
        return null;
    }

    public List<SceneActionCondition> findNonLogicSceneActionConditions(SceneAction sceneAction, SceneActionCondition parent) {
        try {
            if (parent == null) {
                return entityManager
                        .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction and sac.actionType != :actionType and sac.parent is null")
                        .setParameter("sceneAction", sceneAction)
                        .setParameter("actionType", ActionType.LOGIC)
                        .getResultList();
            }
            else {
                return entityManager
                        .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction and sac.actionType != :actionType and sac.parent = :parent")
                        .setParameter("sceneAction", sceneAction)
                        .setParameter("actionType", ActionType.LOGIC)
                        .setParameter("parent", parent)
                        .getResultList();
            }
        } catch (EntityNotFoundException ex) {
        } catch (NoResultException ex) {
        }
        return null;
    }

    public List<SceneActionCondition> findSceneActionConditions(SceneAction sceneAction, SceneActionCondition parent) {
        try {
            if (parent == null) {
                return entityManager
                        .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction and sac.parent is null")
                        .setParameter("sceneAction", sceneAction)
                        .getResultList();
            }
            else {
                return entityManager
                        .createQuery("select sac from SceneActionCondition sac where sac.sceneAction = :sceneAction and sac.parent = :parent")
                        .setParameter("sceneAction", sceneAction)
                        .setParameter("parent", parent)
                        .getResultList();
            }
        } catch (EntityNotFoundException ex) {
        } catch (NoResultException ex) {
        }
        return null;
    }
}