Examples of SqlCase

org.eigenbase.sql.fun.SqlCase
A SqlCase is a node of a parse tree which represents a case statement. It warrants its own node type just because we have a lot of methods to put somewhere.
org.openrdf.sail.rdbms.algebra.SqlCase
The SQL CASE WHEN THEN END expression. @author James Leigh

Examples of org.eigenbase.sql.fun.SqlCase

            whenList.add(caseNodeList.get(i));
            thenList.add(caseNodeList.get(i + 1));
          }
        }
        elseNode = caseNodeList.get(caseNodeList.size() - 1);
        return new SqlCase(POS, valueNode, new SqlNodeList(whenList, POS),
            new SqlNodeList(thenList, POS), elseNode);


      default:
        final RexCall call = (RexCall) rex;
        final SqlOperator op = call.getOperator();

View Full Code Here

Examples of org.eigenbase.sql.fun.SqlCase

            whenList.add(caseNodeList.get(i));
            thenList.add(caseNodeList.get(i + 1));
          }
        }
        elseNode = caseNodeList.get(caseNodeList.size() - 1);
        return new SqlCase(POS, valueNode, new SqlNodeList(whenList, POS),
            new SqlNodeList(thenList, POS), elseNode);


      default:
        final RexCall call = (RexCall) rex;
        final SqlOperator op = call.getOperator();

View Full Code Here

Examples of org.eigenbase.sql.fun.SqlCase

            whenList.add(caseNodeList.get(i));
            thenList.add(caseNodeList.get(i + 1));
          }
        }
        elseNode = caseNodeList.get(caseNodeList.size() - 1);
        return new SqlCase(POS, valueNode, new SqlNodeList(whenList, POS),
            new SqlNodeList(thenList, POS), elseNode);


      default:
        final RexCall call = (RexCall) rex;
        final SqlOperator op = call.getOperator();

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase

  public static SqlExpr cmp(SqlExpr left, CompareOp op, SqlExpr right) {
    return new SqlCompare(left, op, right);
  }


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

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase

    throws UnsupportedRdbmsOperatorException
  {
    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

  public void meet(LangMatches node)
    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


  private SqlExpr effectiveBooleanValue(ValueExpr v)
    throws UnsupportedRdbmsOperatorException
  {
    String bool = XMLSchema.BOOLEAN.stringValue();
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(eq(type(v), str(bool)), eq(label(v), str("true")));
    sqlCase.when(simple(type(v)), not(eq(label(v), str(""))));
    sqlCase.when(isNotNull(numeric(v)), not(eq(numeric(v), num(0))));
    return sqlCase;
  }

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase

  private SqlExpr equal(ValueExpr left, ValueExpr right)
    throws UnsupportedRdbmsOperatorException
  {
    SqlExpr bnodes = eq(bNode(left), bNode(right));
    SqlExpr uris = eq(uri(left), uri(right));
    SqlCase scase = new SqlCase();
    scase.when(or(isNotNull(bNode(left)), isNotNull(bNode(right))), bnodes);
    scase.when(or(isNotNull(uri(left)), isNotNull(uri(right))), uris);
    return literalEqual(left, right, scase);
  }

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase

  private SqlExpr termsEqual(ValueExpr left, ValueExpr right)
    throws UnsupportedRdbmsOperatorException
  {
    SqlExpr bnodes = eqIfNotNull(bNode(left), bNode(right));
    SqlExpr uris = eqIfNotNull(uri(left), uri(right));
    SqlCase scase = new SqlCase();
    scase.when(or(isNotNull(bNode(left)), isNotNull(bNode(right))), bnodes);
    scase.when(or(isNotNull(uri(left)), isNotNull(uri(right))), uris);
    return literalEqual(left, right, scase);
  }

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.SqlCase


  @Override
  public void meet(Lang node)
    throws UnsupportedRdbmsOperatorException
  {
    SqlCase sqlCase = new SqlCase();
    sqlCase.when(isNotNull(lang(node.getArg())), lang(node.getArg()));
    sqlCase.when(isNotNull(createLabelExpr(node.getArg())), str(""));
    result = sqlCase;
  }

View Full Code Here

0 1 2

TOP

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.