给定下图:
定义:
图表示例:
-CompanyB持有companyC的0.5-CompanyA持有0.5 companyB的。两家公司均被视为companyC的受益人(分别直接持有0.5和间接持有0.25)
创建示例:
// create an empty graph
graph = TinkerFactory.createModern()
g = graph.traversal()
g.V().drop()
// create data
companyA = g.addV('Company').property('name', 'A').next()
companyB= g.addV('Company').property('name', 'B').next()
companyC = g.addV('Company').property('name', 'C').next()
g.addE("Shareholder").from(companyB)
.to(companyC).property("holding",0.5)
g.addE("Shareholder").from(companyA)
.to(companyB).property("holding", 0.5)
所需解决方案:
解决方案示例:
[{
name:"B",
holding:0.5,
shareholders:[
{
name:"A",
holding:0.25
}
]}
]
}]
我的尝试:
// js
let companyCBeneficiaries =await g.V(companyC.id)
.inE()
.project(
"holding",
"name",
"shareholders"
)
.by(__.identity().values("holding"))
.by(__.coalesce(__.outV().values("name") , __.constant("")))
.by(
__.coalesce(
__.outV().inE().project(
"name",
"holding"
)
.by(__.coalesce(__.outV().values("name") , __.constant("")))
.by(__.identity().values("holding"))
,
__.constant([])
)
)
.toList()
// console
g.V(companyC).inE().project("holding","name","shareholders")
.by(__.identity().values("holding"))
.by(__.coalesce(__.outV().values("name") ,__.constant("")))
.by(__.coalesce(__.outV().inE().project("name","holding")
.by(__.coalesce(__.outV().values("name") ,
__.constant("")))
.by(__.identity().values("holding"))
,__.constant([]))).toList()
结果是CompanyA.holding = 0.5而不是0.25(当前遍历companyCBeneficiaries来固定持有财产)
我使你的示例数据更加健壮:
g = TinkerGraph.open().traversal()
companyA = g.addV('Company').property('name', 'A').next()
companyB = g.addV('Company').property('name', 'B').next()
companyC = g.addV('Company').property('name', 'C').next()
companyD = g.addV('Company').property('name', 'D').next()
companyE = g.addV('Company').property('name', 'E').next()
g.addE("Shareholder").from(companyB).to(companyC).property("holding",0.5)
g.addE("Shareholder").from(companyA).to(companyB).property("holding", 0.5)
g.addE("Shareholder").from(companyD).to(companyC).property("holding", 0.5)
g.addE("Shareholder").from(companyE).to(companyB).property("holding", 0.5)
并使用sack()
了我认为可以为你带来的帮助:
gremlin> g.V().has('Company','name','C').
......1> inE('Shareholder').
......2> sack(assign).by('holding').
......3> project('name','holding','shareholders').
......4> by(outV().values('name')).
......5> by(sack()).
......6> by(outV().
......7> inE('Shareholder').
......8> sack(mult).by('holding').
......9> project('name','holding').
.....10> by(outV().values('name')).
.....11> by(sack()).
.....12> fold())
==>[name:B,holding:0.5,shareholders:[[name:A,holding:0.25],[name:E,holding:0.25]]]
==>[name:D,holding:0.5,shareholders:[]]