public void visit(Update obj) { buffer.append(UPDATE) .append(Tokens.SPACE); appendSourceComment(obj); append(obj.getTable()); buffer.append(Tokens.SPACE) .append(SET) .append(Tokens.SPACE); append(obj.getChanges()); if (obj.getWhere() != null) { buffer.append(Tokens.SPACE) .append(WHERE) .append(Tokens.SPACE); append(obj.getWhere()); } }
@Override public void visit(Update update) { // don't visit the changes or they will be in the query. visitNode(update.getTable()); visitNode(update.getWhere()); try { loadColumnMetadata(update.getTable()); } catch (TranslatorException ce) { exceptions.add(ce); } }
@Override public void visit(Update obj) { if (obj.getParameterValues() != null) { this.exceptions.add(new TranslatorException(SimpleDBPlugin.Event.TEIID24006, SimpleDBPlugin.Util.gs(SimpleDBPlugin.Event.TEIID24006))); } this.table = obj.getTable().getMetadataObject(); for(SetClause setClause : obj.getChanges()){ visitNode(setClause); } if (obj.getWhere() != null) { this.criteria = SimpleDBSQLVisitor.getSQLString(obj.getWhere()); } }
@Override public void execute() throws TranslatorException { UpdateVisitor visitor = new UpdateVisitor(getMetadata()); visitor.visit((Update)command); execute(((Update)command).getWhere(), visitor); }
public void testGetCriteria() throws Exception { assertNotNull(example().getWhere()); }
public void visit(Update obj) { visitNode(obj.getTable()); visitNodes(obj.getChanges()); visitNode(obj.getWhere()); }
@Override public void visit(Update obj) { this.method = "PUT"; //$NON-NLS-1$ this.entity = obj.getTable().getMetadataObject(); visitNode(obj.getTable()); // only pk are allowed, no other criteria not allowed obj.setWhere(buildEntityKey(obj.getWhere())); // this will build with entity keys this.uri = getEnitityURL(); if (this.uri.indexOf('(') == -1) { this.exceptions.add(new TranslatorException(ODataPlugin.Util.gs(ODataPlugin.Event.TEIID17011, this.filter.toString()))); } if (this.filter.length() > 0) { this.exceptions.add(new TranslatorException(ODataPlugin.Util.gs(ODataPlugin.Event.TEIID17009, this.filter.toString()))); } final List<OProperty<?>> props = new ArrayList<OProperty<?>>(); int elementCount = obj.getChanges().size(); for (int i = 0; i < elementCount; i++) { Column column = obj.getChanges().get(i).getSymbol().getMetadataObject(); OProperty<?> property = readProperty(column, obj.getChanges().get(i).getValue()); props.add(property); } this.payload = props; }
if (update.getWhere() == null) { insert = new Insert(update.getTable(), cols, new ExpressionValueSource(vals)); } else { Select query = new Select(select, false, Arrays.asList((TableReference)update.getTable()), update.getWhere(), null, null, null); insert = new Insert(update.getTable(), cols, query);
@Override public void visit(Update obj) { this.operationType = OperationType.UPDATE; visitNode(obj.getTable()); this.odataQuery.setCondition(obj.getWhere()); try { // read the properties int elementCount = obj.getChanges().size(); for (int i = 0; i < elementCount; i++) { Column column = obj.getChanges().get(i).getSymbol().getMetadataObject(); String type = ODataTypeManager.odataType(column) .getFullQualifiedName().getFullQualifiedNameAsString(); Expression expr = obj.getChanges().get(i).getValue(); Object value = resolveExpressionValue(expr); this.odataQuery.addUpdateProperty(column, type, value); } } catch (TranslatorException e) { this.exceptions.add(e); } }
Condition criteria = ((Update)command).getWhere();
public void visit(Update obj) { worksheetTitle = obj.getTable().getName(); changes = new ArrayList<UpdateSet>(); String columnName; if (obj.getTable().getMetadataObject().getNameInSource() != null) { this.worksheetTitle = obj.getTable().getMetadataObject().getNameInSource(); } for (SetClause s : obj.getChanges()) { if(s.getSymbol().getMetadataObject().getNameInSource()!=null){ columnName=s.getSymbol().getMetadataObject().getNameInSource(); }else{ columnName=s.getSymbol().getMetadataObject().getName(); } changes.add(new UpdateSet(columnName, getStringValue(s.getValue()))); } translateWhere(obj.getWhere()); }