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

License:Open Source License

@Override
public List<Long> filterVersionIdsHavingMultipleMilestones(List<Long> versionIds) {
    if (!versionIds.isEmpty()) {
        Query q = getSession().getNamedQuery("requirementDeletionDao.findVersionIdsHavingMultipleMilestones");
        q.setParameterList(VERSION_IDS, versionIds, LongType.INSTANCE);
        return q.list();
    } else {//from   ww w  . ja v a2  s. co m
        return new ArrayList<>(0);
    }
}

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

License:Open Source License

@Override
public List<Long> findVersionIdsForMilestone(List<Long> requirementIds, Long milestoneId) {
    if (!requirementIds.isEmpty()) {
        Query query = getSession().getNamedQuery("requirementDeletionDao.findAllVersionForMilestone");
        query.setParameterList("nodeIds", requirementIds, LongType.INSTANCE);
        query.setParameter("milestoneId", milestoneId);
        return query.list();
    } else {/*from ww  w .ja  v  a  2  s  .c om*/
        return new ArrayList<>(0);
    }
}

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

License:Open Source License

@Override
public void unbindFromMilestone(List<Long> requirementIds, Long milestoneId) {
    if (!requirementIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.REQUIREMENT_SQL_UNBIND_MILESTONE);
        query.setParameterList(REQUIREMENT_IDS, requirementIds, LongType.INSTANCE);
        query.setParameter("milestoneId", milestoneId);
        query.executeUpdate();//from  w  w  w .  j av a2 s.  co  m
    }

}

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

License:Open Source License

private List<Long> findByRequirementVersion(List<Long> versionIds) {
    if (!versionIds.isEmpty()) {
        Query q = getSession().getNamedQuery("requirement.findByRequirementVersion");
        q.setParameterList(VERSION_IDS, versionIds, LongType.INSTANCE);
        return q.list();
    } else {//from  w  ww  .j a v  a 2  s  . c o m
        return new ArrayList<>(0);
    }
}

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w  ww .j ava  2s.co m*/
public List<Long[]> findPairedContentForList(final List<Long> ids) {

    if (ids.isEmpty()) {
        return Collections.emptyList();
    }

    SQLQuery query = currentSession()
            .createSQLQuery(NativeQueries.REQUIREMENT_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.HibernateRequirementFolderDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//  ww  w .  j  a  v  a  2 s .  c  om
public List<Long> findContentForList(List<Long> ids) {
    if (ids.isEmpty()) {
        return Collections.emptyList();
    }

    SQLQuery query = currentSession()
            .createSQLQuery(NativeQueries.REQUIREMENT_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.HibernateRequirementLibraryNodeDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//  w  w  w .  j  ava  2s.c  o m
public List<String> getParentsName(long entityId) {
    SQLQuery query = currentSession().createSQLQuery(NativeQueries.RLN_FIND_SORTED_PARENT_NAMES);
    query.setParameter(ParameterNames.NODE_ID, entityId, LongType.INSTANCE);
    return query.list();
}

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*  w  w w . j  a v a 2s  .  c o m*/
public List<Long> getParentsIds(long entityId) {
    SQLQuery query = currentSession().createSQLQuery(NativeQueries.RLN_FIND_SORTED_PARENT_IDS);
    query.setResultTransformer(new SqLIdResultTransformer());
    query.setParameter(ParameterNames.NODE_ID, entityId, LongType.INSTANCE);
    return query.list();
}

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

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public void removeOrSetIterationTestPlanInboundReferencesToNull(List<Long> testCaseIds) {

    if (!testCaseIds.isEmpty()) {
        SQLQuery query1 = getSession()//from ww  w .ja  v  a2  s . com
                .createSQLQuery(NativeQueries.TESTCASE_SQL_SELECTCALLINGITERATIONITEMTESTPLANHAVINGEXECUTIONS);
        query1.addScalar("item_test_plan_id", LongType.INSTANCE);
        query1.setParameterList(TEST_CASES_IDS, testCaseIds, LongType.INSTANCE);
        List<Long> itpHavingExecIds = query1.list();

        SQLQuery query2 = getSession().createSQLQuery(
                NativeQueries.TESTCASE_SQL_SELECTCALLINGITERATIONITEMTESTPLANHAVINGNOEXECUTIONS);
        query2.addScalar("item_test_plan_id", LongType.INSTANCE);
        query2.setParameterList(TEST_CASES_IDS, testCaseIds, LongType.INSTANCE);
        List<Long> itpHavingNoExecIds = query2.list();

        setNullCallingIterationItemTestPlanHavingExecutions(itpHavingExecIds);
        removeCallingIterationItemTestPlanHavingNoExecutions(itpHavingNoExecIds);
    }

}

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

License:Open Source License

@SuppressWarnings("unchecked")
private void reorderTestPlan(String selectOffsetQuery, String updateOrderQuery, List<Long> removedItems) {

    Query query0 = getSession().createSQLQuery(selectOffsetQuery);
    query0.setParameterList("removedItemIds1", removedItems);
    query0.setParameterList("removedItemIds2", removedItems);
    List<Object[]> pairIdOffset = query0.list();

    Map<Integer, List<Long>> mapOffsets = buildMapOfOffsetAndIds(pairIdOffset);

    for (Entry<Integer, List<Long>> offsetEntry : mapOffsets.entrySet()) {
        Query query = getSession().createSQLQuery(updateOrderQuery);
        query.setParameter("offset", offsetEntry.getKey(), IntegerType.INSTANCE);
        query.setParameterList("reorderedItemIds", offsetEntry.getValue(), LongType.INSTANCE);
        query.executeUpdate();//from w  ww  .  j  ava  2  s.  c om
    }

}