这个cypher 为啥 运行 报错
发布于 24 天前 作者 wangxin888 193 次浏览 来自 问答

UNWIND {[{“nodeId”:“ec4ce2ce-2626-11ea-ad00-0242ac1e4105”}]} AS nodeMap MATCH (n) WHERE n.id = nodeMap.nodeId SET n.knwlgId= ‘1912271750370000181’, n.knwlgName= ‘星期五02’ return n

7 回复

你把报错信息,贴上来啊

试试修改成这样

UNWIND [{nodeId:“ec4ce2ce-2626-11ea-ad00-0242ac1e4105”}] AS nodeMap MATCH (n) WHERE n.id = nodeMap.nodeId SET n.knwlgId= “1912271750370000181”, n.knwlgName= “星期五02” return n

@crazyyanchao 这个数据格式怎么整的,有没有专门的转化方式,一般的map过来的都有引号的,

@wangxin888


如果是想在程序里把map数组转string,然后拼在UNWIND 里面的话,我这样尝试了一下,可以用,虽然比较粗糙

//大概意思就是 遍历map数组的key,替换掉字符串
//例如{"nodeId":"ec4ce2ce-2626-11ea-ad00-0242ac1e4105"} -> {nodeId:"ec4ce2ce-2626-11ea-ad00-0242ac1e4105"}
func ReplaceKeyMap(targetString string) string {
	fieldNameMap := TestStruct(Article{})
	if fieldNameMap == nil {
		fmt.Println("空结构体,无数据替换")
		return ""
	}
	for _, entity := range fieldNameMap {
		targetString = strings.Replace(targetString, "\""+entity+"\"", entity, -1)
	}
	return targetString
}

尝试用JAVA 写了一下

   public static void ReplaceKeyMap() {
   		//生成测试数据
        ArrayList<HashMap<String, String>> mapList = new ArrayList<HashMap<String, String>>();
        for (int i = 0; i < 5; i++) {
            HashMap<String, String> nodeMap = new HashMap<String, String>();
            nodeMap.put("nodeId", "ec4ce2ce-2626-11ea-" + i);
            mapList.add(nodeMap);
        }
        String mapString = JsonUtil.toJsonString(mapList);
        System.out.println(mapString);
        Map<String, String> nodeMap = new HashMap<String, String>();
        nodeMap.put("nodeId", "ec4ce2ce-2626-11ea");
		
		//核心地方
        for (Map.Entry<String, String> stringStringEntry : nodeMap.entrySet()) {
            mapString = mapString != null ? mapString.replaceAll("\"" + stringStringEntry.getKey()
                    + "\"", stringStringEntry.getKey()) : "";
        }
        System.out.println(mapString);
    }
	
[{"nodeId":"ec4ce2ce-2626-11ea-0"},{"nodeId":"ec4ce2ce-2626-11ea-1"},{"nodeId":"ec4ce2ce-2626-11ea-2"},{"nodeId":"ec4ce2ce-2626-11ea-3"}]
[{nodeId:"ec4ce2ce-2626-11ea-0"},{nodeId:"ec4ce2ce-2626-11ea-1"},{nodeId:"ec4ce2ce-2626-11ea-2"},{nodeId:"ec4ce2ce-2626-11ea-3"}]

@lisabiya


自我推翻 发现 apoc 有json转map对象

apoc 3.5
//apoc.convert.fromJsonList   转jsonArray
with apoc.convert.fromJsonList('[{"nodeId":"ec4ce2ce-2626-11ea-ad00-0242ac1e4105"}]')  as value
return value[0].nodeId

//apoc.convert.fromJsonMap	转jsonObject
with apoc.convert.fromJsonMap('{"nodeId":"ec4ce2ce-2626-11ea-ad00-0242ac1e4105"}')  as value
return value.nodeId

谢谢分享!

官网上好像只支持key没有双引号这种 企业微信截图_15794270899672.png @lisabiya 这种是可以的。感谢分享

回到顶部