Neo4j Knowledge Graph

services:
  neo4j:
    container_name: neo4j
    image: neo4j:latest
    ports:
      - 7474:7474
      - 7687:7687
    environment:
      - NEO4J_AUTH=neo4j/${NEO4J_PASSWORD}
      - NEO4J_apoc_export_file_enabled=true
      - NEO4J_apoc_import_file_enabled=true
      - NEO4J_apoc_import_file_use__neo4j__config=true
      - NEO4J_PLUGINS=["apoc", "graph-data-science"]
    volumes:
      - ./neo4j_db/data:/data
      - ./neo4j_db/logs:/logs
      - ./neo4j_db/import:/var/lib/neo4j/import
      - ./neo4j_db/plugins:/plugins

LOAD CSV WITH HEADERS
FROM 'https://raw.githubusercontent.com/MidnightSkyUniverse/udemyNeo4j/master/data/titles_and_skills.csv'
AS row
RETURN row.Title, row.Skills
LIMIT 15;

sudo
docker-compose -f docker-compose.yml exec neo4j /bin/sh

$ sudo add-apt-repository ppa:cleishm/neo4j$ sudo apt-get update$ sudo apt-get install neo4j-client
libneo4j-client-dev

chmod a+x neo4j-desktop-1.6.0-x86_64.AppImage./neo4j-desktop-1.6.0-x86_64.AppImage

CREATE CONSTRAINT skillUniqueIF NOT EXISTSFOR (s:Skill)REQUIRE s.name IS UNIQUE;
CREATE CONSTRAINT
titleUniqueIF NOT EXISTSFOR (t:Title)REQUIRE t.name IS UNIQUE;
SHOW ALL CONSTRAINTS;

LOAD CSV WITH HEADERS
FROM 'https://raw.githubusercontent.com/MidnightSkyUniverse/udemyNeo4j/master/data/titles_and_skills.csv'
AS row
MERGE (t:Title {name: row.Title});

MATCH (n:Title) RETURN n LIMIT 25

LOAD CSV WITH HEADERS
FROM 'https://raw.githubusercontent.com/MidnightSkyUniverse/udemyNeo4j/master/data/skills_details.csv'
AS row
MERGE (s:Skill {name: row.Skill})
SET
    s.id = row.ID,
    s.description = row.Description,
    s.category = row.Category;