Examples with CommandContext org.dbflute.twowaysql.context.CommandContext used on opensource projects

Example 46 with CommandContext

use of org.dbflute.twowaysql.context.CommandContext in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_nested_inLoopOption_notLike_bind_in_FOR.

public void test_accept_nested_inLoopOption_notLike_bind_in_FOR() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    // unused
    pmb.setMemberName("parent");
    List<MockPmb> nestPmbList = DfCollectionUtil.newArrayList();
    {
        MockPmb element = new MockPmb();
        element.setMemberId(3);
        element.setMemberName("fo%o");
        element.setMemberStatusCode("FML");
        List<MockPmb> nestNestPmbList = DfCollectionUtil.newArrayList();
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("baz");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("baz");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        element.setNestPmbList(nestNestPmbList);
        nestPmbList.add(element);
    }
    {
        MockPmb element = new MockPmb();
        element.setMemberId(4);
        element.setMemberName("b|ar");
        element.setMemberStatusCode("WDL");
        List<MockPmb> nestNestPmbList = DfCollectionUtil.newArrayList();
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("qux");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("qux");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        element.setNestPmbList(nestNestPmbList);
        nestPmbList.add(element);
    }
    pmb.setNestPmbList(nestPmbList);
    pmb.setNestPmbListInternalLikeSearchOption(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.nestPmbList*//*FIRST*/and (/*END*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_STATUS_CODE = /*#current.memberStatusCode:notLike*/'test'").append(ln());
    sb.append("     /*FOR #current.nestPmbList*//*FIRST*/and (/*END*/").append(ln());
    sb.append("       /*NEXT 'or '*/MEMBER_NAME like /*#current.parentPmb.memberName*/'foo%'").append(ln());
    sb.append("     /*LAST*/)/*END*//*END*/").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_STATUS_CODE = ?\n"));
    assertTrue(actual.contains("  MEMBER_NAME like ? escape '|'"));
    assertTrue(actual.contains(" or MEMBER_NAME like ? escape '|'"));
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 4);
    assertTrue(actual.contains(" and ("));
    assertTrue(Srl.count(actual, " and (") == 2);
    assertTrue(actual.contains(" )"));
    assertTrue(Srl.count(actual, " )") == 3);
    assertEquals("FML", ctx.getBindVariables()[0]);
    assertEquals("fo|%o%", ctx.getBindVariables()[1]);
    assertEquals("fo|%o%", ctx.getBindVariables()[2]);
    assertEquals("WDL", ctx.getBindVariables()[3]);
    assertEquals("b||ar%", ctx.getBindVariables()[4]);
    assertEquals("b||ar%", ctx.getBindVariables()[5]);
}

Example 47 with CommandContext

use of org.dbflute.twowaysql.context.CommandContext in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_allStars_connectorAdjustment.

public void test_accept_allStars_connectorAdjustment() 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*//*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(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 48 with CommandContext

use of org.dbflute.twowaysql.context.CommandContext in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_nested_basic.

// ===================================================================================
// Nested
// ======
public void test_accept_nested_basic() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    pmb.setMemberNameList(DfCollectionUtil.newArrayList("foo", "bar", "baz"));
    pmb.setMemberNameListInternalLikeSearchOption(new LikeSearchOption().likeContain());
    pmb.setMemberAccountList(DfCollectionUtil.newArrayList("ab%c", "%def"));
    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("     /*FOR pmb.memberAccountList*//*FIRST*/and (/*END*/").append(ln());
    sb.append("       /*NEXT 'or '*/MEMBER_ACCOUNT like /*#current*/'foo%'").append(ln());
    sb.append("     /*LAST*/)/*END*//*END*/").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(" and ("));
    assertTrue(actual.contains("  MEMBER_ACCOUNT like ?"));
    assertTrue(actual.contains(" or MEMBER_ACCOUNT like ?"));
    assertTrue(Srl.count(actual, "MEMBER_ACCOUNT") == 6);
    assertTrue(actual.contains(" )"));
    assertTrue(Srl.count(actual, " )") == 4);
    assertEquals("%foo%", ctx.getBindVariables()[0]);
    assertEquals("ab%c", ctx.getBindVariables()[1]);
    assertEquals("%def", ctx.getBindVariables()[2]);
    assertEquals("%bar%", ctx.getBindVariables()[3]);
    assertEquals("ab%c", ctx.getBindVariables()[4]);
    assertEquals("%def", ctx.getBindVariables()[5]);
    assertEquals("%baz%", ctx.getBindVariables()[6]);
    assertEquals("ab%c", ctx.getBindVariables()[7]);
    assertEquals("%def", ctx.getBindVariables()[8]);
}

