如何用Cypher查询自动为新:Post节点关联已有:HashTag节点？

Here's a Cypher query that does exactly what you need—creates a new :Post node and automatically links it to existing :HashTag nodes based on hashtags found in the post text:

// Create the new Post node with provided id and text
CREATE (p:Post {id: $postId, text: $postText})
// Extract all hashtags from the text, convert to lowercase, and collect into a list
WITH p, [tag IN regexp_extract_all($postText, '#\\w+') | toLower(tag)] AS extractedTags
// Match all existing HashTags that match the extracted normalized tags
MATCH (ht:HashTag)
WHERE ht.tag IN extractedTags
// Use MERGE instead of CREATE to avoid duplicate TAG relationships
MERGE (ht)-[:TAG]->(p)
// Return the post and linked hashtags for verification (optional)
RETURN p, collect(ht) AS linkedHashtags

How It Works: #

1. Create the Post Node: We start by creating the new :Post node using your provided id and text parameters ($postId and $postText).
2. Extract & Normalize Hashtags:
   • regexp_extract_all($postText, '#\\w+') finds all substrings starting with # followed by word characters (letters, numbers, underscores) in the post text. This ignores trailing punctuation (like commas or periods) attached to hashtags.
   • toLower(tag) converts each extracted hashtag to lowercase to match your :HashTag nodes' all-lowercase tag property.
3. Match Existing Hashtags: We find all :HashTag nodes whose tag exists in our normalized list of extracted hashtags.
4. Create Relationships: Using MERGE instead of CREATE ensures we don't create duplicate :TAG relationships even if the same hashtag appears multiple times in the post text.

Edge Cases & Alternatives: #

• Hashtags with Special Characters: If your hashtags include characters like hyphens or periods, adjust the regex to #[\w-]+ (for hyphens) or #[\w.-]+ (for hyphens and periods) to capture those correctly.
• Older Neo4j Versions: If regexp_extract_all isn't available (pre-Neo4j 4.0), use APOC's text functions instead:

  CREATE (p:Post {id: $postId, text: $postText})
  WITH p, apoc.text.regexGroups($postText, '#(\\w+)') AS tagGroups
  WITH p, [group IN tagGroups | toLower('#' + group[1])] AS extractedTags
  MATCH (ht:HashTag) WHERE ht.tag IN extractedTags
  MERGE (ht)-[:TAG]->(p)
  RETURN p, collect(ht) AS linkedHashtags
  

  Note: You'll need the APOC library installed for this to work.

Example Usage: #

If you run the query with $postId = 123 and $postText = "Today is #friday, ready for the #weekend":

• It creates the post node.
• Extracts #friday and #weekend, converts them to lowercase.
• If only #weekend exists in your database, it creates a :TAG relationship between that :HashTag and the new post.

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