🔍 Code Extractor

Creates a REFERENCES_ESTABLISHMENT relationship in a Neo4j graph database between a dbo_Treatments node (source) and a dbo_Establishment node (target), with optional properties on the relationship.

Purpose

This function establishes a directed relationship in a Neo4j graph database to link treatment records to establishment records. It's designed for healthcare or medical data modeling where treatments need to reference the establishments where they were performed or prescribed. The function supports adding custom properties to the relationship edge for additional metadata.

Source Code

def create_references_establishment_relationship(source_id, target_id, properties=None):
    """Create a REFERENCES_ESTABLISHMENT relationship from dbo_Treatments to dbo_Establishment"""
    props = ""
    if properties:
        props_list = ', '.join([f"r.{prop} = ${prop}" for prop in properties.keys()])
        props = f"SET {props_list}"
    
    query = f"""
    MATCH (source:dbo_Treatments {id: $source_id})
    MATCH (target:dbo_Establishment {id: $target_id})
    CREATE (source)-[r:REFERENCES_ESTABLISHMENT]->(target)
    {props}
    RETURN r
    """
    
    params = {"source_id": source_id, "target_id": target_id}
    if properties:
        params.update(properties)
    
    result = run_query(query, params)
    return result[0] if result else None

Parameters

Parameter Details

source_id: The unique identifier of the source node (dbo_Treatments). This should match the 'id' property of an existing dbo_Treatments node in the Neo4j database. Expected type: string or integer depending on your database schema.

target_id: The unique identifier of the target node (dbo_Establishment). This should match the 'id' property of an existing dbo_Establishment node in the Neo4j database. Expected type: string or integer depending on your database schema.

properties: Optional dictionary containing key-value pairs to set as properties on the created relationship. Keys should be valid property names, and values can be any Neo4j-compatible data types (strings, numbers, booleans, dates, etc.). Default is None, meaning no additional properties are set on the relationship.

Return Value

Returns the created relationship object (r) from Neo4j if successful, containing the relationship details and any properties set. Returns None if the query fails or no relationship is created (e.g., if source or target nodes don't exist). The relationship object typically includes metadata like relationship type, start/end node references, and all properties.

Dependencies

• neo4j

Required Imports

from neo4j import GraphDatabase

Usage Example

# Assuming run_query function is defined and Neo4j is configured

# Example 1: Create relationship without properties
result = create_references_establishment_relationship(
    source_id=12345,
    target_id=67890
)

# Example 2: Create relationship with properties
result = create_references_establishment_relationship(
    source_id=12345,
    target_id=67890,
    properties={
        'reference_date': '2024-01-15',
        'reference_type': 'primary',
        'verified': True
    }
)

if result:
    print(f"Relationship created successfully: {result}")
else:
    print("Failed to create relationship")

Best Practices

• Ensure both source_id and target_id correspond to existing nodes in the database before calling this function to avoid silent failures
• Validate the properties dictionary keys to ensure they follow Neo4j property naming conventions (no spaces, special characters)
• Handle the None return value appropriately in your code to detect when relationship creation fails
• Consider wrapping this function call in try-except blocks to handle potential Neo4j connection errors or query syntax errors
• Be aware of potential Cypher injection vulnerabilities if source_id or target_id come from untrusted sources; the parameterized query approach used here helps mitigate this
• Verify that the run_query function properly manages database sessions and transactions
• Consider adding uniqueness constraints or checking for existing relationships before creating duplicates if your use case requires it

Tags

Similar Components

AI-powered semantic similarity - components with related functionality:

• function create_references_establishment_relationship_v4 87.4% similar

  Creates a REFERENCES_ESTABLISHMENT relationship in a Neo4j graph database between a dbo_EstablishmentCycles node and a dbo_Establishment node, with optional properties on the relationship.

  From: /tf/active/vicechatdev/neo4j_schema/neo4j_python_snippets.py

• function create_references_establishment_relationship_v3 87.3% similar

  Creates a REFERENCES_ESTABLISHMENT relationship in a Neo4j graph database between a dbo_TNV node and a dbo_Establishment node, with optional properties on the relationship.

  From: /tf/active/vicechatdev/neo4j_schema/neo4j_python_snippets.py

• function create_references_establishment_relationship_v2 86.5% similar

  Creates a REFERENCES_ESTABLISHMENT relationship in a Neo4j graph database between a dbo_Houses node and a dbo_Establishment node, with optional properties on the relationship.

  From: /tf/active/vicechatdev/neo4j_schema/neo4j_python_snippets.py

• function create_references_houses_relationship_v3 85.7% similar

  Creates a REFERENCES_HOUSES relationship in a Neo4j graph database between a dbo_Treatments node (source) and a dbo_Houses node (target), with optional properties on the relationship.

  From: /tf/active/vicechatdev/neo4j_schema/neo4j_python_snippets.py

• function create_references_product_relationship 84.8% similar

  Creates a REFERENCES_PRODUCT relationship in a Neo4j graph database between a dbo_Treatments node and a dbo_Product node, with optional properties on the relationship.

  From: /tf/active/vicechatdev/neo4j_schema/neo4j_python_snippets.py