Package org.teiid.language

Examples of org.teiid.language.ColumnReference

97
98
99
100
101
102
103
104
        helpTestMod(arg1, "EXTRACT(DAY FROM {ts '2004-01-21 17:05:00.0'})", "dayofmonth"); //$NON-NLS-1$ //$NON-NLS-2$
    }   

    public void test11() throws Exception {
        NamedTable group = LANG_FACTORY.createNamedTable("group", null, null); //$NON-NLS-1$
        ColumnReference elem = LANG_FACTORY.createColumnReference("col", group, null, TypeFacility.RUNTIME_TYPES.DATE); //$NON-NLS-1$
        helpTestMod(elem, "EXTRACT(DAY FROM group.col)", "dayofmonth"); //$NON-NLS-1$ //$NON-NLS-2$
    }
View Full Code Here
103
104
105
106
107
108
109
110
        helpTestMod(elem, "EXTRACT(DAY FROM group.col)", "dayofmonth"); //$NON-NLS-1$ //$NON-NLS-2$
    }
   
    public void test12() throws Exception {
        NamedTable group = LANG_FACTORY.createNamedTable("group", null, null); //$NON-NLS-1$
        ColumnReference elem = LANG_FACTORY.createColumnReference("col", group, null, TypeFacility.RUNTIME_TYPES.DATE); //$NON-NLS-1$
        helpTestMod(elem, "(EXTRACT(DOW FROM group.col) + 1)", SourceSystemFunctions.DAYOFWEEK); //$NON-NLS-1$
    }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
65
      {
        Expression expr = iter.next();
        if (expr instanceof ColumnReference) {
          boolean dotAll = false;
          boolean useSelector = false;
          ColumnReference cr = (ColumnReference)expr;
          Column c = cr.getMetadataObject();
          if (c != null) {
            if ("\"mode:properties\"".equalsIgnoreCase(c.getNameInSource())) { //$NON-NLS-1$
              dotAll = true;
              useSelector = true;
            } else if ("\"jcr:path\"".equalsIgnoreCase(c.getNameInSource())) { //$NON-NLS-1$
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
    }
    public LanguageObject example1() {
        NamedTable g = new NamedTable("g1", null, null); //$NON-NLS-1$
        List symbols = new ArrayList();       
        symbols.add(new ColumnReference(g, "e1", null, String.class)); //$NON-NLS-1$
        Function function = new Function("length", Arrays.asList(new ColumnReference(g, "e2", null, String.class)), Integer.class); //$NON-NLS-1$ //$NON-NLS-2$
        symbols.add(function);
        List groups = new ArrayList();
        groups.add(g);
        Select q = new Select(symbols, false, groups, null, null, null, null);
            
View Full Code Here
114
115
116
117
118
119
120
121
122
        assertEquals("Did not get expected groups", expectedGroups, actualGroups);         //$NON-NLS-1$
    }
   
    public void test1() {
        NamedTable g1 = new NamedTable("g1", null, null); //$NON-NLS-1$
        ColumnReference e1 = new ColumnReference(g1, "e1", null, String.class); //$NON-NLS-1$
       
        helpTestElementsUsedByGroups(e1, new String[] {"g1.e1"}, new String[] {"g1"}); //$NON-NLS-1$ //$NON-NLS-2$
    }
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
        helpTestElementsUsedByGroups(e1, new String[] {"g1.e1"}, new String[] {"g1"}); //$NON-NLS-1$ //$NON-NLS-2$
    }
   
    public void test2() {
        NamedTable g1 = new NamedTable("g1", null, null); //$NON-NLS-1$
        ColumnReference e1 = new ColumnReference(g1, "e1", null, String.class); //$NON-NLS-1$
        ColumnReference e2 = new ColumnReference(g1, "e2", null, String.class); //$NON-NLS-1$
        Comparison cc = new Comparison(e1, e2, Operator.EQ);
       
        helpTestElementsUsedByGroups(cc, new String[] {"g1.e1", "g1.e2"}, new String[] {"g1"}); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
  }
 
    @Override
    public List<?> translate(LanguageObject obj, ExecutionContext context) {
      if (obj instanceof ColumnReference) {
        ColumnReference elem = (ColumnReference)obj;
      if (TypeFacility.RUNTIME_TYPES.STRING.equals(elem.getType()) && elem.getMetadataObject() != null && "uniqueidentifier".equalsIgnoreCase(elem.getMetadataObject().getNativeType())) { //$NON-NLS-1$
        return Arrays.asList("cast(", elem, " as char(36))"); //$NON-NLS-1$ //$NON-NLS-2$
      }
      } else if (obj instanceof AggregateFunction) {
        AggregateFunction af = (AggregateFunction)obj;
        if (af.getName().equals(AggregateFunction.STDDEV_POP)) {
View Full Code Here
164
165
166
167
168
169
170
171
172
173
    }
   
    @Test public void testVisitConvertFunctionOracleStyle() throws Exception {
        String expected = "convert(columnA, integer)"; //$NON-NLS-1$
       
        List<? extends Expression> params = Arrays.asList(new ColumnReference(null, "columnA", null, String.class), new Literal("integer", String.class));
        Function test = new Function("convert", params, Integer.class); //$NON-NLS-1$
       
        assertEquals(expected, getString(test));
    }
View Full Code Here
368
369
370
371
372
373
374
375
376
377
378
379
    }
    else if (tgtType.equals(String.class) && (expr instanceof Function)) {
     
      Function func = (Function)expr;
      if (func.getParameters().get(0) instanceof ColumnReference) {
        ColumnReference ref = (ColumnReference)func.getParameters().get(0);
        if(Number.class.isAssignableFrom(ref.getType())) {
          ArrayList target = new ArrayList();
          target.add("cast("); //$NON-NLS-1$
          target.add(func.getParameters().get(0));
          target.add(" AS varchar(100))"); //$NON-NLS-1$
        }
View Full Code Here
519
520
521
522
523
524
525
526
527
528
529
530
531
      } else if (obj instanceof Command) {
        parts = translateCommand((Command)obj, context);
      } else if (obj instanceof Limit) {
        parts = translateLimit((Limit)obj, context);
      } else if (obj instanceof ColumnReference) {
        ColumnReference elem = (ColumnReference)obj;
      if (isTrimStrings() && elem.getType() == TypeFacility.RUNTIME_TYPES.STRING && elem.getMetadataObject() != null
          && ("char".equalsIgnoreCase(elem.getMetadataObject().getNativeType()) || "nchar".equalsIgnoreCase(elem.getMetadataObject().getNativeType()))) { //$NON-NLS-1$ //$NON-NLS-2$
        return Arrays.asList(getLanguageFactory().createFunction(SourceSystemFunctions.RTRIM, new Expression[] {elem}, TypeFacility.RUNTIME_TYPES.STRING));
      }
      }
      return parts;
    }
View Full Code Here
TOP

Related Classes of org.teiid.language.ColumnReference

  • org.teiid.connector.metadata.runtime.MockConnector
  • org.teiid.connector.metadata.runtime.TestElement
  • org.teiid.connector.metadata.runtime.TestMetadataObject
  • org.teiid.connector.visitor.util.TestCollectorVisitor
  • org.teiid.connector.visitor.util.TestSQLStringVisitor
  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.dqp.internal.datamgr.TestElementImpl
  • org.teiid.dqp.internal.datamgr.TestSelectSymbolImpl
  • org.teiid.dqp.internal.datamgr.TestSetQueryImpl
  • org.teiid.translator.jdbc.JDBCExecutionFactory
    • 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.