snomed_g_graphdb_cypher_add_assoc_refset.template

// -----------------------------------------------------------------------------------------
// Module:  snomed_g_graphdb_add_assoc_refset.cypher
// Author: Jay Pedersen, University of Nebraska, September 2016
// Concept: Update a SNOMED_G Graph Database from input CSV files which describe the
//          Association Refset.  Creation of the following edges.
//             (ObjectConcept)-[:WASA]->(ObjectConcept)
//             (ObjectConcept)-[:POSSIBLY_REPLACED_BY]->(ObjectConcept)
// Input Files:
//          assoc_refset_new.csv

// Create edges for association refset
RETURN 'Creating ASSOCIATION REFSET edges between ObjectConcept nodes';
USING PERIODIC COMMIT 200
LOAD csv with headers from "<<<file_protocol>>><<<output_dir>>>assoc_refset_new.csv" as line
with line
MATCH (s:ObjectConcept { sctid: line.referencedComponentId }), (d:ObjectConcept { sctid: line.targetComponentId })
WITH s,d,line
CREATE UNIQUE (s)-[:HAS_ASSOCIATION {association: line.association, refsetId: line.refsetId, active: line.active, effectiveTime: line.effectiveTime, referencedComponentId: line.referencedComponentId, targetComponentId: line.targetComponentId, moduleId: line.moduleId, id: line.id } ]->(d);