ModelTraining

MERGE (person:Person{name:"Alistair"})
MERGE (role:Role{name:"Software Engineer"})
MERGE (company:Company{name:"Neo Technology"})
CREATE (empl:Employment{from: 2011})

MERGE (person)-[:CURRENT]->(empl)
MERGE (empl)-[:WORKS_AT]->(company)
MERGE (empl)-[:ROLE]->(role)

// Determine whether first story already exists
WITH empl, person, 
     CASE WHEN ((person)-[:FIRST]->()) THEN [] ELSE ["blalba"]
     END 
  AS firstNotExists

// Create FIRST rel newStory is first story
FOREACH (i IN firstNotExists | MERGE (person)-[:FIRST]->(empl))
WITH empl, person

// Delete old LAST relationship
MATCH (empl)<-[:CURRENT]-(person)-[oldCurrent:CURRENT]->(oldEmployment)
DELETE oldCurrent
MERGE (oldEmployment)-[:NEXT]->(empl)
SET oldEmployment.to = empl.from;