@Test(expectedExceptions = IllegalStateException.class) public void testWrongQueryBuilding1() { QueryFactory qf = getQueryFactory(); qf.not().having("name").eq("John").build(); }
public void testNot4() { QueryFactory qf = getQueryFactory(); // NOT should have higher priority than AND Query q = qf.from(getModelFactory().getUserImplClass()) .having("surname").eq("Man") .and().not().having("name").eq("John") .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals("Spider", list.get(0).getName()); }
public void testSampleDomainQuery12() { QueryFactory qf = getQueryFactory(); // all the transactions that represents credits to the account Query q = qf.from(getModelFactory().getTransactionImplClass()) .having("accountId").eq(1) .and() .not().having("isDebit").eq(true).build(); List<Transaction> list = q.list(); assertEquals(1, list.size()); assertFalse(list.get(0).isDebit()); }
@Override @Measure public void clearAllIndexedPathInStore( ArtifactStore store ) { StoreKey sk = store.getKey(); long total = iterateRemove( () -> queryFactory.from( IndexedStorePath.class ) .maxResults( ITERATE_RESULT_SIZE ) .having( "packageType" ) .eq( sk.getPackageType() ) .and() .having( "storeType" ) .eq( sk.getType().name() ) .and() .having( "storeName" ) .eq( sk.getName() ) .toBuilder() .build() ); logger.trace( "Cleared all indices with group: {}, size: {}", sk, total ); }
public void testNot7() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("gender").eq(User.Gender.FEMALE) .and().not(qf.having("name").eq("Spider")) .build(); List<User> list = q.list(); assertTrue(list.isEmpty()); }
@Override @Measure public void clearAllIndexedPathInStoreWithOriginal( ArtifactStore store, ArtifactStore originalStore ) { StoreKey sk = store.getKey(); StoreKey osk = originalStore.getKey(); long total = iterateRemove( () -> queryFactory.from( IndexedStorePath.class ) .maxResults( ITERATE_RESULT_SIZE ) .having( "packageType" ) .eq( osk.getPackageType() ) .and() .having( "storeType" ) .eq( sk.getType().name() ) .and() .having( "storeName" ) .eq( sk.getName() ) .and() .having( "originStoreType" ) .eq( osk.getType().name() ) .and() .having( "originStoreName" ) .eq( osk.getName() ) .toBuilder() .build() ); logger.trace( "Cleared all indices with origin: {} and group: {}, size: {}", osk, sk, total ); }
public void testSampleDomainQuery2() { QueryFactory qf = getQueryFactory(); // all male users, but this time retrieved in a twisted manner Query q = qf.from(getModelFactory().getUserImplClass()) .orderBy("name", SortOrder.ASC) .not(qf.having("gender").eq(User.Gender.FEMALE)) .and(qf.not().not(qf.having("gender").eq(User.Gender.MALE))) .build(); List<User> list = q.list(); assertEquals(2, list.size()); assertEquals("John", list.get(0).getName()); assertEquals("Spider", list.get(1).getName()); }
@Override @Measure public void clearAllIndexedPathWithOriginalStore( ArtifactStore originalStore ) { StoreKey osk = originalStore.getKey(); long total = iterateRemove( () -> queryFactory.from( IndexedStorePath.class ) .maxResults( ITERATE_RESULT_SIZE ) .having( "packageType" ) .eq( osk.getPackageType() ) .and() .having( "originStoreType" ) .eq( osk.getType().name() ) .and() .having( "originStoreName" ) .eq( osk.getName() ) .toBuilder() .build() ); logger.trace( "Cleared all indices with origin: {}, size: {}", osk, total ); }
public void testOr5() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("gender").eq(User.Gender.MALE) .or().having("name").eq("Spider") .or().having("gender").eq(User.Gender.FEMALE) .and().having("surname").like("%oe%") .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals("John", list.get(0).getName()); }
case NOT_EQUALS: if (value.equals("*")) { context = qb.not().having(mfilter.getFieldName()).like(value); } else { context = qb.not().having(mfilter.getFieldName()).eq(value); case NOT_EQUALS: if (value.equals("*")) { context = qb.not().having(sfilter.getFieldName()).like((String)value); } else { context = qb.not().having(sfilter.getFieldName()).eq(value); (context == null ? qb : context.and()).having(getPrimaryFieldName()).eq(this.startKey); }else{ if (this.startKey!=null && this.endKey!=null) context = (context == null ? qb : context.and()).having(getPrimaryFieldName()).between(this.startKey,this.endKey); else if (this.startKey!=null) context = (context == null ? qb : context.and()).having(getPrimaryFieldName()).between(this.startKey,null); else if (this.endKey!=null) (context == null ? qb : context.and()).having(getPrimaryFieldName()).between(null,this.endKey);
public void testOr4() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .orderBy("surname", SortOrder.DESC) .having("gender").eq(User.Gender.MALE) .or().having("name").eq("Spider") .and().having("gender").eq(User.Gender.FEMALE) .or().having("surname").like("%oe%") .build(); List<User> list = q.list(); assertEquals(2, list.size()); assertEquals("Woman", list.get(0).getSurname()); assertEquals("Doe", list.get(1).getSurname()); }
@Test(expectedExceptions = IllegalStateException.class, expectedExceptionsMessageRegExp = "ISPN014825: Query parameter 'param2' was not set") public void testMissingParamWithParameterMap() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("name").eq(param("param1")) .and().having("gender").eq(param("param2")) .build(); Map<String, Object> parameterMap = new HashMap<>(1); parameterMap.put("param1", "John"); q.setParameters(parameterMap); q.list(); }
public void testSampleDomainQuery7() { QueryFactory qf = getQueryFactory(); // all rent payments made from a given account Query q = qf.from(getModelFactory().getTransactionImplClass()) .having("accountId").eq(1) .and().having("description").like("%rent%") .build(); List<Transaction> list = q.list(); assertEquals(1, list.size()); assertEquals(1, list.get(0).getId()); assertEquals(1, list.get(0).getAccountId()); assertTrue(list.get(0).getDescription().contains("rent")); }
bqEnd = bqEnd.and().having( fieldName ).eq( key.getColumnValues()[i] );
public void testWithParameterMap() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("gender").eq(param("param1")) .and() .having("name").eq(param("param2")) .build(); Map<String, Object> parameterMap = new HashMap<>(2); parameterMap.put("param1", User.Gender.MALE); parameterMap.put("param2", "John"); q.setParameters(parameterMap); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals(User.Gender.MALE, list.get(0).getGender()); assertEquals("John", list.get(0).getName()); parameterMap = new HashMap<>(2); parameterMap.put("param1", User.Gender.MALE); parameterMap.put("param2", "Spider"); q.setParameters(parameterMap); list = q.list(); assertEquals(1, list.size()); assertEquals(User.Gender.MALE, list.get(0).getGender()); assertEquals("Spider", list.get(0).getName()); }
public void testSampleDomainQuery6() { QueryFactory qf = getQueryFactory(); // all users with a given name and surname Query q = qf.from(getModelFactory().getUserImplClass()) .having("name").eq("John") .and().having("surname").eq("Doe") .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals("John", list.get(0).getName()); assertEquals("Doe", list.get(0).getSurname()); }
public void testSampleDomainQuery10() { QueryFactory qf = getQueryFactory(); // all the transactions for a an account having amount greater than a given amount Query q = qf.from(getModelFactory().getTransactionImplClass()) .having("accountId").eq(2) .and().having("amount").gt(40) .build(); List<Transaction> list = q.list(); assertEquals(52, list.size()); assertTrue(list.get(0).getAmount() > 40); assertTrue(list.get(1).getAmount() > 40); }
public void testAnd1() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("name").eq("Spider") .and().having("surname").eq("Man") .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals(2, list.get(0).getId()); }
public void testSingleIN() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("surname").in("Man") .and() .having("gender").eq(User.Gender.MALE) .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals(2, list.get(0).getId()); assertEquals("Man", list.get(0).getSurname()); assertEquals(User.Gender.MALE, list.get(0).getGender()); } }
public void testEqHybridQuery() { QueryFactory qf = getQueryFactory(); Query q = qf.from(getModelFactory().getUserImplClass()) .having("notes").eq("Lorem ipsum dolor sit amet") .and().having("surname").eq("Doe") .build(); List<User> list = q.list(); assertEquals(1, list.size()); assertEquals(1, list.get(0).getId()); }