@Override public Long countContentItems(Criteria c) { c.setProjection(Projections.rowCount()); return (Long) c.uniqueResult(); }
@Override public boolean validateApplicationEventFamilyMap(String appId, String ecfId, int version) { LOG.debug("Validating application event family map by application id [{}], ecf id [{}], " + "version [{}]", appId, ecfId, version); Criteria criteria = getCriteria(); criteria.createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS); criteria.createAlias(ECF_PROPERTY, ECF_ALIAS); criteria.add(Restrictions.and( Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId)), Restrictions.eq(ECF_REFERENCE, Long.valueOf(ecfId)), Restrictions.eq(VERSION_PROPERTY, version))); Long count = (Long) criteria.setProjection(Projections.rowCount()).uniqueResult(); boolean result = count != null ? count == 0 : false; LOG.debug("[{},{},{}] Validation result: {}.", appId, ecfId, version, result); return result; }
public long enabledUserCount() { Long value = (Long) goCache.get(ENABLED_USER_COUNT_CACHE_KEY); if (value != null) { return value; } synchronized (ENABLED_USER_COUNT_CACHE_KEY) { value = (Long) goCache.get(ENABLED_USER_COUNT_CACHE_KEY); if (value == null) { value = hibernateTemplate().execute(session -> (Long) session.createCriteria(User.class).add(Restrictions.eq("enabled", true)).setProjection(Projections.rowCount()).setCacheable(true).uniqueResult()); goCache.put(ENABLED_USER_COUNT_CACHE_KEY, value); } return value; } }
@Override public long findActiveFilterCount(String endpointProfileSchemaId, String serverProfileSchemaId, String groupId) { long count = 0; LOG.debug("Searching active profile filters by endpoint profile schema id [{}], " + "server profile schema id [{}] and group id [{}]", endpointProfileSchemaId, serverProfileSchemaId, groupId); if (isNotBlank(groupId)) { Criteria criteria = getCriteria(); criteria.createAlias(ENDPOINT_PROFILE_SCHEMA_PROPERTY, ENDPOINT_PROFILE_SCHEMA_ALIAS, JoinType.LEFT_OUTER_JOIN); criteria.createAlias(SERVER_PROFILE_SCHEMA_PROPERTY, SERVER_PROFILE_SCHEMA_ALIAS, JoinType.LEFT_OUTER_JOIN); criteria.createAlias(ENDPOINT_GROUP_PROPERTY, ENDPOINT_GROUP_ALIAS); criteria.add(Restrictions.and( Restrictions.eq(ENDPOINT_GROUP_REFERENCE, Long.valueOf(groupId)), buildEqIdCriterion(ENDPOINT_PROFILE_SCHEMA_REFERENCE, endpointProfileSchemaId), buildEqIdCriterion(SERVER_PROFILE_SCHEMA_REFERENCE, serverProfileSchemaId), Restrictions.eq(STATUS_PROPERTY, UpdateStatus.ACTIVE))); count = (Long) criteria.setProjection(Projections.rowCount()).uniqueResult(); } LOG.debug("[{},{},{}] Search result: {}.", endpointProfileSchemaId, serverProfileSchemaId, groupId, count); return count; }
@Test public void testSaveOrUpdateManaged() { Session s = openSession(); Transaction tx = s.beginTransaction(); NumberedNode root = new NumberedNode( "root" ); s.saveOrUpdate( root ); tx.commit(); tx = s.beginTransaction(); NumberedNode child = new NumberedNode( "child" ); root.addChild( child ); s.saveOrUpdate( root ); assertFalse( s.contains( child ) ); s.flush(); assertTrue( s.contains( child ) ); tx.commit(); assertTrue( root.getChildren().contains( child ) ); assertEquals( root.getChildren().size(), 1 ); tx = s.beginTransaction(); assertEquals( Long.valueOf( 2 ), s.createCriteria( NumberedNode.class ) .setProjection( Projections.rowCount() ) .uniqueResult() ); s.delete( root ); s.delete( child ); tx.commit(); s.close(); }
@Test public void testCreateWithNonEmptyOneToManyCollectionOfNew() { clearCounts(); Contract c = new Contract( null, "gail", "phone"); c.addParty( new Party( "party" ) ); Session s = openSession(); Transaction t = s.beginTransaction(); s.persist(c); t.commit(); s.close(); assertInsertCount( 2 ); assertUpdateCount( 0 ); clearCounts(); s = openSession(); t = s.beginTransaction(); c = (Contract) s.createCriteria( Contract.class ).uniqueResult(); assertEquals( 1, c.getParties().size() ); Party party = ( Party ) c.getParties().iterator().next(); assertEquals( "party", party.getName() ); if ( isContractPartiesBidirectional ) { assertSame( c, party.getContract() ); } s.delete(c); assertEquals( Long.valueOf( 0 ), s.createCriteria( Contract.class ).setProjection( Projections.rowCount() ).uniqueResult() ); assertEquals( Long.valueOf( 0 ), s.createCriteria( Party.class ).setProjection( Projections.rowCount() ).uniqueResult() ); t.commit(); s.close(); assertUpdateCount( 0 ); assertDeleteCount( 2 ); }
assertNull( cv ); s.delete( c ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult() ); assertEquals( Long.valueOf( 0 ), s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult() ); t.commit(); s.close();
assertNull( party ); s.delete( c ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult() ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Party.class).setProjection( Projections.rowCount() ).uniqueResult() ); t.commit(); s.close();
assertEquals( 0, c.getParties().size() ); s.delete( c ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult() ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Party.class).setProjection( Projections.rowCount() ).uniqueResult() ); t.commit(); s.close();
assertNull( cv ); s.delete( c ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult() ); assertEquals( Long.valueOf( 0 ), s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult() ); t.commit(); s.close();
assertNull( cv ); s.delete( c ); assertEquals( Long.valueOf( 0 ), s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult() ); assertEquals( Long.valueOf( 0 ), s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult() ); t.commit(); s.close();
assertEquals( cv2.getText(), "more expensive" ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();
c.setCustomerName( "Sherman" ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();
c.setCustomerName( "Sherman" ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();
assertTrue( s.isReadOnly( cv2 ) ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();
assertTrue( s.isReadOnly( cv2 ) ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();
assertTrue( s.isReadOnly( cv2 ) ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();
assertTrue( s.isReadOnly( cv2 ) ); s.delete(c); assertEquals( s.createCriteria(Contract.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); assertEquals( s.createCriteria(ContractVariation.class).setProjection( Projections.rowCount() ).uniqueResult(), new Long(0) ); t.commit(); s.close();