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 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; }
insert = new Insert(update.getTable(), cols, new ExpressionValueSource(vals)); } else { List<DerivedColumn> select = new ArrayList<DerivedColumn>(); KeyRecord pk = update.getTable().getMetadataObject().getPrimaryKey(); if(pk != null) { for (Column c : pk.getColumns()) { if (!columns.contains(c)) { ColumnReference cr = new ColumnReference(update.getTable(), c.getName(), c, c.getJavaType()); select.add(new DerivedColumn(null, cr)); cols.add(cr); Select query = new Select(select, false, Arrays.asList((TableReference)update.getTable()), update.getWhere(), null, null, null); insert = new Insert(update.getTable(), cols, query);
public void visit(Update obj) { visitNode(obj.getTable()); visitNodes(obj.getChanges()); visitNode(obj.getWhere()); }
public void testGetGroup() throws Exception { assertNotNull(example().getTable()); }
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()); }
@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 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); } }
@Override public void visit(Update obj) { this.condition = obj.getWhere(); append(obj.getTable()); && this.mongoDoc.isPartOfPrimaryKey(colName)) { throw new TranslatorException(MongoDBPlugin.Event.TEIID18035, MongoDBPlugin.Util.gs( MongoDBPlugin.Event.TEIID18035, colName, obj.getTable().getName())); } else if (this.mongoDoc.getMergeKey().getAssociation() == Association.MANY && this.mongoDoc.isPartOfForeignKey(colName)) { throw new TranslatorException(MongoDBPlugin.Event.TEIID18036, MongoDBPlugin.Util.gs( MongoDBPlugin.Event.TEIID18036, colName, obj.getTable().getName())); this.mongoDoc.updateReferenceColumnValue(obj.getTable().getName(), colName, value);