1 回答
TA贡献1982条经验 获得超2个赞
Py2neo 支持进行 Cypher 查询,这里有一个很好的 hello-world 教程,介绍如何做到这一点。
因此,我将提供一个带注释的 Cypher 查询,希望对您有用。
但首先,请注意几点:
您不应该为服务于相同目的的关系提供几乎无限数量的类型(如“0.2”、“0.5”等),因为当您想要按类型搜索特定关系时,这是非常无益的(这是其中之一你会想做的最常见的事情)并且会导致大量的关系类型。所以我在我的回答中假设利益关系实际上都有类型
TO
。我的查询使用一个临时
Temp
节点来存储查询的临时状态,因为它遍历随机路径中的关系。该Temp
节点将在查询结束时被删除。
查询如下:
// Get the (assumed-unique) starting Node `n`
MATCH (n:Node)
WHERE n.name = 'Node-1'
// Create (if necessary) the unique `Temp` node, and initialize
// it with the native ID of the starting node and an empty `pathRels` list
MERGE (temp:Temp)
SET temp = {id: ID(n), pathRels: []}
WITH temp
// apoc.periodic.commit() repeatedly executes the query passed to it
// until it returns 0 or NULL.
// The query passed here iteratively extends the list of relationships
// in `temp.pathRels`. In each iteration, if the current `temp.id`
// node has any outgoing `TO` relationships, the query:
// - appends to `temp.pathRels` a randomly-selected relationship, taking
// into account the relationship weights (which MUST sum to 1.0),
// - sets `temp.id` to the ID of the end node of that selected relationship,
// - and returns 1.
// But if the current `temp.id` node has no outgoing `TO` relationships, then
// the query returns 0.
CALL apoc.periodic.commit(
"
MATCH (a:Node)
WHERE ID(a) = $temp.id
WITH a, [(a)-[rel:TO]->() | rel] AS rels
LIMIT 1 // apoc.periodic.commit requires a LIMIT clause. `LIMIT 1` should be harmless here.
CALL apoc.do.when(
SIZE(rels) > 0,
'
WITH temp, a, REDUCE(s={x: rand()}, r IN rels | CASE
WHEN s.x IS NULL THEN s
WHEN s.x < r.weight THEN {x: NULL, pathRel: r}
ELSE {x: s.x - r.weight} END
).pathRel AS pathRel
SET temp.id = ID(ENDNODE(pathRel)), temp.pathRels = temp.pathRels + pathRel
RETURN 1 AS result
',
'
RETURN 0 AS result
',
{temp: $temp, a: a, rels: rels}
) YIELD value
RETURN value.result
",
{temp: temp}
) YIELD batchErrors
// Use the `temp.pathRels` list to generate the `weightedRandomPath`
// (or you could just return `pathRels` as-is).
// Then delete the `Temp` node, since it is no longer needed.
// Finally, return `weightedRandomPath`, and also the `batchErrors` returned by
// apoc.periodic.commit() (in case it had any errors).
WITH temp, apoc.path.create(STARTNODE(temp.pathRels[0]), temp.pathRels) AS weightedRandomPath, batchErrors
DELETE temp
RETURN weightedRandomPath, batchErrors
添加回答
举报