Package org.teiid.language

Examples of org.teiid.language.AggregateFunction

70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
        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)) {
          af.setName("STDDEVP"); //$NON-NLS-1$
        } else if (af.getName().equals(AggregateFunction.STDDEV_SAMP)) {
          af.setName("STDDEV"); //$NON-NLS-1$
        } else if (af.getName().equals(AggregateFunction.VAR_POP)) {
          af.setName("VARP"); //$NON-NLS-1$
        } else if (af.getName().equals(AggregateFunction.VAR_SAMP)) {
          af.setName("VAR"); //$NON-NLS-1$
        }
      }
      return super.translate(obj, context);
    }
View Full Code Here
90
91
92
93
94
95
96
97
        assertEquals(expected, getString(TestAggregateImpl.example("COUNT", NonReserved.COUNT, false, 42))); //$NON-NLS-1$
    }

    @Test public void testVisitIAggregateDistinct() throws Exception {
        String expected = "COUNT(DISTINCT *)"; //$NON-NLS-1$
        AggregateFunction impl = new AggregateFunction("COUNT", true, null, Integer.class); //$NON-NLS-1$
        assertEquals(expected, getString(impl));
    }
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
     * @since 4.3
     */
    @Override
    public List<?> translate(LanguageObject obj, ExecutionContext context) {
      if (obj instanceof AggregateFunction) {
        AggregateFunction agg = (AggregateFunction)obj;
        if (agg.getExpression() != null && TypeFacility.RUNTIME_TYPES.BOOLEAN.equals(agg.getExpression().getType())) {
              if (agg.getName().equalsIgnoreCase(NonReserved.MIN)) {
                agg.setName("bool_and"); //$NON-NLS-1$
              } else if (agg.getName().equalsIgnoreCase(NonReserved.MAX)) {
                agg.setName("bool_or"); //$NON-NLS-1$
              }
            }
      }
      return super.translate(obj, context);
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
        assertTrue(example("testName", NonReserved.COUNT, true, 42).isDistinct()); //$NON-NLS-1$
        assertFalse(example("testName", NonReserved.COUNT, false, 42).isDistinct()); //$NON-NLS-1$
    }

    public void testGetExpression() throws Exception {
        AggregateFunction agg = example("testName", NonReserved.COUNT, true, 42); //$NON-NLS-1$
        assertNotNull(agg.getExpression());
        assertTrue(agg.getExpression() instanceof Literal);
        assertEquals(new Integer(42), ((Literal)agg.getExpression()).getValue());
    }
View Full Code Here
562
563
564
565
566
567
568
569
570
571
        }
        return element;
    }

    AggregateFunction translate(AggregateSymbol symbol) {
        return new AggregateFunction(symbol.getAggregateFunction().name(),
                                symbol.isDistinct(),
                                translate(symbol.getExpression()),
                                symbol.getType());
    }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
    }
   
    @Override
    public List<?> translate(LanguageObject obj, ExecutionContext context) {
      if (obj instanceof AggregateFunction) {
        AggregateFunction af = (AggregateFunction)obj;
        if (af.getName().equals(AggregateFunction.STDDEV_POP)) {
          af.setName("StDevP"); //$NON-NLS-1$
        } else if (af.getName().equals(AggregateFunction.STDDEV_SAMP)) {
          af.setName("StDev"); //$NON-NLS-1$
        } else if (af.getName().equals(AggregateFunction.VAR_POP)) {
          af.setName("VarP"); //$NON-NLS-1$
        } else if (af.getName().equals(AggregateFunction.VAR_SAMP)) {
          af.setName("Var"); //$NON-NLS-1$
        }
      }
      return super.translate(obj, context);
    }
View Full Code Here
TOP

Related Classes of org.teiid.language.AggregateFunction

  • org.teiid.connector.visitor.util.TestSQLStringVisitor
  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.dqp.internal.datamgr.TestAggregateImpl
  • org.teiid.translator.jdbc.access.AccessExecutionFactory
  • org.teiid.translator.jdbc.postgresql.PostgreSQLExecutionFactory
  • org.teiid.translator.jdbc.sqlserver.SQLServerExecutionFactory
    • 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.