Package org.araneaframework.backend.list.helper.builder.expression

Examples of org.araneaframework.backend.list.helper.builder.expression.StandardExpressionToSqlExprBuilder$LikeTranslator

80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
      }
    });
    assertEquals(value, Boolean.FALSE);

    // build sql expression
    StandardExpressionToSqlExprBuilder builder = new StandardExpressionToSqlExprBuilder();
    builder.setMapper(new VariableResolver() {
      public Object resolve(Variable variable) {
        if ("name".equals(variable.getName())) {
          return "AGENT.NAME";
        }
        if ("age".equals(variable.getName())) {
          return "AGENT.AGE";
        }
        if ("licenseToKill".equals(variable.getName())) {
          return "AGENT.KILLER";
        }
        return null;
      }
    });
    builder.setConverter(new ValueConverter() {
      public Object convert(Value value) {
        if ("licenseToKill".equals(value.getName())) {
          return new BooleanToStringConverter("Y", "N")
              .convert(value.getValue());
        }
        return value.getValue();
      }
    });
    SqlExpression sqlExpr = builder.buildSqlExpression(expr);
    String sqlString = sqlExpr.toSqlString();
    Object[] values = sqlExpr.getValues();
    log.info("SQL string: " + sqlString);
    log.info("SQL values: " + Arrays.asList(values));
  }
View Full Code Here
34
35
36
37
38
39
40
41
42
  private StandardExpressionToSqlExprBuilder builder;
 
  private Object testValue = "test_value";

  public void setUp() {
    this.builder = new StandardExpressionToSqlExprBuilder();
    this.builder.setMapper(new MockVariableResolver());
    this.builder.setConverter(new MockValueConverter());
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
      }
    });
    assertEquals(value, Boolean.FALSE);

    // build sql expression
    StandardExpressionToSqlExprBuilder builder = new StandardExpressionToSqlExprBuilder();
    builder.setMapper(new VariableResolver() {
      public Object resolve(Variable variable) {
        if ("name".equals(variable.getName())) {
          return "AGENT.NAME";
        }
        if ("age".equals(variable.getName())) {
          return "AGENT.AGE";
        }
        if ("licenseToKill".equals(variable.getName())) {
          return "AGENT.KILLER";
        }
        return null;
      }
    });
    builder.setConverter(new ValueConverter() {
      public Object convert(Value value) {
        if ("licenseToKill".equals(value.getName())) {
          return new BooleanToStringConverter("Y", "N")
              .convert(value.getValue());
        }
        return value.getValue();
      }
    });
    SqlExpression sqlExpr = builder.buildSqlExpression(expr);
    String sqlString = sqlExpr.toSqlString();
    Object[] values = sqlExpr.getValues();
    log.info("SQL string: " + sqlString);
    log.info("SQL values: " + Arrays.asList(values));
  }
View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
    }
   
    if (this.filterExpr == null) {
      return null;
    }
    StandardExpressionToSqlExprBuilder builder = new StandardExpressionToSqlExprBuilder();
    builder.setMapper(createExpressionBuilderResolver());
    builder.setConverter(createExpressionBuilderConverter());
    this.filterSqlExpr = builder.buildSqlExpression(this.filterExpr);
    return this.filterSqlExpr;
  }
View Full Code Here
TOP

Related Classes of org.araneaframework.backend.list.helper.builder.expression.StandardExpressionToSqlExprBuilder$LikeTranslator

  • org.araneaframework.backend.list.helper.ListSqlHelper
  • org.araneaframework.backend.list.memorybased.expression.compare.LikeExpression
  • org.araneaframework.backend.list.memorybased.expression.procedure.ProcedureExpression
  • org.araneaframework.backend.list.sqlexpr.compare.SqlEqualsExpression
  • org.araneaframework.backend.list.sqlexpr.compare.SqlGreaterThanExpression
  • org.araneaframework.backend.list.sqlexpr.compare.SqlIsNullExpression
  • org.araneaframework.backend.list.sqlexpr.compare.SqlLikeExpression
  • org.araneaframework.backend.list.sqlexpr.compare.SqlLowerThanExpression
  • org.araneaframework.backend.list.sqlexpr.constant.SqlStringExpression
  • org.araneaframework.backend.list.sqlexpr.constant.SqlValueExpression
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.