对相同节点类型在Import上使用多个With子句和Where子句

Question

有没有如下所示使用多个where子句的方法？目前，它将运行和处理第一组合并子句后的第一组合并子句，但第二和第三合并组之后的另一组合并子句不运行。我想是因为第一个WITH子句有一个下面的WITH子句，它过滤掉了第二个和第三个带有子句请求的内容？有谁知道如何在一份声明中一刀切地运行这一切？我是通过凯特尔进行的，为了我的目的，它必须在一个单一的声明中。

LOAD CSV WITH HEADERS FROM 'file:///detail.csv' AS row
MERGE   (gpath:GranPath {circPathInstID:row.CircPathInstID})
    ON CREATE SET
        gpath.circPathHumID = row.CircPathHumID,
        gpath.category = row.Type,
    ON MATCH SET
        gpath.circPathHumID = row.CircPathHumID,
        gpath.category = row.Type,
WITH row, gpath
WHERE NOT gpath.category IN ['ETHERNET','PRI TRUNKS','CUSTOMER SIP TRUNKS','ETHERNET TRANSPORT', 'EPON ETHERNET TRANSPORT']
MERGE   (upath:UnmNonEthPath {name:row.CircPathHumID, status:row.CurrentPending})
MERGE   (upath)-[:DATA_SOURCE {source:"GRANITE"}]->(gpath)
WITH row, gpath
WHERE gpath.category IN ['ETHERNET','PRI TRUNKS','CUSTOMER SIP TRUNKS']
MERGE   (usvc:UnmService {name:row.CircPathHumID, status:row.CurrentPending})
MERGE   (usvc)-[:DATA_SOURCE {source:"GRANITE"}]->(gpath)
WITH row, gpath
WHERE gpath.category IN ['ETHERNET TRANSPORT', 'EPON ETHERNET TRANSPORT']
MERGE   (uxp:UnmTransport {name:row.CircPathHumID, status:row.CurrentPending})
MERGE   (uxp)-[:DATA_SOURCE {source:"GRANITE"}]->(gpath)

Answer 1

如果第三个WITH子句之前的所有内容都如预期的那样工作，那么失败的必须是第三个WITH子句之后的WHERE子句。

实际上，由于您的第二个WHERE子句如下(请注意NOT)：

WHERE NOT gpath.category IN [
  'ETHERNET','PRI TRUNKS','CUSTOMER SIP TRUNKS',
  'ETHERNET TRANSPORT','EPON ETHERNET TRANSPORT']

你的第三个是：

WHERE gpath.category IN [
  'ETHERNET','PRI TRUNKS','CUSTOMER SIP TRUNKS']

第三条WHERE条款是不可能成功的。

如果您试图有条件地执行操作，则应查看条件Cypher执行的APOC过程。在您的示例中，由于您有3个条件并希望写入DB，所以应该考虑使用apoc.do.case。

例如：

LOAD CSV WITH HEADERS FROM 'file:///detail.csv' AS row
MERGE (gpath:GranPath {circPathInstID:row.CircPathInstID})
SET
  gpath.circPathHumID = row.CircPathHumID,
  gpath.category = row.Type
WITH row, gpath
CALL apoc.do.case(
  [
    gpath.category IN ['ETHERNET','PRI TRUNKS','CUSTOMER SIP TRUNKS'],
      'MERGE (usvc:UnmService {name:row.CircPathHumID, status:row.CurrentPending})
       MERGE (usvc)-[:DATA_SOURCE {source:"GRANITE"}]->(gpath)',
    gpath.category IN ['ETHERNET TRANSPORT', 'EPON ETHERNET TRANSPORT'],
      'MERGE (uxp:UnmTransport {name:row.CircPathHumID, status:row.CurrentPending})
       MERGE (uxp)-[:DATA_SOURCE {source:"GRANITE"}]->(gpath)'
  ],
  'MERGE (upath:UnmNonEthPath {name:row.CircPathHumID, status:row.CurrentPending})
   MERGE (upath)-[:DATA_SOURCE {source:"GRANITE"}]->(gpath)',
  {row: row, gpath: gpath})
YIELD value
RETURN gpath