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.HibernateTestCaseDeletionDao.java

License:Open Source License

@Override
public void setExecStepInboundReferencesToNull(List<Long> testStepIds) {
    if (!testStepIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.TESTCASE_SQL_SET_NULL_CALLING_EXECUTION_STEPS);
        query.setParameterList(TEST_STEP_IDS, testStepIds, LongType.INSTANCE);
        query.executeUpdate();/*from   ww w. j a  v  a2 s .  com*/
    }
}

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

License:Open Source License

@Override
public void setExecutionInboundReferencesToNull(List<Long> testCaseIds) {
    if (!testCaseIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.TESTCASE_SQL_SETNULLCALLINGEXECUTIONS);
        query.setParameterList(TEST_CASES_IDS, testCaseIds, LongType.INSTANCE);
        query.executeUpdate();/*from   w ww .  jav  a 2s.  c o m*/
    }
}

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

License:Open Source License

@Override
public void removeFromVerifyingTestCaseLists(List<Long> testCaseIds) {
    if (!testCaseIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.TESTCASE_SQL_REMOVEVERIFYINGTESTCASELIST);
        query.setParameterList(TEST_CASES_IDS, testCaseIds, LongType.INSTANCE);
        query.executeUpdate();/*www . j  a v  a  2 s  .  c om*/

    }
}

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

License:Open Source License

@Override
public void removeFromVerifyingTestStepsList(List<Long> testStepIds) {
    if (!testStepIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.TESTCASE_SQL_REMOVEVERIFYINGTESTSTEPLIST);
        query.setParameterList(TEST_STEP_IDS, testStepIds, LongType.INSTANCE);
        query.executeUpdate();/*  w  w  w . j  a va  2  s.co m*/

    }
}

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

License:Open Source License

@Override
public void unbindFromMilestone(List<Long> testCaseIds, Long milestoneId) {

    if (!testCaseIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.TESTCASE_SQL_UNBIND_MILESTONE);
        query.setParameterList("testCaseIds", testCaseIds, LongType.INSTANCE);
        query.setParameter("milestoneId", milestoneId);
        query.executeUpdate();/*w  ww  . j  av  a 2  s . c  o m*/
    }

}

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

License:Open Source License

@Override
public List<Long> findTestCasesWhichMilestonesForbidsDeletion(List<Long> originalId) {
    if (!originalId.isEmpty()) {
        MilestoneStatus[] lockedStatuses = new MilestoneStatus[] { MilestoneStatus.PLANNED,
                MilestoneStatus.LOCKED };
        Query query = getSession().getNamedQuery("testCase.findTestCasesWhichMilestonesForbidsDeletion");
        query.setParameterList("testCaseIds", originalId, LongType.INSTANCE);
        query.setParameterList("lockedStatuses", lockedStatuses);
        return query.list();
    } else {/* ww  w.  j  av  a  2s.c om*/
        return new ArrayList<>();
    }
}

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

License:Open Source License

@Override
public List<Long[]> findPairedContentForList(final List<Long> ids) {
    if (ids.isEmpty()) {
        return Collections.emptyList();
    }/*w ww . j  a  va 2 s.c om*/

    SQLQuery query = currentSession()
            .createSQLQuery(NativeQueries.TEST_CASE_FOLDER_SQL_FIND_PAIRED_CONTENT_FOR_FOLDERS);
    query.setParameterList("folderIds", ids, LongType.INSTANCE);
    query.addScalar("ancestor_id", LongType.INSTANCE);
    query.addScalar("descendant_id", LongType.INSTANCE);

    List<Object[]> result = query.list();

    return toArrayOfLong(result);
}

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

License:Open Source License

@Override
public List<Long> findContentForList(List<Long> ids) {
    if (ids.isEmpty()) {
        return Collections.emptyList();
    }/* www  .j av a  2s.c  om*/

    SQLQuery query = currentSession()
            .createSQLQuery(NativeQueries.TEST_CASE_FOLDER_SQL_FIND_CONTENT_FOR_FOLDER);
    query.setParameterList("folderIds", ids, LongType.INSTANCE);
    query.addScalar("descendant_id", LongType.INSTANCE);

    return query.list();
}

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

License:Open Source License

@Override
public TestCaseFolder findParentOf(final Long id) {
    SetQueryParametersCallback newCallBack = new SetQueryParametersCallback() {

        @Override//from w w w.java  2s . co m
        public void setQueryParameters(Query query) {
            query.setParameter("contentId", id, LongType.INSTANCE);
        }
    };
    return executeEntityNamedQuery("testCaseFolder.findParentOf", newCallBack);
}

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

License:Open Source License

@Override
public int findPositionOfStep(Long testStepId) {
    Query query = currentSession().getNamedQuery("testStep.findPositionOfStep");
    query.setParameter("stepId", testStepId, LongType.INSTANCE);
    return (Integer) query.uniqueResult();
}