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

License:Open Source License

@Override
public List<Long> findNonBoundCampaign(Collection<Long> nodeIds, Long milestoneId) {
    Query q = currentSession().getNamedQuery("campaign.findNonBoundCampaign");
    q.setParameterList("nodeIds", nodeIds, LongType.INSTANCE);
    q.setParameter("milestoneId", milestoneId);
    return q.list();
}

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

License:Open Source License

@Override
public List<Long> findCampaignIdsHavingMultipleMilestones(List<Long> nodeIds) {
    Query q = currentSession().getNamedQuery("campaign.findCampaignIdsHavingMultipleMilestones");
    q.setParameterList("nodeIds", nodeIds, LongType.INSTANCE);
    return q.list();
}

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

License:Open Source License

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

    if (!campaignIds.isEmpty()) {
        Query query = getSession().createSQLQuery(NativeQueries.CAMPAIGN_SQL_UNBIND_MILESTONE);
        query.setParameterList("campaignIds", campaignIds, LongType.INSTANCE);
        query.setParameter("milestoneId", milestoneId);
        query.executeUpdate();//from w  w  w. jav a2  s.  c  o  m
    }

}

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

License:Open Source License

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

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

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<Long[]> findPairedContentForList(final List<Long> ids) {

    if (ids.isEmpty()) {
        return Collections.emptyList();
    }/*  w w w. j  a  v a2s .  c o  m*/

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   ww w.j av a2  s . c  o  m*/
public List<Long> findContentForList(List<Long> ids) {
    if (ids.isEmpty()) {
        return Collections.emptyList();
    }

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

License:Open Source License

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

        @Override// w  ww .  ja  v  a 2s.co  m
        public void setQueryParameters(Query query) {
            query.setParameter("contentId", id, LongType.INSTANCE);
        }
    };
    return executeEntityNamedQuery("campaignFolder.findParentOf", newCallBack);

}

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from  www  .  j av  a 2 s. c  o m
public List<String> getParentsName(long entityId) {
    SQLQuery query = currentSession().createSQLQuery(NativeQueries.CLN_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.HibernateCampaignLibraryNodeDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/* w  w  w. j ava 2 s. co  m*/
public List<Long> getParentsIds(long entityId) {
    SQLQuery query = currentSession().createSQLQuery(NativeQueries.CLN_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.HibernateDeletionDao.java

License:Open Source License

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