PropertyManager.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package edu.msu.nscl.olog;

import java.util.*;
import javax.persistence.EntityManager;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.*;
import javax.ws.rs.core.Response;

/**
 *
 * @author berryman
 */
public class PropertyManager {

    private PropertyManager() {
    }

    /**
     * Returns the list of tags in the database.
     *
     * @return Tags
     * @throws OlogException wrapping an SQLException
     */
    public static Set<Property> findAll() throws OlogException {
        EntityManager em = JPAUtil.getEntityManagerFactory().createEntityManager();
        try {
            em.getTransaction().begin();

            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<Property> cq = cb.createQuery(Property.class);
            Root<Property> from = cq.from(Property.class);
            CriteriaQuery<Property> select = cq.select(from);
            Predicate statusPredicate = cb.equal(from.get(Property_.state), State.Active);
            select.where(statusPredicate);
            select.orderBy(cb.asc(from.get(Property_.name)));
            TypedQuery<Property> typedQuery = em.createQuery(select);
            Set<Property> result = new HashSet<Property>();
            List<Property> rs = typedQuery.getResultList();
            if (rs != null) {
                Iterator<Property> iterator = rs.iterator();
                while (iterator.hasNext()) {
                    result.add(iterator.next());
                }
            }
            em.getTransaction().commit();
            return result;
        } catch (Exception e) {
            throw new OlogException(Response.Status.INTERNAL_SERVER_ERROR,
                    "JPA exception: " + e);
        } finally {
            try {
                if (em.getTransaction() != null && !em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
            } catch (Exception e) {
            }
            em.close();
        }
    }

    /**
     * Finds a tag in the database by name.
     *
     * @return Tag
     * @throws OlogException wrapping an SQLException
     */
    public static Property findProperty(String propertyName) throws OlogException {
        EntityManager em = JPAUtil.getEntityManagerFactory().createEntityManager();

        try {
            em.getTransaction().begin();
            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<Property> cq = cb.createQuery(Property.class);
            Root<Property> from = cq.from(Property.class);
            CriteriaQuery<Property> select = cq.select(from);
            Predicate namePredicate = cb.equal(from.get(Property_.name), propertyName);
            //Predicate statusPredicate = cb.equal(from.get("state"), State.Active);
            select.where(namePredicate);
            select.orderBy(cb.asc(from.get(Property_.name)));
            TypedQuery<Property> typedQuery = em.createQuery(select);
            Property result = null;
            List<Property> rs = typedQuery.getResultList();
            if (rs != null) {
                Iterator<Property> iterator = rs.iterator();
                while (iterator.hasNext()) {
                    result = iterator.next();
                }
            }
            em.getTransaction().commit();
            return result;
        } catch (Exception e) {
            throw new OlogException(Response.Status.INTERNAL_SERVER_ERROR,
                    "JPA exception: " + e);
        } finally {
            try {
                if (em.getTransaction() != null && !em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
            } catch (Exception e) {
            }
            em.close();
        }
    }

    /**
     * Creates a property in the database.
     *
     * @param name name of property
     * @param owner owner of property
     * @throws OlogException wrapping an SQLException
     */
    public static Property create(String propertyName) throws OlogException {
        EntityManager em = JPAUtil.getEntityManagerFactory().createEntityManager();
        try {
            em.getTransaction().begin();

            Property newProperty = new Property();
            Property property = findProperty(propertyName);
            if (property != null) {
                property.setState(State.Active);
                property = em.merge(property);
                em.getTransaction().commit();
                return property;
            } else {
                newProperty.setName(propertyName);
                newProperty.setState(State.Active);
                em.persist(newProperty);
                em.getTransaction().commit();
                return newProperty;
            }
        } catch (Exception e) {
            throw new OlogException(Response.Status.INTERNAL_SERVER_ERROR,
                    "JPA exception: " + e);
        } finally {
            try {
                if (em.getTransaction() != null && !em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
            } catch (Exception e) {
            }
            em.close();
        }
    }

    /**
     * Creates a property in the database.
     *
     * @param name name of property
     * @param attributes attributes of property
     * @throws OlogException wrapping an SQLException
     */
    public static Property create(Property property) throws OlogException {
        EntityManager em = JPAUtil.getEntityManagerFactory().createEntityManager();

        try {
            em.getTransaction().begin();

        /*    if (property.getAttributes() != null) {
                Iterator<Attribute> iterator = property.getAttributes().iterator();
                while (iterator.hasNext()) {
                    Attribute att = AttributeManager.findAttribute(property, iterator.next().getName());
                    if (att.getId() != null) {
                        property.addAttribute(att);
                    }
                }

            }*/
            Property Inactiveproperty = findProperty(property.getName());
            if (Inactiveproperty != null) {
                Inactiveproperty.setState(State.Active);
                Inactiveproperty = em.merge(Inactiveproperty);
                em.getTransaction().commit();
                return Inactiveproperty;
            } else {
                Property newProperty = new Property();
                newProperty.setName(property.getName());
                newProperty.setState(State.Active);
                em.persist(newProperty);
                em.getTransaction().commit();
                return newProperty;
            }
        } catch (Exception e) {

            throw new OlogException(Response.Status.INTERNAL_SERVER_ERROR,
                    "JPA exception: " + e);
        } finally {
            try {
                if (em.getTransaction() != null && !em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
            } catch (Exception e) {
            }
            em.close();
        }
    }

    /**
     * Remove a property (mark as Inactive).
     *
     * @param name property name
     */
    public static void remove(String propertyName) throws OlogException {
        EntityManager em = JPAUtil.getEntityManagerFactory().createEntityManager();

        try {
            em.getTransaction().begin();
            Property property = findProperty(propertyName);
            property.setState(State.Inactive);
            if (property.getAttributes() != null) {
                Set<Attribute> attributes = property.getAttributes();
                Iterator<Attribute> iterator = attributes.iterator();
                while (iterator.hasNext()) {
                    Attribute attribute = iterator.next();
                    attribute.setState(State.Inactive);
                    em.merge(attribute);
                }
            }
            em.merge(property);
            em.getTransaction().commit();
        } catch (Exception e) {
            throw new OlogException(Response.Status.INTERNAL_SERVER_ERROR,
                    "JPA exception: " + e);

        } finally {
            try {
                if (em.getTransaction() != null && !em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
            } catch (Exception e) {
            }
            em.close();
        }
    }
}