Example usage for org.hibernate.type LongType INSTANCE

Introduction

In this page you can find the example usage for org.hibernate.type LongType INSTANCE.

Prototype

LongType INSTANCE

To view the source code for org.hibernate.type LongType INSTANCE.

Click Source Link

Usage

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateDeletionDao.java

License:Open Source License

@SuppressWarnings("unchecked")
protected <R> List<R> executeSelectNamedQuery(String namedQuery, String paramName, Collection<Long> ids) {
    if (!ids.isEmpty()) {
        Query query = getSession().getNamedQuery(namedQuery);
        query.setParameterList(paramName, ids, LongType.INSTANCE);
        return query.list();
    } else {//w  w w .  j  ava  2 s.c om
        return Collections.emptyList();
    }
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateDeletionDao.java

License:Open Source License

protected void executeDeleteSQLQuery(String queryString, String paramName, Collection<Long> ids) {
    if (!ids.isEmpty()) {
        Query query = getSession().createSQLQuery(queryString);
        query.setParameterList(paramName, ids, LongType.INSTANCE);
        query.executeUpdate();/* w w  w  .  ja  va  2 s .co  m*/
    }
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateDeletionDao.java

License:Open Source License

@SuppressWarnings("unchecked")
protected <R> List<R> executeSelectSQLQuery(String queryString, String paramName, Collection<Long> ids) {
    if (!ids.isEmpty()) {
        Query query = getSession().createSQLQuery(queryString);
        query.setParameterList(paramName, ids, LongType.INSTANCE);
        return query.list();
    } else {/* w ww .  j a v a  2  s.c  o  m*/
        return Collections.emptyList();
    }
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateExecutionDao.java

License:Open Source License

@Override
public List<ExecutionStep> findExecutionSteps(Collection<Long> executionIds) {
    if (!executionIds.isEmpty()) {
        Query q = currentSession().getNamedQuery("execution.findStepsForAllExecutions");
        q.setParameterList(EXECUTION_IDS, executionIds, LongType.INSTANCE);
        return q.list();
    } else {/*from   ww  w.  j  av  a 2s . c om*/
        return Collections.emptyList();
    }
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateExecutionStepDao.java

License:Open Source License

@Override
public MultiMap findStepExecutionsStatus(List<Long> testCaseIds, List<Long> testStepIds) {
    if (testStepIds.isEmpty()) {
        return new MultiValueMap();
    }//  w w w  .  ja  va  2  s  .  c  o m
    List<ExecutionStep> execSteps = new ArrayList<>();
    for (Long tcId : testCaseIds) {
        Query q = currentSession().getNamedQuery("execution.findAllByTestCaseIdAndItIdOrderByRunDate");
        q.setParameter("testCaseId", tcId, LongType.INSTANCE);
        List<Execution> execs = q.list();
        if (!execs.isEmpty()) {
            execSteps.addAll(execs.get(0).getSteps());
        }
    }
    MultiMap result = new MultiValueMap();
    for (ExecutionStep executionStep : execSteps) {
        if (testStepIds.contains(executionStep.getReferencedTestStep().getId())) {
            result.put(executionStep.getReferencedTestStep().getId(), executionStep);
        }
    }
    return result;
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateIterationDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from  w  w w .  ja  v a  2  s .c  o m*/
public List<TestCaseExecutionStatus> findExecStatusForIterationsAndTestCases(List<Long> testCasesIds,
        List<Long> iterationsIds) {
    if (testCasesIds.isEmpty()) {
        return Collections.emptyList();
    }
    Query q = currentSession().getNamedQuery("iteration.findITPIByTestCaseGroupByStatus");
    q.setParameterList("testCasesIds", testCasesIds, LongType.INSTANCE);
    q.setParameterList("iterationsIds", iterationsIds, LongType.INSTANCE);
    List<TestCaseExecutionStatus> formatedResult = new ArrayList<>();
    List<Object[]> results = q.list();
    for (Object[] result : results) {
        formatedResult.add(new TestCaseExecutionStatus((ExecutionStatus) result[0], (Long) result[1]));
    }
    return formatedResult;
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateIterationDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override// ww w .  jav  a  2s .  c om
public List<Long> findVerifiedTcIdsInIterations(List<Long> testCasesIds, List<Long> iterationsIds) {
    if (testCasesIds.isEmpty()) {
        return Collections.emptyList();
    }
    Query q = currentSession().getNamedQuery("iteration.findVerifiedTcIdsInIterations");
    q.setParameterList("testCasesIds", testCasesIds, LongType.INSTANCE);
    q.setParameterList("iterationsIds", iterationsIds, LongType.INSTANCE);
    return q.list();
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateIterationDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   ww  w. j a  v  a2 s. c  o m*/
public List<Long> findVerifiedTcIdsInIterationsWithExecution(List<Long> tcIds, List<Long> iterationsIds) {
    if (tcIds.isEmpty()) {
        return Collections.emptyList();
    }
    Query q = currentSession().getNamedQuery("iteration.findVerifiedAndExecutedTcIdsInIterations");
    q.setParameterList("testCasesIds", tcIds, LongType.INSTANCE);
    q.setParameterList("iterationsIds", iterationsIds, LongType.INSTANCE);
    return q.list();
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateIterationDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   ww w.jav  a 2 s  .c  o m
public MultiMap findVerifiedITPI(List<Long> tcIds, List<Long> iterationsIds) {
    if (tcIds.isEmpty()) {
        return new MultiValueMap();
    }
    Query q = currentSession().getNamedQuery("iteration.findITPIByTestCaseGroupByStatus");
    q.setParameterList("testCasesIds", tcIds, LongType.INSTANCE);
    q.setParameterList("iterationsIds", iterationsIds, LongType.INSTANCE);
    List<Object[]> itpis = q.list();
    MultiMap result = new MultiValueMap();
    for (Object[] itpi : itpis) {
        TestCaseExecutionStatus tcStatus = new TestCaseExecutionStatus((ExecutionStatus) itpi[0],
                (Long) itpi[1]);
        result.put(tcStatus.getTestCaseId(), tcStatus);
    }
    return result;
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateMilestoneDao.java

License:Open Source License

private boolean doesTestCaseBelongToMilestonesWithStatus(long testCaseId, MilestoneStatus... statuses) {
    Query query = currentSession().getNamedQuery("testCase.findTestCasesWithMilestonesHavingStatuses");
    query.setParameterList("testCaseIds", Arrays.asList(testCaseId), LongType.INSTANCE);
    query.setParameterList("statuses", statuses);
    List<Long> ids = query.list();
    return ids.contains(testCaseId);
}