how can I create a constraint using two fields

Question

how can I create a constraint using two fields. for example.

CREATE CONSTRAINT ON (m:BBG_Security_DATA) ASSERT m.ISIN, m.CUSIP IS UNIQUE;

When I am executing the above cypher statement it is giving an error message.

Thanks, Shafeeque

This question has been asked and answered many times before. For example, see question #2 of stackoverflow.com/questions/41862488/…, and the accepted answer. — cybersam

stdob-- stdob-- · Accepted Answer · 2017-02-03T10:00:03

You can use triggers from APOC:

CREATE INDEX ON :BBG_Security_DATA (ISIN);

CREATE INDEX ON :BBG_Security_DATA (CUSIP);

CALL apoc.trigger.add(':BBG_Security_DATA (ISIN,CUSIP) IS UNIQUE', '
    UNWIND {createdNodes} AS n 
    WITH n 
         WHERE ALL(l in ["BBG_Security_DATA"] WHERE l in LABELS(n)) AND 
               ALL(k in ["ISIN", "CUSIP"] WHERE k in keys(n))
    MATCH (t:BBG_Security_DATA) 
          WHERE t<>n AND
                ALL(k in ["ISIN", "CUSIP"] WHERE t[k] = n[k])
    DETACH DELETE n
', {phase:'before'});

how can I create a constraint using two fields

2 Answers