Examples with LikeSearchOption org.dbflute.cbean.coption.LikeSearchOption used on opensource projects

Example 31 with LikeSearchOption

use of org.dbflute.cbean.coption.LikeSearchOption in project dbflute-core by dbflute.

the class BoundValueTracerTest method test_setupValueAndType_bean_likeSearch_split.

public void test_setupValueAndType_bean_likeSearch_split() {
    // ## Arrange ##
    BoundValueTracer setupper = createTargetAsBind("pmb.memberName");
    MockPmb pmb = new MockPmb();
    pmb.setMemberName("f|o%o");
    pmb.setMemberNameInternalLikeSearchOption(new LikeSearchOption().likePrefix().splitByPipeLine());
    BoundValue valueAndType = createTargetAndType(pmb);
    // ## Act ##
    // no check here
    setupper.trace(valueAndType);
    valueAndType.filterValueByOptionIfNeeds();
    // ## Assert ##
    assertEquals("f||o|%o%", valueAndType.getTargetValue());
    assertEquals(String.class, valueAndType.getTargetType());
}

Example 32 with LikeSearchOption

use of org.dbflute.cbean.coption.LikeSearchOption in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_loopVariable_in_IF.

public void test_accept_loopVariable_in_IF() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    pmb.setMemberNameList(DfCollectionUtil.newArrayList("foo", "bar", "baz"));
    pmb.setMemberNameListInternalLikeSearchOption(new LikeSearchOption().likeContain());
    StringBuilder sb = new StringBuilder();
    sb.append("select * from MEMBER").append(ln());
    sb.append(" /*BEGIN*/where").append(ln());
    sb.append("   /*IF pmb.memberId != null*/").append(ln());
    sb.append("   MEMBER_ID = /*pmb.memberId*/").append(ln());
    sb.append("   /*END*/").append(ln());
    sb.append("   /*FOR pmb.memberNameList*//*IF true*//*FIRST*/and (/*END*//*END*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_NAME like /*#current*/'foo%'").append(ln());
    sb.append("   /*LAST*/)/*END*//*END*/").append(ln());
    sb.append(" /*END*/");
    SqlAnalyzer analyzer = new SqlAnalyzer(sb.toString(), false);
    Node rootNode = analyzer.analyze();
    CommandContext ctx = createCtx(pmb);
    // ## Act ##
    rootNode.accept(ctx);
    // ## Assert ##
    String actual = ctx.getSql();
    log(ln() + actual);
    assertTrue(actual.contains("  ("));
    assertTrue(actual.contains("  MEMBER_NAME like ? escape '|'"));
    assertTrue(actual.contains(" or MEMBER_NAME like ? escape '|'"));
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 3);
    assertTrue(actual.contains(" )"));
    assertEquals("%foo%", ctx.getBindVariables()[0]);
    assertEquals("%bar%", ctx.getBindVariables()[1]);
    assertEquals("%baz%", ctx.getBindVariables()[2]);
}

Example 33 with LikeSearchOption

use of org.dbflute.cbean.coption.LikeSearchOption in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_nullList.

public void test_accept_nullList() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    pmb.setMemberNameList(null);
    pmb.setMemberNameListInternalLikeSearchOption(new LikeSearchOption().likePrefix());
    StringBuilder sb = new StringBuilder();
    sb.append("select * from MEMBER");
    sb.append(" /*BEGIN*/where");
    sb.append("   /*IF pmb.memberId != null*/");
    sb.append("   MEMBER_ID = /*pmb.memberId*/");
    sb.append("   /*END*/");
    sb.append("   /*FOR pmb.memberNameList*//*FIRST*/and (/*END*/");
    sb.append("     /*NEXT 'or '*/MEMBER_NAME like /*#current*/'foo%'");
    sb.append("   /*LAST*/)/*END*//*END*/");
    sb.append(" /*END*/");
    SqlAnalyzer analyzer = new SqlAnalyzer(sb.toString(), false);
    Node rootNode = analyzer.analyze();
    CommandContext ctx = createCtx(pmb);
    // ## Act ##
    rootNode.accept(ctx);
    // ## Assert ##
    String actual = ctx.getSql();
    log(ln() + actual);
    assertTrue(actual.contains("select * from MEMBER "));
    assertFalse(actual.contains("where"));
    assertFalse(actual.contains("  ("));
    assertFalse(actual.contains("  MEMBER_NAME like ?"));
    assertFalse(actual.contains(" or MEMBER_NAME like ?"));
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 0);
    assertFalse(actual.contains(" )"));
    assertEquals(0, ctx.getBindVariables().length);
}

