Hi, I have a module dependency list saved in a graph, along with all the projects the modules belong to: (module 1)-[USES]-(module 2) and (module 1)-[BELONGS_TO]-(project 1). I would like to create edges between modules and the projects they depend on: (module 1)-[RELIES_ON]-(project 2). In OrientDB SQL I can get a list of the modules and projects that I need to pair up with the following query:
select @rid as module_rid, out('USES').out('BELONGS_TO').@rid as
project_rid from modules
This gives me a list with module rids on the left and collections of
project rids on the right:
#12:0
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:0>
[]#12:1
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:1>
[]#12:2
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:2>
[]#12:3
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:3>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
..More(49)
#12:4
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:4>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
#11:48677
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:48677>
..More(49)
#12:5
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:5>
#11:2526
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:2526>
#11:2526
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:2526>
#11:2526
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:2526>
#11:47148
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:47148>
#11:47148
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:47148>
#11:25338
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/11:25338>
..More(30)
#12:6
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:6>
[]#12:7
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:7>
[]#12:8
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:8>
[]#12:9
<http://lnx.ddns.net:2480/studio/index.html#/database/gems/browse/edit/12:9>
[]
1) How can I eliminate rows with empty collections on the right?
2) How can I make sure the values on the right hand side collection (the
contents of project collections returned) are distinct. Bear in mind that
each module can use more than a single module from each project.
2) How can I transform the list into a list of module/project pairs
(expanding project collections on the right, keeping modules on the left)?
3) How can I instruct OrientDB to create [RELIES_ON] edges between these
module/project pairs?
Thanks in advance! - A budding OrientDB fan
--
---
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.
