Examples of when()


Examples of org.jooq.Case.when()

    }

    @Test
    public void testCaseConditionFunction() throws Exception {
        Case decode = decode();
        CaseConditionStep<String> c = decode.when(FIELD_ID1.equal(1), "one");

        assertEquals("case when \"TABLE1\".\"ID1\" = 1 then 'one' end", r_refI().render(c));
        assertEquals("case when \"TABLE1\".\"ID1\" = ? then ? end", r_ref().render(c));
        assertEquals("case when \"TABLE1\".\"ID1\" = 1 then 'one' end", r_decI().render(c));
        assertEquals("case when \"TABLE1\".\"ID1\" = ? then ? end", r_dec().render(c));
View Full Code Here

Examples of org.jtester.annotations.DbFit.when()

   * @param testClazz
   * @return
   */
  public static String[] autoFindClassWhen(Class testClazz) {
    DbFit dbFit = AnnotationUtils.getClassLevelAnnotation(DbFit.class, testClazz);
    List<String> whens = getFiles(dbFit == null ? null : dbFit.when());
    if (dbFit != null && dbFit.auto() == AUTO.UN_AUTO) {
      return whens.toArray(new String[0]);
    } else {
      String wiki = String.format(CLAZZ_WHEN_WIKI, testClazz.getSimpleName());
      if (whens.contains(wiki) == false && ResourceHelper.isResourceExists(testClazz, wiki)) {
View Full Code Here

Examples of org.mockito.stubbing.Stubber.when()

        stub.doAnswer(answer);
      }
    }

    assert stub != null;
    stub.when(fetchStarter).createAndStart((String[]) any(), (BlockFetchingListener) anyObject());
    String[] blockIdArray = blockIds.toArray(new String[blockIds.size()]);
    new RetryingBlockFetcher(conf, fetchStarter, blockIdArray, listener).start();
  }
}
View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

  }

  public static SqlExpr coalesce(SqlExpr... exprs) {
    SqlCase sqlCase = new SqlCase();
    for (SqlExpr expr : exprs) {
      sqlCase.when(isNotNull(expr.clone()), expr);
    }
    return sqlCase;
  }

  public static SqlExpr concat(SqlExpr left, SqlExpr right) {
View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

  {
    boolean divide = node.getOperator().equals(MathExpr.MathOp.DIVIDE);
    ValueExpr left = node.getLeftArg();
    ValueExpr right = node.getRightArg();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(in(str(DOUBLE), type(left), type(right)), str(DOUBLE));
    sqlCase.when(in(str(FLOAT), type(left), type(right)), str(FLOAT));
    sqlCase.when(in(str(DECIMAL), type(left), type(right)), str(DECIMAL));
    sqlCase.when(new TrueValue(), divide ? str(DECIMAL) : str(INTEGER));
    result = sqlCase;
  }
View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

    boolean divide = node.getOperator().equals(MathExpr.MathOp.DIVIDE);
    ValueExpr left = node.getLeftArg();
    ValueExpr right = node.getRightArg();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(in(str(DOUBLE), type(left), type(right)), str(DOUBLE));
    sqlCase.when(in(str(FLOAT), type(left), type(right)), str(FLOAT));
    sqlCase.when(in(str(DECIMAL), type(left), type(right)), str(DECIMAL));
    sqlCase.when(new TrueValue(), divide ? str(DECIMAL) : str(INTEGER));
    result = sqlCase;
  }
View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

    ValueExpr left = node.getLeftArg();
    ValueExpr right = node.getRightArg();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(in(str(DOUBLE), type(left), type(right)), str(DOUBLE));
    sqlCase.when(in(str(FLOAT), type(left), type(right)), str(FLOAT));
    sqlCase.when(in(str(DECIMAL), type(left), type(right)), str(DECIMAL));
    sqlCase.when(new TrueValue(), divide ? str(DECIMAL) : str(INTEGER));
    result = sqlCase;
  }

  @Override
View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

    ValueExpr right = node.getRightArg();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(in(str(DOUBLE), type(left), type(right)), str(DOUBLE));
    sqlCase.when(in(str(FLOAT), type(left), type(right)), str(FLOAT));
    sqlCase.when(in(str(DECIMAL), type(left), type(right)), str(DECIMAL));
    sqlCase.when(new TrueValue(), divide ? str(DECIMAL) : str(INTEGER));
    result = sqlCase;
  }

  @Override
  public void meet(Str node)
View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

    throws UnsupportedRdbmsOperatorException
  {
    ValueExpr left = node.getLeftArg();
    ValueExpr right = node.getRightArg();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(eq(label(right), str("*")), neq(label(left), str("")));
    SqlExpr pattern = concat(lowercase(label(right)), str("%"));
    sqlCase.when(new TrueValue(), like(label(left), pattern));
    result = sqlCase;
  }

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase.when()

    ValueExpr left = node.getLeftArg();
    ValueExpr right = node.getRightArg();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(eq(label(right), str("*")), neq(label(left), str("")));
    SqlExpr pattern = concat(lowercase(label(right)), str("%"));
    sqlCase.when(new TrueValue(), like(label(left), pattern));
    result = sqlCase;
  }

  @Override
  public void meet(Not node)
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.