如何通过Neo4j APOC校验触发器是否存在，避免重复操作？

Great question! Running into errors when trying to add a trigger that already exists or delete one that’s not there is super frustrating. Luckily, APOC gives you a straightforward way to check for a trigger’s presence first using the apoc.trigger.list() procedure.

How to Check if a Trigger Exists #

The apoc.trigger.list() procedure returns all currently installed triggers, including their names, configurations, and status. You can use this to filter for your target trigger name before performing add/remove operations.

Safe Trigger Installation #

Use this query to add your trigger only if it doesn’t already exist:

// Add trigger only if it's not already installed
CALL apoc.trigger.list() YIELD name
WITH collect(name) AS existingTriggers
WHERE NOT 'HAS_VALUE_ON_ADD_TO_INDEX' IN existingTriggers
CALL apoc.trigger.add(
  'HAS_VALUE_ON_ADD_TO_INDEX',
  'UNWIND {createdRelationships} AS r MATCH (d:Decision)-[r:HAS_VALUE_ON]->(ch:Characteristic) CALL apoc.index.addRelationship(r, keys(r)) RETURN count(*)',
  {phase:'after'}
)
YIELD name, installed
RETURN name, installed;

This works by:

1. Fetching all existing trigger names
2. Checking if your target trigger is missing from the list
3. Only executing the apoc.trigger.add() call if the condition is met

Safe Trigger Removal #

Similarly, use this query to remove your trigger only if it exists:

// Remove trigger only if it's installed
CALL apoc.trigger.list() YIELD name
WITH collect(name) AS existingTriggers
WHERE 'HAS_VALUE_ON_ADD_TO_INDEX' IN existingTriggers
CALL apoc.trigger.remove('HAS_VALUE_ON_ADD_TO_INDEX')
YIELD name, installed
RETURN name, installed;

Here, we check if the trigger is present in the existing list before attempting to remove it.

Bonus: Reusable Existence Check #

If you need a simple boolean check for the trigger’s status (for branching logic in more complex workflows), use this snippet:

CALL apoc.trigger.list() YIELD name
RETURN 'HAS_VALUE_ON_ADD_TO_INDEX' IN collect(name) AS triggerExists;

内容的提问来源于stack exchange，提问作者alexanoid