Skip to content

neo4j

Code Snippets

// Delete all nodes with their chil nodes
MATCH (n)
DETACH DELETE n


// LOAD CSV file and parse it
LOAD CSV WITH HEADERS FROM 'file:///NSGs.csv' AS line
MERGE (src: host { host:  line.Source } )
MERGE (dst: host { host:  line.Destination } )
MERGE (dst) - [:HAS_PORT] -> (port: port { portNum: line.Destination_Port } )
MERGE (src) - [ALLOW:ALLOW {ALLOW: "ALLOW"} ] -> (port)  

// Alternatively
LOAD CSV WITH HEADERS FROM 'file:///NSGs.csv' AS line
MERGE (srcHost: srcHost { host:  line.Source_Name } )
MERGE (dstHost: dstHost { host:  line.Destination } )
MERGE (srcHost) - [PORT: ALLOW { dstPort: line.Destination_Port }  ] -> (dstHost)


// Get Graph Representation
WITH *
Match (n)
return n

resources

Introduction to Cypher - Getting Started (neo4j.com) Importing CSV data into Neo4j - Getting Started Default file locations - Operations Manual (neo4j.com) How-To: Import CSV Data with Neo4j Desktop - Developer Guides training/0123_importing_data.adoc at master ยท neo4j-contrib/training (github.com)