Character-related relationships

omgc-may-4-6.cypher

WITH "https://vbatushkov.bitbucket.io/swapi.json" AS url
CALL apoc.load.json(url) YIELD value
UNWIND value.people as character
UNWIND character.species as species_url
MATCH (c:Character { url: character.url })
MATCH (spec:Species { url: species_url })
MERGE (c)-[:OF]->(spec);
WITH "https://vbatushkov.bitbucket.io/swapi.json" AS url
CALL apoc.load.json(url) YIELD value
UNWIND value.people as character
MATCH (c:Character { url: character.url })
MATCH (p:Planet { url: character.homeworld })
MERGE (c)-[:HOMEWORLD]->(p);
WITH "https://vbatushkov.bitbucket.io/swapi.json" AS url
CALL apoc.load.json(url) YIELD value
UNWIND value.people as character
UNWIND character.vehicles as vehicle_url
MATCH (c:Character { url: character.url })
MATCH (v:Vehicle { url: vehicle_url })
MERGE (c)-[:PILOT]->(v);
WITH "https://vbatushkov.bitbucket.io/swapi.json" AS url
CALL apoc.load.json(url) YIELD value
UNWIND value.people as character
UNWIND character.starships as starship_url
MATCH (c:Character { url: character.url })
MATCH (s:Starship { url: starship_url })
MERGE (c)-[:PILOT]->(s);