运行多个语句
apoc.cypher.runMany(statement STRING, params MAP<STRING, ANY>, config MAP<STRING, ANY>)
- 运行每个以分号分隔的语句,并返回语句结果的摘要。
目前没有模式操作。
此过程对于执行多个 Cypher 语句非常有用。我们可以通过运行以下查询,在一个语句中创建节点,并在另一个语句中创建指向自身的引用关系
CALL apoc.cypher.runMany(
'CREATE (n:Node {name:$name});
MATCH (n {name:$name})
CREATE (n)-[:X {name:$name2}]->(n);',
{name:"John", name2:"Doe"}
);
行 | 结果 |
---|---|
-1 |
{constraintsRemoved: 0, indexesRemoved: 0, nodesCreated: 1, rows: 0, propertiesSet: 1, labelsRemoved: 0, relationshipsDeleted: 0, constraintsAdded: 0, nodesDeleted: 0, indexesAdded: 0, labelsAdded: 1, relationshipsCreated: 0, time: 0} |
-1 |
{constraintsRemoved: 0, indexesRemoved: 0, nodesCreated: 0, rows: 0, propertiesSet: 1, labelsRemoved: 0, relationshipsDeleted: 0, constraintsAdded: 0, nodesDeleted: 0, indexesAdded: 0, labelsAdded: 0, relationshipsCreated: 1, time: 0} |
如果我们不想查看每个 Cypher 语句的统计信息,可以设置 statistics: false
CALL apoc.cypher.runMany(
'CREATE (n:Node {name:$name});
MATCH (n {name:$name})
CREATE (n)-[:X {name:$name2}]->(n);',
{name:"John", name2:"Doe"},
{statistics: false}
);
行 | 结果 |
---|