Example 49 with CommandContext

use of org.dbflute.twowaysql.context.CommandContext in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_currentParameter_in_IF.

public void test_accept_currentParameter_in_IF() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    pmb.setMemberNameList(DfCollectionUtil.newArrayList("foo", "bar", "bazzzz"));
    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*//*FIRST*/and (/*END*/").append(ln());
    sb.append("     /*IF #current == 'foo'*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_NAME like /*#current*/'foo%'").append(ln());
    sb.append("     /*END*/");
    sb.append("     /*IF #current == 'bar'*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_ACCOUNT like /*#current*/'foo%'").append(ln());
    sb.append("     /*END*/");
    sb.append("     /*IF #current.length() == 6*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_BAZ like /*#current*/'foo%'").append(ln());
    sb.append("     /*END*/");
    sb.append("     /*IF #current.length() == 99*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_BAZ like /*#current*/'foo%'").append(ln());
    sb.append("     /*END*/");
    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_ACCOUNT like ? escape '|'"));
    assertTrue(actual.contains(" or MEMBER_BAZ like ? escape '|'"));
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 1);
    assertTrue(Srl.count(actual, "MEMBER_ACCOUNT") == 1);
    assertTrue(Srl.count(actual, "MEMBER_BAZ") == 1);
    assertTrue(actual.contains(" )"));
    assertEquals("%foo%", ctx.getBindVariables()[0]);
    assertEquals("%bar%", ctx.getBindVariables()[1]);
    assertEquals("%bazzzz%", ctx.getBindVariables()[2]);
}

Example 50 with CommandContext

use of org.dbflute.twowaysql.context.CommandContext in project dbflute-core by dbflute.

the class ForNodeTest method test_accept_nested_parent_in_FOR.

public void test_accept_nested_parent_in_FOR() throws Exception {
    // ## Arrange ##
    MockPmb pmb = new MockPmb();
    // unused
    pmb.setMemberName("parent");
    List<MockPmb> nestPmbList = DfCollectionUtil.newArrayList();
    {
        MockPmb element = new MockPmb();
        element.setMemberId(3);
        element.setMemberName("foo");
        element.setMemberStatusCode("FML");
        List<MockPmb> nestNestPmbList = DfCollectionUtil.newArrayList();
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("baz");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("baz");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        element.setNestPmbList(nestNestPmbList);
        nestPmbList.add(element);
    }
    {
        MockPmb element = new MockPmb();
        element.setMemberId(4);
        element.setMemberName("bar");
        element.setMemberStatusCode("WDL");
        List<MockPmb> nestNestPmbList = DfCollectionUtil.newArrayList();
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("qux");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        {
            MockPmb nestElement = new MockPmb();
            nestElement.setMemberName("qux");
            nestElement.setParentPmb(element);
            nestNestPmbList.add(nestElement);
        }
        element.setNestPmbList(nestNestPmbList);
        nestPmbList.add(element);
    }
    pmb.setNestPmbList(nestPmbList);
    pmb.setNestPmbListInternalLikeSearchOption(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.nestPmbList*//*FIRST*/and (/*END*/").append(ln());
    sb.append("     /*NEXT 'or '*/MEMBER_STATUS_CODE = /*#current.memberStatusCode*/'test'").append(ln());
    sb.append("     /*FOR #current.nestPmbList*//*FIRST*/and (/*END*/").append(ln());
    sb.append("       /*NEXT 'or '*/MEMBER_NAME like /*#current.parentPmb.memberName*/'foo%'").append(ln());
    sb.append("     /*LAST*/)/*END*//*END*/").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_STATUS_CODE = ? escape '|'"));
    assertTrue(actual.contains("  MEMBER_NAME like ? escape '|'"));
    assertTrue(actual.contains(" or MEMBER_NAME like ? escape '|'"));
    assertTrue(Srl.count(actual, "MEMBER_NAME") == 4);
    assertTrue(actual.contains(" and ("));
    assertTrue(Srl.count(actual, " and (") == 2);
    assertTrue(actual.contains(" )"));
    assertTrue(Srl.count(actual, " )") == 3);
    // because of not using notLike option
    assertEquals("FML%", ctx.getBindVariables()[0]);
    assertEquals("foo%", ctx.getBindVariables()[1]);
    assertEquals("foo%", ctx.getBindVariables()[2]);
    // because of not using notLike option
    assertEquals("WDL%", ctx.getBindVariables()[3]);
    assertEquals("bar%", ctx.getBindVariables()[4]);
    assertEquals("bar%", ctx.getBindVariables()[5]);
}