hi michael , thanks !, will try it the other way around ..
reg Koen
2016-08-22 16:45 GMT+02:00 'Michael Hunger' via Neo4j <
neo4j@googlegroups.com>:
> In general clauses are not supported within CASE only expressions.
>
> Fortunately you can rewrite your query
>
> USING PERIODIC COMMIT
> LOAD CSV WITH HEADERS
> FROM "file:///incident.csv" AS line
> MERGE (incident:Incident { id: TOINT(line.incidentId) })
> SET incident.session = line.session, incident.allegation = line.allegation
> SET incident.involving = line.`incident involving`, incident.outcome =
> line.outcome
> SET incident.reason = line.reason, incident.notes = line.notes
> WITH line,incident
> MATCH (session:Session)-->(grandprix:GrandPrix {id: TOINT(line.raceId)})
> WHERE incident.session IN labels(session)
> MERGE (incident)-[:SESSION]->(session)
>
> On 8/22/16, koen <kdwykleing...@gmail.com> wrote:
> > Hi, i have created a neo4j graph database with formula 1 data based on
> data
> >
> > found on ergast.com developer api.
> > All well sofar. Now i want to use a multi line case kind of statement in
> > cypher in order to do a match based on the content of a field in the
> input
> > file but i cannot make the case statement to work.. the syntax is not
> > correct as i get en error on the case statement .. most of the code
> works
> > but what would be the valid approach to create such a case statement in
> > cypher ... ?
> >
> > My cypher code looks like
> >
> > USING PERIODIC COMMIT
> > LOAD CSV WITH HEADERS
> > FROM "file:///incident.csv" AS line
> > MERGE (incident:Incident { id: TOINT(line.incidentId) })
> > SET incident.session = line.session, incident.allegation =
> line.allegation
> > SET incident.involving = line.`incident involving`, incident.outcome =
> > line.outcome
> > SET incident.reason = line.reason, incident.notes = line.notes
> > WITH line,incident
> > CASE incident.session
> > WHEN "R" THEN MATCH (session:Session:R)-->(grandprix:GrandPrix {id:
> > TOINT(line.raceId)})
> > WHEN "Q1" THEN MATCH (session:Session:Q1)-->(grandprix:GrandPrix
> {id:
> > TOINT(line.raceId)})
> > WHEN "Q2" THEN MATCH (session:Session:Q2)-->(grandprix:GrandPrix
> {id:
> > TOINT(line.raceId)})
> > WHEN "Q3" THEN MATCH (session:Session:Q3)-->(grandprix:GrandPrix
> {id:
> > TOINT(line.raceId)})
> > WHEN "P1" THEN MATCH (session:Session:P1-->(grandprix:GrandPrix {id:
> > TOINT(line.raceId)})
> > WHEN "P2" THEN MATCH (session:Session:P2)-->(grandprix:GrandPrix
> {id:
> > TOINT(line.raceId)})
> > WHEN "P3" THEN MATCH (session:Session:P3)-->(grandprix:GrandPrix
> {id:
> > TOINT(line.raceId)})
> > END
> > MERGE (incident)-[:SESSION]->(session)
> >
> >
> > thanks koen
> >
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Neo4j" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to neo4j+unsubscr...@googlegroups.com.
> > For more options, visit https://groups.google.com/d/optout.
> >
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Groeten / Best Regards,
Koen
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
