java - 如何按值对 json 进行排序以查看真实的 DIFF

Question

我尝试制作一个不查看我的 JSON 值顺序的 DIFF。我尝试在使用 import com.fasterxml.jackson.databind.ObjectMapper 区分它之前对我的 json 进行排序，但 SerializationFeature.ORDER_MAP_ENTRIES_BY_KEYS 或 MapperFeature.SORT_PROPERTIES_ALPHABETICALLY 都没有按照我的意愿对其进行排序。有人知道另一种按字母值（NB_SUP_HET、NB_SUP_SOL、WEI_MAX）对我的 json 进行排序的方法吗？

import test.common.JsonDiff
import com.fasterxml.jackson.databind.SerializationFeature
import com.fasterxml.jackson.databind.MapperFeature
import javax.json.Json
import com.fasterxml.jackson.databind.ObjectMapper

String template = """    
    {"preparation_order_list" : [ {
      "net_weight_to_prepare" : 12.33,
      "additional_data_value_list" : [ {
        "additional_data_item_code" : "NB_SUP_HET",
        "additional_data_item_value" : "001821"
      }, {
        "additional_data_item_code" : "NB_SUP_SOL",
        "additional_data_item_value" : "002000"
      }, {
        "additional_data_item_code" : "WEI_MAX",
        "additional_data_item_value" : "000007358"
      } ]
    }]}
"""     
    
    String file_to_compare = """
    {"preparation_order_list" : [ {
      "net_weight_to_prepare" : 12.33,
      "additional_data_value_list" : [ {
        "additional_data_item_code" : "WEI_MAX",
        "additional_data_item_value" : "000007358"
      }, {
        "additional_data_item_code" : "NB_SUP_SOL",
        "additional_data_item_value" : "002000"
      }, {
        "additional_data_item_code" : "NB_SUP_HET",
        "additional_data_item_value" : "001821"
      } ]
    }]}
"""     
    
    
    ObjectMapper mapper = new ObjectMapper();
    mapper.configure(SerializationFeature.ORDER_MAP_ENTRIES_BY_KEYS, true);
    mapper.configure(MapperFeature.SORT_PROPERTIES_ALPHABETICALLY, true)
    String prettyApiJson = mapper.writerWithDefaultPrettyPrinter().writeValueAsString(mapper.readTree(file_to_compare));

    String prettyTemplateJson = mapper.writerWithDefaultPrettyPrinter().writeValueAsString(mapper.readTree(template));
    println "------------------------------------------"
    println "prettyApiJson :\n$prettyApiJson"
    
    String diff_string = test.common.JsonDiff.GetJsonDiff(prettyApiJson,prettyTemplateJson)
    
    JsonStructure jsonStructInput = Json.createReader(new StringReader(prettyApiJson)).read()
    JsonStructure jsonStructTemplate = Json.createReader(new StringReader(prettyTemplateJson)).read()
    JsonPatch diff = Json.createDiff(jsonStructTemplate, jsonStructInput)
    println diff.toString()
    ```

标签： javajsonfasterxml

Answer 1

有关信息，我终于成功地按字母顺序按“additional_data_item_code”值对“additional_data_value_list”进行了排序

这是带有这些奇怪的闭包函数的递归函数:)：

import test.common.JsonDiff
import com.fasterxml.jackson.databind.SerializationFeature
import com.fasterxml.jackson.databind.MapperFeature
import javax.json.Json
import com.fasterxml.jackson.databind.ObjectMapper
import org.apache.commons.lang3.builder.ToStringBuilder
import groovy.json.JsonSlurper
import groovy.json.JsonOutput
import groovy.json.JsonBuilder

// inspired from https://stackoverflow.com/questions/39973481/recursively-removing-whitespace-from-json-field-names-in-groovy

def jsonString = """
    {"items" : [ {
      "net_weight_to_prepare" : 12.33,
      "additional_data_value_list" : [ {
        "additional_data_item_code" : "WEI_MAX",
        "additional_data_item_value" : "000007358"
      }, {
        "additional_data_item_code" : "NB_SUP_SOL",
        "additional_data_item_value" : "002000"
      }, {
        "additional_data_item_code" : "NB_SUP_HET",
        "additional_data_item_value" : "001821"
      } ]
    }]}
"""     


def json = """
{
    "leg bone" : false,
    "connected to  the" : {
        "arm bones " : [
            {
                " fizz" : "buzz",
                "well hello" : "there"
            }
        ]
    }
}
"""

def sortNodesInTree(def tree, String nodeName ) {
    println "tree1 : "+tree
    //println "tree1.key : "+tree.key
    switch (tree) {
        case Map:
            return tree.collectEntries { k, v -> 
                println "k v  : $k $v"
                if (k==nodeName) {[(k):v.sort { a,b -> a.additional_data_item_code <=> b.additional_data_item_code}]}
                else {
                [(k):sortNodesInTree(v,nodeName)]
                }
            }
        case Collection:
        println "tree2 : "+tree
                return tree.collect { e -> sortNodesInTree(e,nodeName) }
        default :
            return tree
    }
}


def tree = new JsonSlurper().parseText(jsonString)
def fixedTree = sortNodesInTree(tree,"additional_data_value_list")
println new JsonBuilder(fixedTree).toString()

安慰 ：

println(JsonBuilder(fixedTree).toString())

{"items":[{"net_weight_to_prepare":12.33,"additional_data_value_list":[{"additional_data_item_code":"NB_SUP_HET","additional_data_item_value":"001821"},{"additional_data_item_code":"NB_SUP_SOL","additional_data_item_value":"002000"},{"additional_data_item_code":"WEI_MAX","additional_data_item_value":"000007358"}]}]}