rafsun42 commented on issue #343: URL: https://github.com/apache/age/issues/343#issuecomment-1365568033
> It sounds like you would like to be able to use the SET clause in AGE to copy all properties from one entity to another, without having to specify each property name individually. > > One alternative you could consider is using the FOREACH clause in your query to iterate over all of the properties of the source entity and set them on the destination entity. The FOREACH clause allows you to execute a block of statements for each element in a list, so you could use it to loop over all of the properties of the source entity and set them on the destination entity one by one. > > For example, you could use a query like the following to copy all properties from one node to another: > > `MATCH (source:Label) MATCH (destination:Label) FOREACH (property IN keys(source) | SET destination[property] = source[property] )` > > This query would match the source and destination nodes, then use the FOREACH clause to iterate over all of the properties of the source node. For each property, it would use the SET clause to set the corresponding property on the destination node to the value of the source property. > > Alternatively, you could consider using the apoc.create.setProperties procedure from the APOC library to copy all properties from one node to another in a single call. This procedure takes two node IDs as arguments and copies all properties from the first node to the second. > > For example, you could use a query like the following to copy all properties from one node to another: `MATCH (source:Label) MATCH (destination:Label) CALL apoc.create.setProperties(destination, source) YIELD node RETURN node` > > This query would match the source and destination nodes, then use the apoc.create.setProperties procedure to copy all properties from the source node to the destination node in a single call. Thanks for mentioning these alternative solutions. However, I already started implementing the updates discussed above. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
