MeidokonWiki:

info dump

MATCH (n:Person) DETACH DELETE n
LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/humans.csv" AS row CREATE (n:Person) SET n = row RETURN *

LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/aliases.csv" AS alias MATCH (p:Person) WHERE p.name = alias.person MATCH (a:Person) WHERE a.name = alias.known_as MERGE (p)-[:KNOWN_AS]->(a) RETURN *

LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/presence.csv" AS link MATCH (owner:Person) WHERE owner.name = link.owner MATCH (thing:URL) WHERE thing.url = link.owns MERGE (owner)-[:OWNS]->(thing) RETURN *;

LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/presence.csv" AS link MATCH (owner:Person) WHERE owner.name = link.owner MATCH (thing:Twitter) WHERE thing.handle = link.owns MERGE (owner)-[:OWNS]->(thing) RETURN *;



MATCH (n:Place) DETACH DELETE n
LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/places.csv" AS row CREATE (n:Place) SET n = row RETURN *

LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/goes_to.csv" AS link MATCH (person:Person) WHERE person.name = link.person MATCH (place:Place) WHERE place.name = link.place MERGE (person)-[:GOES_TO]->(place) RETURN *;



MATCH (n:Group) DETACH DELETE n
LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/socials.csv" AS row CREATE (n:Group) SET n = row RETURN *

LOAD CSV WITH HEADERS FROM "https://furinkan.meidokon.net/2018-01-25_neo4j/member_of.csv" AS social MATCH (person:Person) WHERE person.name = social.person MATCH (group:Group) WHERE group.name = social.group MERGE (person)-[:MEMBER_OF]->(group) RETURN *;

MeidokonWiki: furinkan/sysadmin/CypherGraphDatabase (last edited 2019-11-20 14:02:07 by furinkan)