/** * @param fullTextQuery * @param pageIndex * @param pageSize * @param maxResults * @return results page */ protected PageHandler getPage(FullTextQuery fullTextQuery, Integer pageIndex, Integer pageSize, Integer maxResults) { PageHandler page = new PageHandler(pageIndex, pageSize, fullTextQuery.getResultSize(), maxResults); if (CommonUtils.notEmpty(pageSize)) { fullTextQuery.setFirstResult(page.getFirstResult()).setMaxResults(page.getPageSize()); } page.setList(fullTextQuery.getResultList()); return page; }
ftq.setProjection("myContentText"); ftq.setMaxResults(20); List<?> resultList = ftq.getResultList(); List<Suggestion> suggestions = Lists.newArrayList(); for (Object next : resultList) {
public Object doInJpa(EntityManager em) throws PersistenceException { FullTextEntityManager fullTextEntityManager = getFullTextEntityManager(em); MatchAllDocsQuery query = new MatchAllDocsQuery(); FullTextQuery fq = fullTextEntityManager.createFullTextQuery(query, Webbis.class); fq.enableFullTextFilter("enabledWebbis"); fq.setFirstResult(firstResult); fq.setMaxResults(maxResult); fq.setSort(new Sort(new SortField("birthTime", true))); fq.setHint("org.hibernate.cacheable", true); return fq.getResultList(); } });
if ("publishDate".equals(orderField)) { Sort sort = new Sort(new SortField("publishDate", SortField.Type.LONG, true)); query.setSort(sort); query.setProjection(projectionFields); query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
hibQuery.setSort( distanceSort ); hibQuery.setProjection( FullTextQuery.THIS, FullTextQuery.SPATIAL_DISTANCE ); hibQuery.setSpatialParameters( centerLatitude, centerLongitude, "location" ); List results = hibQuery.getResultList(); Object[] firstResult = (Object[]) results.get( 0 ); Object[] secondResult = (Object[]) results.get( 1 ); hibQuery.setSort( distanceSort ); results = hibQuery.getResultList(); firstResult = (Object[]) results.get( 0 ); secondResult = (Object[]) results.get( 1 );
List<User> results = jpaQuery.getResultList();
jpaQuery.setMaxResults(maxResult); for (Object next : jpaQuery.getResultList()) { count.incrementAndGet(); TermConcept concept = (TermConcept) next;
jpaQuery.setProjection("myId"); List<?> result = jpaQuery.getResultList();
totalCt[0] = fullTextQuery.getResultSize(); fullTextQuery.setProjection(ProjectionConstants.SCORE, ProjectionConstants.THIS); final List<T> classes = new ArrayList<>(); @SuppressWarnings("unchecked") final List<Object[]> results = fullTextQuery.getResultList(); for (final Object[] result : results) { Object score = result[0];
fullTextEntityManager.createFullTextQuery(booleanQuery, clazz); fullTextQuery.setMaxResults(20); final List<AtomClass> results = fullTextQuery.getResultList(); final StringList list = new StringList(); list.setTotalCount(fullTextQuery.getResultSize()); for (final AtomClass result : results) {
totalCt[0] = fullTextQuery.getResultSize(); return fullTextQuery.getResultList();
@Test @SuppressWarnings("unchecked") public void testResultOrderedByDateDescending() throws Exception { EntityTransaction tx = em.getTransaction(); tx.begin(); QueryBuilder builder = em.getSearchFactory().buildQueryBuilder().forEntity( ProductArticle.class ).get(); org.apache.lucene.search.Query query = builder.keyword().wildcard().onField( "header" ).matching( "hib*" ).createQuery(); Sort dateDescending = builder.sort().byField( "creationDate" ).desc().createSort(); List<ProductArticle> result = em.createFullTextQuery( query, ProductArticle.class ) .setSort( dateDescending ).setFirstResult( 3 ).getResultList(); assertThat( result ).as( "query result" ).hasSize( 3 ); assertThat( result.get( 0 ).getArticleId() ).as( "article id" ).isEqualTo( 3 ); assertThat( result.get( 1 ).getArticleId() ).as( "article id" ).isEqualTo( 2 ); assertThat( result.get( 2 ).getArticleId() ).as( "article id" ).isEqualTo( 1 ); tx.commit(); em.clear(); }
assertEquals( 0, em.createFullTextQuery( query ).getResultList().size() ); assertEquals( "getResultList", 1, em.createFullTextQuery( query ) .getResultList().size() ); assertEquals( "getSingleResult and object retrieval", 23, ( (Bretzel) em .createFullTextQuery( query ) .getSingleResult() ) .getSaltQty() ); assertEquals( 1, em.createFullTextQuery( query ).getResultSize() ); em.getTransaction().commit();
fullTextQuery.setFirstResult(pfs.getStartIndex()); fullTextQuery.setMaxResults(pfs.getMaxResults()); sfs[i] = sortFields.get(i); fullTextQuery.setSort(new Sort(sfs));
@SuppressWarnings("unchecked") private void updateResults() { FullTextQuery query; try { query = searchQuery(searchQuery); } catch (ParseException pe) { return; } List<Product> items = query .setMaxResults(pageSize + 1) .setFirstResult(pageSize * currentPage) .getResultList(); numberOfResults = query.getResultSize(); if (items.size() > pageSize) { searchResults = new ArrayList(items.subList(0, pageSize)); hasMore = true; } else { searchResults = items; hasMore = false; } searchSelections = new HashMap<Product, Boolean>(); }
@Override public int countSearchRecommended(String searchTerm) throws ServiceException { FullTextQuery query = getSearchRecommendedQuery(searchTerm); if (query == null) { return 0; } return query.getResultSize(); }
Query query = builder.keyword().onField( "brand" ).matching( "Seiko" ).createQuery(); FullTextQuery hibernateQuery = em.createFullTextQuery( query, Clock.class ); List results = hibernateQuery.getResultList(); assertEquals( 500, results.size() ); hibernateQuery.limitExecutionTimeTo( 1, TimeUnit.NANOSECONDS ); List result = hibernateQuery.getResultList(); System.out.println( "Result size early: " + result.size() ); assertEquals( "Test early failure, before the number of results are even fetched", 0, result.size() ); if ( result.size() == 0 ) { assertTrue( hibernateQuery.hasPartialResults() ); hibernateQuery.limitExecutionTimeTo( 30, TimeUnit.SECONDS ); results = hibernateQuery.getResultList(); assertEquals( "Test below limit termination", 500, results.size() ); assertFalse( hibernateQuery.hasPartialResults() );
public Object doInJpa(EntityManager em) throws PersistenceException { FullTextQuery fq = createSearchQuery(criteria, includeDisabled, em); fq.setHint("org.hibernate.cacheable", true); return fq.getResultSize(); }
@Test public void testQueryViaEntityManager() { EntityManager em = factory.createEntityManager(); FullTextEntityManager ftem = Search.getFullTextEntityManager( em ); ftem.getTransaction().begin(); QueryDescriptor query = ElasticsearchQueries.fromJson( "{ 'query': { 'match' : { 'lastName' : 'Hergesheimer' } } }" ); Object[] result = (Object[]) ftem.createFullTextQuery( query, GolfPlayer.class ) .setProjection( ElasticsearchProjectionConstants.SOURCE ) .getSingleResult(); String source = (String) result[0]; JsonHelper.assertJsonEqualsIgnoringUnknownFields( "{" + "'lastName': 'Hergesheimer'," + "'fullName': 'Klaus Hergesheimer'," + "}", source ); ftem.getTransaction().commit(); ftem.close(); }
@Override public List<?> searchEntriesForUserHelper(String userId, String field, String query, int startPosition, int maxResults) { if (userId == null || userId.isEmpty() || !idGenerator.isIdWellFormed(userId)) { return new ArrayList<Entry>(); } if (query == null) { return new ArrayList<Entry>(); } if (field == null) { return new ArrayList<Entry>(); } FullTextEntityManager fullTextEntityManager = org.hibernate.search.jpa.Search .getFullTextEntityManager(getOrCreateEntityManager()); QueryBuilder qb = fullTextEntityManager.getSearchFactory() .buildQueryBuilder().forEntity(Entry.class).get(); org.apache.lucene.search.Query luceneQuery = qb .bool() .must(qb.keyword().onField(field).matching(query).createQuery()) .must(new TermQuery(new Term("userId", userId))).createQuery(); javax.persistence.Query jpaQuery = fullTextEntityManager .createFullTextQuery(luceneQuery, Entry.class) .setFirstResult(startPosition).setMaxResults(maxResults); return jpaQuery.getResultList(); }