public List<?> translateCommand(Command command, ExecutionContext context) { if (!(command instanceof Select)) { return null; } Select select = (Select)command; TableReference tableReference = select.getFrom().get(0); moveCondition(select, tableReference); return null; }
@Override public List<?> translateCommand(Command command, ExecutionContext context) { if (command instanceof Select) { Select select = (Select)command; if (select.getFrom() == null || select.getFrom().isEmpty()) { List<Object> result = new ArrayList<Object>(); result.add("VALUES("); //$NON-NLS-1$ for (int i = 0; i < select.getDerivedColumns().size(); i++) { DerivedColumn dc = select.getDerivedColumns().get(i); if (i != 0) { result.add(", "); //$NON-NLS-1$ } result.add(dc.getExpression()); } result.add(")"); //$NON-NLS-1$ return result; } } return super.translateCommand(command, context); }
@Override public List<?> translateCommand(Command command, ExecutionContext context) { if (command instanceof Select) { Select select = (Select)command; if (select.getFrom() == null || select.getFrom().isEmpty()) { List<Object> result = new ArrayList<Object>(); result.add("VALUES("); //$NON-NLS-1$ for (int i = 0; i < select.getDerivedColumns().size(); i++) { DerivedColumn dc = select.getDerivedColumns().get(i); if (i != 0) { result.add(", "); //$NON-NLS-1$ } result.add(dc.getExpression()); } result.add(")"); //$NON-NLS-1$ return result; } } return super.translateCommand(command, context); }
@Override public void visit(Select obj) { visitNodes(obj.getFrom()); this.conditionFragments.add(obj.getWhere()); visitNode(obj.getOrderBy()); visitNode(obj.getLimit()); visitNodes(obj.getDerivedColumns()); }
public void testGetFrom() throws Exception { assertNotNull(example(true).getFrom()); }
public void visit(Select obj) { buffer.append(SELECT).append(Tokens.SPACE); if (obj.getFrom() != null && !obj.getFrom().isEmpty()) { NamedTable table = ((NamedTable)obj.getFrom().get(0)); this.worksheetTitle = table.getName(); if (table.getMetadataObject().getNameInSource() != null) { this.worksheetTitle = table.getMetadataObject().getNameInSource(); } } append(obj.getDerivedColumns()); if (obj.getWhere() != null) { buffer.append(Tokens.SPACE).append(WHERE).append(Tokens.SPACE); append(obj.getWhere()); } if (obj.getGroupBy() != null) { buffer.append(Tokens.SPACE); append(obj.getGroupBy()); } if (obj.getOrderBy() != null) { buffer.append(Tokens.SPACE); append(obj.getOrderBy()); } if (obj.getLimit() != null) { if (obj.getLimit().getRowOffset() > 0) { offsetValue = obj.getLimit().getRowOffset(); } limitValue = obj.getLimit().getRowLimit(); } }
tempTables.add(table); select.getFrom().add(0, table); //TODO: assumes that ansi and non-ansi can be mixed
public void testGetFrom() throws Exception { assertNotNull(example().getProjectedQuery().getFrom()); }
Select select = (Select)command; TableReference tr = select.getFrom().get(0); if (tr instanceof NamedTable && isDual((NamedTable)tr)) { if (limit.getRowOffset() > 0 || limit.getRowLimit() == 0) {
@Override public void visit(Select query) { super.visitNodes(query.getFrom());
List<TableReference> fromList = query.getFrom(); Iterator<TableReference> itr = fromList.iterator(); if(!itr.hasNext()) {
@Override public void visit(Select obj) { visitNodes(obj.getDerivedColumns()); visitNodes(obj.getFrom()); visitNode(obj.getWhere()); visitNode(obj.getGroupBy()); visitNode(obj.getHaving()); visitNode(obj.getOrderBy()); }
@Override public void visit(Select obj) { visitNodes(obj.getFrom()); obj.setWhere(buildEntityKey(obj.getWhere())); visitNode(obj.getWhere()); visitNode(obj.getOrderBy()); visitNode(obj.getLimit()); visitNodes(obj.getDerivedColumns()); }
public void visit(Select obj) { visitNode(obj.getWith()); visitNodes(obj.getDerivedColumns()); visitNodes(obj.getFrom()); visitNode(obj.getWhere()); visitNode(obj.getGroupBy()); visitNode(obj.getHaving()); visitNode(obj.getOrderBy()); visitNode(obj.getLimit()); }
List<TableReference> from = ((Select)query).getFrom(); boolean join = false; if(from.get(0) instanceof Join) {