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

Example 16 with CommandContext

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

the class IfNodeTest method test_parse_IF_true.

// ===================================================================================
// Basic
// =====
public void test_parse_IF_true() {
    // ## Arrange ##
    String sql = "/*IF pmb.memberName != null*/and member.MEMBER_NAME = 'TEST'/*END*/";
    SqlAnalyzer analyzer = new SqlAnalyzer(sql, false);
    // ## Act ##
    Node rootNode = analyzer.analyze();
    // ## Assert ##
    MockMemberPmb pmb = new MockMemberPmb();
    pmb.setMemberName("foo");
    CommandContext ctx = createCtx(pmb);
    rootNode.accept(ctx);
    log("ctx:" + ctx);
    assertEquals("and member.MEMBER_NAME = 'TEST'", ctx.getSql());
}

Example 17 with CommandContext

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

the class IfNodeTest method test_parse_IF_Else_ifValid_in_BEGIN.

public void test_parse_IF_Else_ifValid_in_BEGIN() {
    // ## Arrange ##
    String sql = "/*BEGIN*/where";
    sql = sql + " /*IF pmb.memberId != null*/";
    sql = sql + " select foo";
    sql = sql + "  -- ELSE select count(*)";
    sql = sql + " /*END*/";
    sql = sql + " /*END*/";
    SqlAnalyzer analyzer = new SqlAnalyzer(sql, false);
    // ## Act ##
    Node rootNode = analyzer.analyze();
    // ## Assert ##
    MockMemberPmb pmb = new MockMemberPmb();
    pmb.setMemberId(3);
    CommandContext ctx = createCtx(pmb);
    rootNode.accept(ctx);
    log("ctx:" + ctx);
    String expected = "where  select foo   ";
    assertEquals(expected, ctx.getSql());
}

Example 18 with CommandContext

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

the class EmbeddedVariableNodeTest method test_accept_inScope_list_eitherQuoted.

public void test_accept_inScope_list_eitherQuoted() {
    // ## Arrange ##
    String sql = "in /*$pmb.memberNameList*/(foo, 'bar')";
    SqlAnalyzer analyzer = new SqlAnalyzer(sql, false);
    Node rootNode = analyzer.analyze();
    MockMemberPmb pmb = new MockMemberPmb();
    pmb.setMemberNameList(DfCollectionUtil.newArrayList("baz", "qux"));
    CommandContext ctx = createCtx(pmb);
    // ## Act ##
    rootNode.accept(ctx);
    // ## Assert ##
    log("ctx:" + ctx);
    assertEquals("in ('baz', 'qux')", ctx.getSql());
    assertEquals(0, ctx.getBindVariables().length);
}

Example 19 with CommandContext

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

the class EmbeddedVariableNodeTest method test_analyze_basic.

// ===================================================================================
// Basic
// =====
public void test_analyze_basic() {
    // ## Arrange ##
    String sql = "/*BEGIN*/where";
    sql = sql + " /*IF pmb.memberId != null*/member.MEMBER_ID = /*$pmb.memberId*//*END*/";
    sql = sql + " /*IF pmb.memberName != null*/and member.MEMBER_NAME = /*$pmb.memberName*/'TEST'/*END*/";
    sql = sql + "/*END*/";
    SqlAnalyzer analyzer = new SqlAnalyzer(sql, false);
    // ## Act ##
    Node rootNode = analyzer.analyze();
    // ## Assert ##
    MockMemberPmb pmb = new MockMemberPmb();
    pmb.setMemberId(12);
    pmb.setMemberName("foo");
    CommandContext ctx = createCtx(pmb);
    rootNode.accept(ctx);
    log("ctx:" + ctx);
    String expected = "where member.MEMBER_ID = 12 and member.MEMBER_NAME = 'foo'";
    assertEquals(expected, ctx.getSql());
    assertEquals(0, ctx.getBindVariables().length);
}

Example 20 with CommandContext

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

the class EmbeddedVariableNodeTest method test_accept_string_basic.

public void test_accept_string_basic() {
    // ## Arrange ##
    String sql = "= /*$pmb.memberName*/'foo'";
    SqlAnalyzer analyzer = new SqlAnalyzer(sql, false);
    Node rootNode = analyzer.analyze();
    MockMemberPmb pmb = new MockMemberPmb();
    pmb.setMemberName("bar");
    CommandContext ctx = createCtx(pmb);
    // ## Act ##
    rootNode.accept(ctx);
    // ## Assert ##
    log("ctx:" + ctx);
    assertEquals("= 'bar'", ctx.getSql());
    assertEquals(0, ctx.getBindVariables().length);
}