Examples of org.teiid.query.sql.symbol.DerivedColumn

org.teiid.query.sql.symbol.DerivedColumn


  private Evaluator.NameValuePair<Object>[] getNameValuePairs(List<?> tuple, List<DerivedColumn> args, boolean xmlNames)
      throws ExpressionEvaluationException, BlockedException, TeiidComponentException {
    Evaluator.NameValuePair<Object>[] nameValuePairs = new Evaluator.NameValuePair[args.size()];
    for (int i = 0; i < args.size(); i++) {
      DerivedColumn symbol = args.get(i);
      String name = symbol.getAlias();
      Expression ex = symbol.getExpression();
      if (name == null && ex instanceof ElementSymbol) {
        name = ((ElementSymbol)ex).getShortName();
        if (xmlNames) {
          name = XMLSystemFunctions.escapeName(name, true);
        }

View Full Code Here

      helpTestExpression("xmlelement(\"table\", 'x')", "XMLELEMENT(NAME \"table\", 'x')", f);
    }
    
    @Test public void testXmlElementWithAttributes() throws Exception {
      XMLElement f = new XMLElement("y", new ArrayList<Expression>());
      f.setAttributes(new XMLAttributes(Arrays.asList(new DerivedColumn("val", new Constant("a")))));
      helpTestExpression("xmlelement(y, xmlattributes('a' as val))", "XMLELEMENT(NAME y, XMLATTRIBUTES('a' AS val))", f);
    }

View Full Code Here

      f.setAttributes(new XMLAttributes(Arrays.asList(new DerivedColumn("val", new Constant("a")))));
      helpTestExpression("xmlelement(y, xmlattributes('a' as val))", "XMLELEMENT(NAME y, XMLATTRIBUTES('a' AS val))", f);
    }
    
    @Test public void testXmlForest() throws Exception {
      XMLForest f = new XMLForest(Arrays.asList(new DerivedColumn("table", new ElementSymbol("a"))));
      helpTestExpression("xmlforest(a as \"table\")", "XMLFOREST(a AS \"table\")", f);
    }

View Full Code Here

      Function f = new Function("xmlpi", new Expression[] {new Constant("a"), new ElementSymbol("val")});
      helpTestExpression("xmlpi(NAME a, val)", "xmlpi(NAME a, val)", f);
    }
    
    @Test public void testXmlNamespaces() throws Exception {
      XMLForest f = new XMLForest(Arrays.asList(new DerivedColumn("table", new ElementSymbol("a"))));
      f.setNamespaces(new XMLNamespaces(Arrays.asList(new XMLNamespaces.NamespaceItem(), new XMLNamespaces.NamespaceItem("http://foo", "x"))));
      helpTestExpression("xmlforest(xmlnamespaces(no default, 'http://foo' as x), a as \"table\")", "XMLFOREST(XMLNAMESPACES(NO DEFAULT, 'http://foo' AS x), a AS \"table\")", f);
    }

View Full Code Here

        helpTest(sql, "SELECT XMLAGG(1 ORDER BY e2)", query);
    }
    
    @Test public void testTextAggWithOrderBy() throws Exception {
      List<DerivedColumn> expressions = new ArrayList<DerivedColumn>();
      expressions.add(new DerivedColumn("col1", new ElementSymbol("e1")));
      expressions.add(new DerivedColumn("col2", new ElementSymbol("e2")));
                
        TextLine tf = new TextLine();
        tf.setExpressions(expressions);
        tf.setDelimiter(new Character(','));
        tf.setIncludeHeader(true);

View Full Code Here

    
    @Test public void testXmlQuery() throws Exception {
      XMLQuery f = new XMLQuery();
      f.setXquery("/x");
      f.setEmptyOnEmpty(false);
      f.setPassing(Arrays.asList(new DerivedColumn(null, new ElementSymbol("foo"))));
      helpTestExpression("xmlquery('/x' passing foo null on empty)", "XMLQUERY('/x' PASSING foo NULL ON EMPTY)", f);
    }

View Full Code Here

TOP

Related Classes of org.teiid.query.sql.symbol.DerivedColumn

org.teiid.query.eval.Evaluator

org.teiid.query.parser.TestParser

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.