public DerivedColumn createSelectSymbol(String name, Expression expression) { return new DerivedColumn(name, expression); }
public void testGetColumnDataTypes(){ Class<?>[] expectedResults = new Class[2]; List<DerivedColumn> symbols = new ArrayList<DerivedColumn>(); symbols.add(new DerivedColumn("c1", new Literal("3", DataTypeManager.DefaultDataClasses.STRING))); //$NON-NLS-1$//$NON-NLS-2$ expectedResults[0] = DataTypeManager.DefaultDataClasses.STRING; symbols.add(new DerivedColumn("c2", new Literal(new Integer(5), DataTypeManager.DefaultDataClasses.INTEGER))); //$NON-NLS-1$ expectedResults[1] = DataTypeManager.DefaultDataClasses.INTEGER; Select query = new Select(symbols, false, null, null, null, null, null); Class<?>[] results = query.getColumnTypes(); assertEquals( results[0], expectedResults[0]); assertEquals( results[1], expectedResults[1]); }
public static DerivedColumn example(String symbolName, String alias) throws Exception { DerivedColumn selectSymbol = new DerivedColumn(alias, new ColumnReference(null, symbolName, null, DataTypeManager.DefaultDataClasses.INTEGER)); return selectSymbol; }
select.add(new DerivedColumn(null, val)); if (!columns.contains(c)) { ColumnReference cr = new ColumnReference(update.getTable(), c.getName(), c, c.getJavaType()); select.add(new DerivedColumn(null, cr)); cols.add(cr);
DerivedColumn selectSymbol = new DerivedColumn(alias, iExp); translatedSymbols.add(selectSymbol);
DerivedColumn selectSymbol = new DerivedColumn(alias, iExp); translatedSymbols.add(selectSymbol);
DerivedColumn selectSymbol = new DerivedColumn(alias, iExp); translatedSymbols.add(selectSymbol);
public static SetQuery example2() throws Exception { NamedTable group = new NamedTable("ted", null, null); //$NON-NLS-1$ ColumnReference element = new ColumnReference(group, "nugent", null, String.class); //$NON-NLS-1$ DerivedColumn symbol = new DerivedColumn(null,element); List symbols = new ArrayList(); symbols.add(symbol); DerivedColumn symbol2 = new DerivedColumn(null, element2); List symbols2 = new ArrayList(); symbols2.add(symbol2);
windowSpecification.setOrderBy(orderBy); expression.setWindowSpecification(windowSpecification); select.getDerivedColumns().add(new DerivedColumn("ROWNUM_", expression)); //$NON-NLS-1$ parts.add(" FROM ("); //$NON-NLS-1$ parts.add(select);
@Override public List<?> translateCommand(Command command, ExecutionContext context) { if (command instanceof SetQuery) { SetQuery set = (SetQuery)command; if (!set.isAll()) { //distinct is not supported, convert to an inline view and add distinct Select s = new Select(); s.setDistinct(true); s.setDerivedColumns(new ArrayList<DerivedColumn>()); s.setOrderBy(set.getOrderBy()); for (DerivedColumn dc : set.getProjectedQuery().getDerivedColumns()) { Assertion.assertTrue(dc.getAlias() != null); //it's expected that the columns will be aliases ColumnReference cr = new ColumnReference(null, dc.getAlias(), null, dc.getExpression().getType()); s.getDerivedColumns().add(new DerivedColumn(null, cr)); } set.setOrderBy(null); s.setLimit(set.getLimit()); set.setLimit(null); set.setAll(true); s.setFrom(Arrays.asList((TableReference)new DerivedTable(set, "x"))); //$NON-NLS-1$ return Arrays.asList(s); } } return super.translateCommand(command, context); }