Examples with WorkflowCatalogQueryGenerator org.apache.airavata.registry.core.workflow.catalog.utils.WorkflowCatalogQueryGenerator used on opensource projects

Example 6 with WorkflowCatalogQueryGenerator

use of org.apache.airavata.registry.core.workflow.catalog.utils.WorkflowCatalogQueryGenerator in project airavata by apache.

the class WorkflowResource method getIds.

@Override
public List<String> getIds(String fieldName, Object value) throws WorkflowCatalogException {
    List<String> workflowResourceIDs = new ArrayList<String>();
    EntityManager em = null;
    try {
        em = WorkflowCatalogJPAUtils.getEntityManager();
        em.getTransaction().begin();
        WorkflowCatalogQueryGenerator generator = new WorkflowCatalogQueryGenerator(WORKFLOW);
        Query q;
        if ((fieldName.equals(WorkflowConstants.TEMPLATE_ID)) || (fieldName.equals(WorkflowConstants.GATEWAY_ID))) {
            generator.setParameter(fieldName, value);
            q = generator.selectQuery(em);
            List<?> results = q.getResultList();
            for (Object result : results) {
                Workflow workflow = (Workflow) result;
                WorkflowResource workflowResource = (WorkflowResource) WorkflowCatalogJPAUtils.getResource(WorkflowCatalogResourceType.WORKFLOW, workflow);
                workflowResourceIDs.add(workflowResource.getWfTemplateId());
            }
        } else {
            em.getTransaction().commit();
            if (em.isOpen()) {
                if (em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
                em.close();
            }
            logger.error("Unsupported field name for Workflow Resource.", new IllegalArgumentException());
            throw new IllegalArgumentException("Unsupported field name for Workflow Resource.");
        }
        em.getTransaction().commit();
        if (em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    } catch (ApplicationSettingsException e) {
        logger.error(e.getMessage(), e);
        throw new WorkflowCatalogException(e);
    } finally {
        if (em != null && em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    }
    return workflowResourceIDs;
}

Example 7 with WorkflowCatalogQueryGenerator

use of org.apache.airavata.registry.core.workflow.catalog.utils.WorkflowCatalogQueryGenerator in project airavata by apache.

the class WorkflowResource method remove.

@Override
public void remove(Object identifier) throws WorkflowCatalogException {
    EntityManager em = null;
    try {
        em = WorkflowCatalogJPAUtils.getEntityManager();
        em.getTransaction().begin();
        WorkflowCatalogQueryGenerator generator = new WorkflowCatalogQueryGenerator(WORKFLOW);
        generator.setParameter(WorkflowConstants.TEMPLATE_ID, identifier);
        Query q = generator.deleteQuery(em);
        q.executeUpdate();
        em.getTransaction().commit();
        if (em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    } catch (ApplicationSettingsException e) {
        logger.error(e.getMessage(), e);
        throw new WorkflowCatalogException(e);
    } finally {
        if (em != null && em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    }
}

Example 8 with WorkflowCatalogQueryGenerator

use of org.apache.airavata.registry.core.workflow.catalog.utils.WorkflowCatalogQueryGenerator in project airavata by apache.

the class WorkflowResource method getAll.

@Override
public List<WorkflowCatalogResource> getAll() throws WorkflowCatalogException {
    List<WorkflowCatalogResource> workflows = new ArrayList<WorkflowCatalogResource>();
    EntityManager em = null;
    try {
        em = WorkflowCatalogJPAUtils.getEntityManager();
        em.getTransaction().begin();
        WorkflowCatalogQueryGenerator generator = new WorkflowCatalogQueryGenerator(WORKFLOW);
        generator.setParameter(WorkflowConstants.GATEWAY_ID, gatewayId);
        Query q = generator.selectQuery(em);
        List results = q.getResultList();
        if (results.size() != 0) {
            for (Object result : results) {
                Workflow workflow = (Workflow) result;
                WorkflowResource wfResource = (WorkflowResource) WorkflowCatalogJPAUtils.getResource(WorkflowCatalogResourceType.WORKFLOW, workflow);
                workflows.add(wfResource);
            }
        }
        em.getTransaction().commit();
        if (em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    } catch (Exception e) {
        logger.error(e.getMessage(), e);
        throw new WorkflowCatalogException(e);
    } finally {
        if (em != null && em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    }
    return workflows;
}

Example 9 with WorkflowCatalogQueryGenerator

use of org.apache.airavata.registry.core.workflow.catalog.utils.WorkflowCatalogQueryGenerator in project airavata by apache.

the class WorkflowStatusResource method remove.

public void remove(Object identifier) throws WorkflowCatalogException {
    HashMap<String, String> ids;
    if (identifier instanceof Map) {
        ids = (HashMap) identifier;
    } else {
        logger.error("Identifier should be a map with the field name and it's value");
        throw new WorkflowCatalogException("Identifier should be a map with the field name and it's value");
    }
    EntityManager em = null;
    try {
        em = WorkflowCatalogJPAUtils.getEntityManager();
        em.getTransaction().begin();
        WorkflowCatalogQueryGenerator generator = new WorkflowCatalogQueryGenerator(WORKFLOW_STATUS);
        generator.setParameter(WorkflowStatusConstants.STATUS_ID, ids.get(WorkflowStatusConstants.STATUS_ID));
        generator.setParameter(WorkflowStatusConstants.TEMPLATE_ID, ids.get(WorkflowStatusConstants.TEMPLATE_ID));
        Query q = generator.deleteQuery(em);
        q.executeUpdate();
        em.getTransaction().commit();
        if (em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    } catch (ApplicationSettingsException e) {
        logger.error(e.getMessage(), e);
        throw new WorkflowCatalogException(e);
    } finally {
        if (em != null && em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    }
}

Example 10 with WorkflowCatalogQueryGenerator

use of org.apache.airavata.registry.core.workflow.catalog.utils.WorkflowCatalogQueryGenerator in project airavata by apache.

the class ComponentStatusResource method getIds.

public List<String> getIds(String fieldName, Object value) throws WorkflowCatalogException {
    List<String> statusResourceIds = new ArrayList<String>();
    EntityManager em = null;
    try {
        em = WorkflowCatalogJPAUtils.getEntityManager();
        em.getTransaction().begin();
        Query q;
        WorkflowCatalogQueryGenerator generator = new WorkflowCatalogQueryGenerator(COMPONENT_STATUS);
        List results;
        if (fieldName.equals(ComponentStatusConstants.TEMPLATE_ID)) {
            generator.setParameter(ComponentStatusConstants.TEMPLATE_ID, value);
            q = generator.selectQuery(em);
            results = q.getResultList();
            if (results.size() != 0) {
                for (Object result : results) {
                    ComponentStatus componentStatus = (ComponentStatus) result;
                    statusResourceIds.add(componentStatus.getTemplateId());
                }
            }
        } else {
            em.getTransaction().commit();
            if (em.isOpen()) {
                if (em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
                em.close();
            }
            logger.error("Unsupported field name for Component Status resource.", new IllegalArgumentException());
            throw new IllegalArgumentException("Unsupported field name for Component Status Resource.");
        }
        em.getTransaction().commit();
        if (em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    } catch (Exception e) {
        logger.error(e.getMessage(), e);
        throw new WorkflowCatalogException(e);
    } finally {
        if (em != null && em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
    }
    return statusResourceIds;
}