Cypher Neo4J – CASE Expression with MERGE

by

To do conditional write operations you need to use the FOREACH trick. Using CASE you either return a one element array or a empty one. FOREACH iterates over the CASE expression and therefore conditionally executes the action. If you want an ELSE part as well you need to have a another FOREACH using the inverse condition in the CASE. As an example, instead of

WHEN 'y' THEN
   MERGE (u)-[r2:STAGE {startdate:20141225, enddate:'99999999', status:'InProgress'}]->(b2     {fork:'fail'}) RETURN 1
ELSE 
    MERGE (u)-[r2:STAGE {startdate:20141225, enddate:'99999999', status:'InProgress'}]->(b2)   RETURN 2
END

use

FOREACH(ignoreMe IN CASE WHEN 'y' THEN [1] ELSE [] END | 
    MERGE (u)-[r2:STAGE {startdate:20141225, enddate:'99999999', status:'InProgress'}]->(b2 {fork:'fail'})
)
FOREACH(ignoreMe IN CASE WHEN NOT 'y' THEN [1] ELSE [] END | 
    MERGE (u)-[r2:STAGE {startdate:20141225, enddate:'99999999', status:'InProgress'}]->(b2)
)

See also Mark’s blog post on this.

More Related Contents:

  1. Why does neo4j warn: “This query builds a cartesian product between disconnected patterns”?
  2. Return node if relationship is not present
  3. Excel – Combine multiple columns into one column
  4. How to merge two tables overwriting the elements which are in both?
  5. Returning only simple paths in Neo4j Cypher query
  6. What does a comma in a Cypher query do?
  7. How to hide unwanted relationships between nodes in Neo4j
  8. Is there a way to show cypher execution plan?
  9. Clearcase UCM – Cross delivering vs. delivering upwards?
  10. Search list with mutual count (2nd try)
  11. Context-aware merge?
  12. How do I integrate Beyond Compare with ClearCase?
  13. Find complement of a data frame (anti – join)
  14. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  15. Algorithm for N-way merge
  16. merging several python dictionaries
  17. What is the precise meaning of “ours” and “theirs” in git?
  18. How to merge 2 List and removing duplicate values from it in C#
  19. Merge two arrays containing objects and remove duplicate values
  20. git partial merge, not whole branch
  21. How can I combine hashes in Perl?
  22. Switch executes all case statements
  23. Change values in multiple columns of a dataframe using a lookup table
  24. How can I get the parents of a merge commit in Git?
  25. Merge 2 text files into one, same lines
  26. How to merge dicts, collecting values from matching keys?
  27. Merge several Python dictionaries
  28. how to concat two data frames with different column names in pandas? – python
  29. How to perform an action every 5 results?
  30. R: merge two irregular time series

Leave a Comment