import.cypher

LOAD CSV FROM "https://gist.githubusercontent.com/jimmycrequer/44b00d26ed1ec69c24c5107146de56c8/raw/a7ce1c5f4424f79299ceae5f6dc8110a348cf4de/worlds2019-picksbans.csv" AS row
MERGE (blue:Team {name: row[0]})
MERGE (red:Team {name: row[1]})

MERGE (bb1:Champion {name: row[2]})
CREATE (blue)-[:BANNED]->(bb1)
MERGE (bb2:Champion {name: row[3]})
CREATE (blue)-[:BANNED]->(bb2)
MERGE (bb3:Champion {name: row[4]})
CREATE (blue)-[:BANNED]->(bb3)
MERGE (bb4:Champion {name: row[5]})
CREATE (blue)-[:BANNED]->(bb4)
MERGE (bb5:Champion {name: row[6]})
CREATE (blue)-[:BANNED]->(bb5)

MERGE (rb1:Champion {name: row[7]})
CREATE (red)-[:BANNED]->(rb1)
MERGE (rb2:Champion {name: row[8]})
CREATE (red)-[:BANNED]->(rb2)
MERGE (rb3:Champion {name: row[9]})
CREATE (red)-[:BANNED]->(rb3)
MERGE (rb4:Champion {name: row[10]})
CREATE (red)-[:BANNED]->(rb4)
MERGE (rb5:Champion {name: row[11]})
CREATE (red)-[:BANNED]->(rb5)

MERGE (bp1:Champion {name: row[12]})
CREATE (blue)-[:PICKED {role: "Top Lane"}]->(bp1)
MERGE (bp2:Champion {name: row[13]})
CREATE (blue)-[:PICKED {role: "Jungle"}]->(bp2)
MERGE (bp3:Champion {name: row[14]})
CREATE (blue)-[:PICKED {role: "Mid Lane"}]->(bp3)
MERGE (bp4:Champion {name: row[15]})
CREATE (blue)-[:PICKED {role: "Bot Lane"}]->(bp4)
MERGE (bp5:Champion {name: row[16]})
CREATE (blue)-[:PICKED {role: "Support"}]->(bp5)

MERGE (rp1:Champion {name: row[17]})
CREATE (red)-[:PICKED {role: "Top Lane"}]->(rp1)
MERGE (rp2:Champion {name: row[18]})
CREATE (red)-[:PICKED {role: "Jungle"}]->(rp2)
MERGE (rp3:Champion {name: row[19]})
CREATE (red)-[:PICKED {role: "Mid Lane"}]->(rp3)
MERGE (rp4:Champion {name: row[20]})
CREATE (red)-[:PICKED {role: "Bot Lane"}]->(rp4)
MERGE (rp5:Champion {name: row[21]})
CREATE (red)-[:PICKED {role: "Support"}]->(rp5)

worlds2019-picksbans.csv