Em quarta-feira, 9 de abril de 2014 08h39min08s UTC-3, Nicola Viragine
escreveu:
>
> how to write orientdbSQL query equivalent to the cypher query bellow?
>
> "START me=node:users_index(name={user})
> MATCH
> skills<-[:has]-me-[:lives_in]->city<-[:in_location]-job-[:requires]->requirements
> WHERE me-[:has]->()<-[:requires]-job"
>
> where I have the following vertices and edges:
>
> Vertex vertex = graph.addVertex("class:Users", "name", name);
> Vertex vertex = graph.addVertex("class:Skills", "name", name);
> Vertex vertex = graph.addVertex("class:Jobs", "name", name);
> Vertex vertex = graph.addVertex("class:Cities", "name", name);
>
> graph.addEdge(null, user, v, "lives_in"); in city
> graph.addEdge(null, user, v, "has"); has skills
> graph.addEdge(null, jobs, v, "in_location"); in city
> graph.addEdge(null, jobs, v, "requires"); skills
>
> I want to know all the matches between jobs and users, that is : all
> users and jobs that matches city an skill
>
something like:
select u from users j from jobs where u.out('has) = j.out('requires') and
u.out('lives_in') = j.out('in_location')
> thanks
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