Example 34 with LikeSearchOption

use of org.dbflute.cbean.coption.LikeSearchOption in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_allStars_connectorAdjustment_LAST.

public void test_accept_allStars_connectorAdjustment_LAST() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    pmb.setMemberNameList(DfCollectionUtil.newArrayList("foo", "bar", "baz"));
    pmb.setMemberNameListInternalLikeSearchOption(new LikeSearchOption().likeContain());
    StringBuilder sb = new StringBuilder();
    sb.append("select * from MEMBER").append(ln());
    sb.append(" /*BEGIN*/where").append(ln());
    sb.append("   /*IF pmb.memberId != null*/").append(ln());
    sb.append("   MEMBER_ID = /*pmb.memberId*/").append(ln());
    sb.append("   /*END*/").append(ln());
    sb.append("   /*FOR pmb.memberNameList*//*LAST '@'*//*FIRST*/and (/*END*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_NAME like /*#current*/'foo%'").append(ln());
    sb.append("   /*LAST*/)/*END*//*END*/").append(ln());
    sb.append(" /*END*/");
    SqlAnalyzer analyzer = new SqlAnalyzer(sb.toString(), false);
    Node rootNode = analyzer.analyze();
    CommandContext ctx = createCtx(pmb);
    // ## Act ##
    rootNode.accept(ctx);
    // ## Assert ##
    String actual = ctx.getSql();
    log(ln() + actual);
    assertTrue(actual.contains("  ("));
    assertTrue(actual.contains("  MEMBER_NAME like ? escape '|'"));
    assertTrue(actual.contains(" or MEMBER_NAME like ? escape '|'"));
    assertTrue(actual.contains("  @"));
    assertTrue(Srl.count(actual, "@") == 1);
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 3);
    assertTrue(actual.contains(" )"));
    assertEquals("%foo%", ctx.getBindVariables()[0]);
    assertEquals("%bar%", ctx.getBindVariables()[1]);
    assertEquals("%baz%", ctx.getBindVariables()[2]);
}

Example 35 with LikeSearchOption

use of org.dbflute.cbean.coption.LikeSearchOption in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_allStars_embedded_either_true.

public void test_accept_allStars_embedded_either_true() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    pmb.setMemberNameList(DfCollectionUtil.newArrayList("foo", "bar", "baz"));
    pmb.setMemberNameListInternalLikeSearchOption(new LikeSearchOption().likePrefix());
    StringBuilder sb = new StringBuilder();
    sb.append("select * from MEMBER").append(ln());
    sb.append(" /*BEGIN*/where").append(ln());
    sb.append("   /*IF pmb.memberId != null*/").append(ln());
    sb.append("   MEMBER_ID = /*pmb.memberId*/").append(ln());
    sb.append("   /*END*/").append(ln());
    sb.append("   /*FOR pmb.memberNameList*//*FIRST*/and (/*END*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_NAME like /*$#current*/'foo%'").append(ln());
    sb.append("   /*LAST*/)/*END*//*END*/").append(ln());
    sb.append(" /*END*/");
    SqlAnalyzer analyzer = new SqlAnalyzer(sb.toString(), false);
    Node rootNode = analyzer.analyze();
    CommandContext ctx = createCtx(pmb);
    // ## Act ##
    rootNode.accept(ctx);
    // ## Assert ##
    String actual = ctx.getSql();
    log(ln() + actual);
    assertTrue(actual.contains("  ("));
    assertTrue(actual.contains("  MEMBER_NAME like 'foo%' escape '|'"));
    assertTrue(actual.contains(" or MEMBER_NAME like 'bar%' escape '|'"));
    assertTrue(actual.contains(" or MEMBER_NAME like 'baz%' escape '|'"));
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 3);
    assertTrue(actual.contains(" )"));
    assertEquals(0, ctx.getBindVariables().length);
}