How to use

containsOne

method

in

org.nuiton.wikitty.query.WikittyQueryMaker

@Override
public boolean visitEnter(ContainsOne o) {
  getQueryMaker().containsOne(o.getElement());
  return true;
}

.containsOne(Element.ALL_FIELD, values)
.end().setLimit(WikittyQuery.MAX)
.setWikittyFieldSearchDepth(wikittyFieldSearchDepth - 1);

    .containsOne(Element.ID, ids).end()
    .setOffset(0).setLimit(WikittyQuery.MAX);
WikittyQueryResult<String> queryResult =

@Test
public void testQueryMakerContainsOne() throws IOException {
  importBooks(); // add 13 livres
  {
    WikittyQuery query = new WikittyQueryMaker()
        .containsOne(Product.ELEMENT_FIELD_PRODUCT_COLORS, Arrays.asList("white", "black")).end();
    WikittyQueryResult<Product> results = wikittyClient.findAllByQuery(Product.class, query);
    Assert.assertEquals(9, results.getTotalResult());
    Assert.assertEquals(9, results.getAll().size());
  }
  // with empty list, result must contains nothing
  // http://www.nuiton.org/issues/3735
  // Anomalie #3735: containsOne and containsAll with an empty collection returns all objects but no object should have been returned
  {
    WikittyQuery query = new WikittyQueryMaker()
        .containsOne(Product.ELEMENT_FIELD_PRODUCT_COLORS, Arrays.asList()).end();
    WikittyQueryResult<Product> results = wikittyClient.findAllByQuery(Product.class, query);
    Assert.assertEquals(0, results.getTotalResult());
    Assert.assertEquals(0, results.getAll().size());
  }
}

/**
 * Test avec des requettes imbriquées.
 * 
 * @throws IOException 
 */
@Test
public void testQueryMakerSelect() throws IOException {
  importBooks();
  
  // les livres dont le prix est entre 0 et 75
  // et qui appartiennet a une catégory nommé "history"
  WikittyQuery query = new WikittyQueryMaker().and()
      .bw(Product.ELEMENT_FIELD_PRODUCT_PRICE, 0, 75)
      .containsOne(Product.ELEMENT_FIELD_PRODUCT_CATEGORY)
        .select(Element.ID)
          .eq(Category.FQ_FIELD_CATEGORY_CODE, "history").end();
  WikittyQueryResult<String> results = wikittyClient.findAllByQuery(query);
  Assert.assertEquals(3, results.getTotalResult());
}

.and()
.exteq(WikittyGroup.EXT_WIKITTYGROUP)
.containsOne(WikittyGroup.FQ_FIELD_WIKITTYGROUP_NAME)
.select(WikittyLabel.FQ_FIELD_WIKITTYLABEL_LABELS)
.end();

.containsOne(WikittyGroup.FQ_FIELD_WIKITTYGROUP_MEMBERS)
 .select(Element.ID)
  .eq(WikittyLabel.FQ_FIELD_WIKITTYLABEL_LABELS, "titi")
.or()
 .ideq(g2.getWikittyId())
 .containsOne(WikittyGroup.FQ_FIELD_WIKITTYGROUP_MEMBERS)
  .select(Element.ID)
   .eq(WikittyLabel.FQ_FIELD_WIKITTYLABEL_LABELS, "titi")
 .not()
  .ideq(g1.getWikittyId())
 .containsOne(WikittyGroup.FQ_FIELD_WIKITTYGROUP_MEMBERS)
  .select(Element.ID)
   .eq(WikittyLabel.FQ_FIELD_WIKITTYLABEL_LABELS, "titi")