Neo4j how to delete nodes recursively from some start node

Question

In my Neo4j database I have a following entities:

@NodeEntity
public class Product {

    private final static String CONTAINS = "CONTAINS";
    private final static String DEFINED_BY = "DEFINED_BY";
    private final static String VOTED_FOR = "VOTED_FOR";
    private final static String PARENT = "PARENT";
    private final static String CREATED_BY = "CREATED_BY";

    @GraphId
    private Long id;

    @RelatedTo(type = PARENT, direction = Direction.INCOMING)
    private Product parent;

    @RelatedTo(type = CONTAINS, direction = Direction.OUTGOING)
    private Set<Product> childProducts = new HashSet<>();

    @RelatedTo(type = DEFINED_BY, direction = Direction.INCOMING)
    private Set<Criterion> criterias = new HashSet<>();

    @RelatedTo(type = VOTED_FOR, direction = Direction.INCOMING)
    private Set<Vote> votes = new HashSet<>();

    @RelatedTo(type = CREATED_BY, direction = Direction.OUTGOING)
    private User user;

}    

@NodeEntity
public class Criterion {

    private final static String CREATED_BY = "CREATED_BY";
    private final static String DEFINED_BY = "DEFINED_BY";

    @GraphId
    private Long id;

    @RelatedTo(type = DEFINED_BY, direction = Direction.OUTGOING)
    private Product owner;

    @RelatedTo(type = CREATED_BY, direction = Direction.OUTGOING)
    private User user;

}

@NodeEntity
public class Vote {

    private static final String VOTED_ON = "VOTED_ON";
    private final static String VOTED_FOR = "VOTED_FOR";
    private static final String CREATED_BY = "CREATED_BY";

    @GraphId
    private Long id;

    @RelatedTo(type = VOTED_FOR, direction = Direction.OUTGOING)
    private Product product;

    @RelatedTo(type = VOTED_ON, direction = Direction.OUTGOING)
    private Criterion criterion;

    @RelatedTo(type = CREATED_BY, direction = Direction.OUTGOING)
    private User user;

}

Product is a composite entity and can contain child Products. Starting from some Product node in the hierarchy I need to delete all Votes on this Product and then I need to recursively delete all child Products, Criteria defined by these nodes and Votes. User nodes must not be deleted.

I have tried this Cypher query:

MATCH (p:Product)-[r:CONTAINS*]-(e) WHERE id(p) = {productId} FOREACH (rel IN r| DELETE rel) DELETE e

but it deletes only Products and doesn't delete Votes on the start node and all child Criteria and Votes. Please help me with a correct Cypher query. Thanks.

score 2 · Accepted Answer · edited Jun 20 '20 at 09:12

2

I'd split that up into two queries. The first one recursively collects the the product hierarchy downwards and the second one deletes one product node and its direct environment.

Getting the product hierarchy is simple:

MATCH (p:Product)-[:CONTAINS*]->(childProduct)
WHERE id(p) = {productId}
RETURN id(childProduct) as id

To delete one product we need to delete all relationships of that product node. Additionally all related nodes need to be deleted as well if they are neither user (you want to keep them) or products (think of parent products - they should be kept as well). Also we need to be sure the target nodes are not connected, thats's why the 2nd optional match:

MATCH (p:Product) 
OPTIONAL MATCH (p)-[r]-(t)
WHERE id(p) = {productId}
DELETE r,p
WITH t
OPTIONAL MATCH (t)-[r2:VOTE_ON|:CREATED_BY]->()
WHERE none(x in labels(t) WHERE x in ["User", "Product"])
DELETE t,r2

I did not test this query myself since you didn't provide a test graph. So take this as an idea and modify it until it works.

update

In a chat we found that this cypher statement solves the problem, note that Product has been replaced by Decision label in the model:

MATCH (p:Decision) 
WHERE p.name = "NoSQL" 
WITH p 
OPTIONAL MATCH (p)-[r]-(t) 
DELETE p,r 
WITH t,r 
OPTIONAL MATCH (t)-[r2:VOTED_ON|:CREATED_BY|:VOTED_FOR]-() 
WITH t, r2,r 
WHERE none(x in labels(t) WHERE x in ["User", "Decision"]) 
DELETE t,r2

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 18 '15 at 10:01

Stefan Armbruster

39,465
6
87
97

Thanks for your answer ! So, I need to collect all child products Ids and then invoke the second query on each of these ids ? Does order matters? – alexanoid Apr 18 '15 at 10:12
1

Exactly. You can also pass in multiple ids as array parameter into the 2nd statement if you use `WHERE id(p) in {myIdList}`. Keep in mind to have a backup of your data before trying that. – Stefan Armbruster Apr 18 '15 at 10:14
Order does not matter. – Stefan Armbruster Apr 18 '15 at 10:18
Thanks ! Looks like this part of the query doesn't work - WHERE none(x in labels(t) WHERE x in ['User', 'Product']) because it deletes users and other Products also.. – alexanoid Apr 18 '15 at 10:57
can you provide a sample graph? – Stefan Armbruster Apr 18 '15 at 11:00
I think yes.. could you please tell me in what way it can be provided ? – alexanoid Apr 18 '15 at 11:05
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/75578/discussion-between-stefan-armbruster-and-alexanoid). – Stefan Armbruster Apr 18 '15 at 11:08
Stefan, thank you so much ! Your last query works like a charm! – alexanoid Apr 18 '15 at 12:25

Neo4j how to delete nodes recursively from some start node

1 Answers1

update

Linked