🔍 Code Extractor

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

Purpose

This function establishes a directed relationship in Neo4j from a LIMS_Samples node to a dbo_Establishment node. It's designed for linking laboratory information management system (LIMS) samples to establishment records in a graph database. The function supports adding custom properties to the relationship and uses parameterized queries to prevent injection attacks.

Source Code

def create_references_establishment_relationship(source_id, target_id, properties=None):
    """Create a REFERENCES_ESTABLISHMENT relationship from LIMS_Samples 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:LIMS_Samples {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 LIMS_Samples node. This should match the 'id' property of an existing LIMS_Samples node in the Neo4j database. Expected type: string or integer depending on your node ID schema.

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

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

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 return type is typically a Neo4j Record object or None.

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="SAMPLE_001",
    target_id="EST_123"
)

# Example 2: Create relationship with properties
result = create_references_establishment_relationship(
    source_id="SAMPLE_002",
    target_id="EST_456",
    properties={
        "reference_date": "2024-01-15",
        "confidence_score": 0.95,
        "verified": True
    }
)

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

Best Practices

• Always verify that both source and target nodes exist in the database before calling this function to avoid silent failures
• Use parameterized queries (as implemented) to prevent Cypher injection attacks
• Handle the None return value appropriately in your code to detect failed relationship creation
• Ensure the run_query function properly manages Neo4j sessions and transactions
• Consider adding error handling around this function call to catch Neo4j connection errors or constraint violations
• Be aware that the Cypher query syntax has a typo: {id: $source_id} should be {{id: $source_id}} for proper Cypher syntax
• Validate property names and values before passing them to avoid Neo4j type errors
• Consider adding duplicate relationship checks if your use case requires unique relationships between nodes

Tags

Similar Components

AI-powered semantic similarity - components with related functionality:

• function create_references_establishment_relationship 95.6% similar

  Creates a REFERENCES_ESTABLISHMENT relationship in a Neo4j graph database between a LIMS_Requests 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_v4 86.1% 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 get_lims_samples_with_references_establishment_dbo_establishment 85.5% similar

  Queries a Neo4j graph database to retrieve dbo_Establishment nodes that are connected to a specific LIMS_Samples node through a REFERENCES_ESTABLISHMENT relationship.

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

• function create_references_samples_relationship_v1 84.5% similar

  Creates a REFERENCES_SAMPLES relationship in a Neo4j graph database between a LIMS_SampleTestResultDetails node and a LIMS_Samples node, with optional properties on the relationship.

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

• function create_references_samples_relationship 84.3% similar

  Creates a REFERENCES_SAMPLES relationship in a Neo4j graph database between a LIMS_SampleTestResults node and a LIMS_Samples node, with optional properties on the relationship.

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