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

Example 21 with WorkflowCatalogQueryGenerator

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

the class WorkflowOutputResource method get.

public List<WorkflowCatalogResource> get(String fieldName, Object value) throws WorkflowCatalogException {
    List<WorkflowCatalogResource> wfOutputResources = new ArrayList<WorkflowCatalogResource>();
    EntityManager em = null;
    try {
        em = WorkflowCatalogJPAUtils.getEntityManager();
        em.getTransaction().begin();
        Query q;
        WorkflowCatalogQueryGenerator generator = new WorkflowCatalogQueryGenerator(WORKFLOW_OUTPUT);
        List results;
        if (fieldName.equals(WorkflowOutputConstants.WF_TEMPLATE_ID)) {
            generator.setParameter(WorkflowOutputConstants.WF_TEMPLATE_ID, value);
            q = generator.selectQuery(em);
            results = q.getResultList();
            if (results.size() != 0) {
                for (Object result : results) {
                    WorkflowOutput wfOutput = (WorkflowOutput) result;
                    WorkflowOutputResource workflowOutputResource = (WorkflowOutputResource) WorkflowCatalogJPAUtils.getResource(WorkflowCatalogResourceType.WORKFLOW_OUTPUT, wfOutput);
                    wfOutputResources.add(workflowOutputResource);
                }
            }
        } else if (fieldName.equals(WorkflowOutputConstants.OUTPUT_KEY)) {
            generator.setParameter(WorkflowOutputConstants.OUTPUT_KEY, value);
            q = generator.selectQuery(em);
            results = q.getResultList();
            if (results.size() != 0) {
                for (Object result : results) {
                    WorkflowOutput workflowOutput = (WorkflowOutput) result;
                    WorkflowOutputResource workflowOutputResource = (WorkflowOutputResource) WorkflowCatalogJPAUtils.getResource(WorkflowCatalogResourceType.WORKFLOW_OUTPUT, workflowOutput);
                    wfOutputResources.add(workflowOutputResource);
                }
            }
        } else if (fieldName.equals(WorkflowOutputConstants.DATA_TYPE)) {
            generator.setParameter(WorkflowOutputConstants.DATA_TYPE, value);
            q = generator.selectQuery(em);
            results = q.getResultList();
            if (results.size() != 0) {
                for (Object result : results) {
                    WorkflowOutput workflowOutput = (WorkflowOutput) result;
                    WorkflowOutputResource workflowOutputResource = (WorkflowOutputResource) WorkflowCatalogJPAUtils.getResource(WorkflowCatalogResourceType.WORKFLOW_OUTPUT, workflowOutput);
                    wfOutputResources.add(workflowOutputResource);
                }
            }
        } else {
            em.getTransaction().commit();
            if (em.isOpen()) {
                if (em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
                em.close();
            }
            logger.error("Unsupported field name for WF Output Resource.", new IllegalArgumentException());
            throw new IllegalArgumentException("Unsupported field name for WF Output 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 wfOutputResources;
}

Example 22 with WorkflowCatalogQueryGenerator

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

the class WorkflowOutputResource 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_OUTPUT);
        generator.setParameter(WorkflowOutputConstants.WF_TEMPLATE_ID, ids.get(WorkflowOutputConstants.WF_TEMPLATE_ID));
        generator.setParameter(WorkflowOutputConstants.OUTPUT_KEY, ids.get(WorkflowOutputConstants.OUTPUT_KEY));
        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 23 with WorkflowCatalogQueryGenerator

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

the class WorkflowResource method get.

@Override
public WorkflowCatalogResource get(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.selectQuery(em);
        Workflow workflow = (Workflow) q.getSingleResult();
        WorkflowResource workflowResource = (WorkflowResource) WorkflowCatalogJPAUtils.getResource(WorkflowCatalogResourceType.WORKFLOW, workflow);
        em.getTransaction().commit();
        if (em.isOpen()) {
            if (em.getTransaction().isActive()) {
                em.getTransaction().rollback();
            }
            em.close();
        }
        return workflowResource;
    } 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 24 with WorkflowCatalogQueryGenerator

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

the class WorkflowResource method getAllIds.

@Override
public List<String> getAllIds() throws WorkflowCatalogException {
    List<String> workflowIds = new ArrayList<String>();
    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;
                workflowIds.add(workflow.getTemplateId());
            }
        }
        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 workflowIds;
}

Example 25 with WorkflowCatalogQueryGenerator

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

the class WorkflowStatusResource 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(WORKFLOW_STATUS);
        List results;
        if (fieldName.equals(WorkflowStatusConstants.TEMPLATE_ID)) {
            generator.setParameter(WorkflowStatusConstants.TEMPLATE_ID, value);
            q = generator.selectQuery(em);
            results = q.getResultList();
            if (results.size() != 0) {
                for (Object result : results) {
                    WorkflowStatus WorkflowStatus = (WorkflowStatus) result;
                    statusResourceIds.add(WorkflowStatus.getTemplateId());
                }
            }
        } else {
            em.getTransaction().commit();
            if (em.isOpen()) {
                if (em.getTransaction().isActive()) {
                    em.getTransaction().rollback();
                }
                em.close();
            }
            logger.error("Unsupported field name for Workflow Status resource.", new IllegalArgumentException());
            throw new IllegalArgumentException("Unsupported field name for Workflow 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;
}