Parsing yml file Convert Map

cause

There is a requirement to parse a yml file into HashMap format data, the file content is as follows

spring:
  datasource:
    serviceDB:
      jdbc-url: jdbc:mysql://127.0.0.1:3306/serviceDB
      password: test
      minimum-idle: 1
      idle-timeout: 60000
      maximum-pool-size: 150
      username: root
    cluster:
       - key: bi
         jdbc-url: jdbc:mysql://127.0.0.1:3306/test
         password: test
         minimum-idle: 1
         idle-timeout: 60000
         maximum-pool-size: 150
         username: root
       - key: his
         jdbc-url: jdbc:mysql://127.0.0.1:3306/his
         password: test
         minimum-idle: 1
         idle-timeout: 60000
         maximum-pool-size: 150
         username: root
 
config:
  schedul:
    onOff: false
  orderGen:
     masterWorkerId: 1
     backupWorkerId: 2

The result obtained by the analysis is as follows:

{
  "-url": "jdbc:mysql://127.0.0.1:3306/serviceDB",
  "": "test",
  "": "root",
  "[0].key": "bi",
  "[1].maximum-pool-size": "150",
  "": "false",
  "[0].password": "test",
  "[0].maximum-pool-size": "150",
  "[1].username": "root",
  "-timeout": "60000",
  "": "2",
  "[1].idle-timeout": "60000",
  "-idle": "1",
  "[0].username": "root",
  "[1].key": "his",
  "": "1",
  "[0].minimum-idle": "1",
  "[0].idle-timeout": "60000",
  "[1].password": "test",
  "[0].jdbc-url": "jdbc:mysql://127.0.0.1:3306/test",
  "-pool-size": "150",
  "[1].minimum-idle": "1",
  "[1].jdbc-url": "jdbc:mysql://127.0.0.1:3306/his"
}

Implementation ideas

Step 1: Use yml to read the file

Yaml yaml = new Yaml();
Map<String, Object> testMap =  
        ( new BufferedReader(new FileReader("")));
       

But the testMap we get at this time is not the result we want. The content of the testMap is as follows:

{"spring":{"datasource":{"serviceDB":{"jdbc-url":"jdbc:mysql://127.0.0.1:3306/serviceDB","password":"test","minimum-idle":1,"idle-timeout":60000,"maximum-pool-size":150,"username":"root"},"cluster":[{"key":"bi","jdbc-url":"jdbc:mysql://127.0.0.1:3306/test","password":"test","minimum-idle":1,"idle-timeout":60000,"maximum-pool-size":150,"username":"root"},{"key":"his","jdbc-url":"jdbc:mysql://127.0.0.1:3306/his","password":"test","minimum-idle":1,"idle-timeout":60000,"maximum-pool-size":150,"username":"root"}]}},"config":{"schedul":{"onOff":false},"orderGen":{"masterWorkerId":1,"backupWorkerId":2}}}

Step 2: After obtaining the testMap, further analysis is required to obtain the required results. At this time, recursive parsing is required. It should be noted that the analysis of arrays in yml should be processed.

The core code is as follows:

/**
      *
      * @Title: json2propMap
      * @Description: parse json conversion map
      * @param jsonObject
      * @return
      * @throws
      *
      */
     public static Map<String, Object> json2propMap(JSONObject jsonObject){
         String tmpKey = "";
         String tmpKeyPre = "";
         Map<String, Object> configMap = new HashMap<String, Object>();
         json2prop(jsonObject, tmpKey, tmpKeyPre, configMap);
         return configMap;
     }
    
     /**
      *
      * @Title: json2prop
      * @Description: Recursive parsing
      * @param jsonObject
      * @param tmpKey
      * @param tmpKeyPre
      * @param configMap
      * @throws
      *
      */
     private static void json2prop(JSONObject jsonObject, String tmpKey, String tmpKeyPre, Map<String, Object> configMap) {
         Iterator<String> iterator = ().iterator();
         while (()) {
             // Get key
             String key = ();
             String value = (key);
             Object valueObject = null;
             try {
                 valueObject = (value);
             } catch (Exception e) {
                 // If the parsing error occurs, it means that it is over. Put the map and continue to parse.
                 (tmpKey + key, value);
                 continue;
             }
             // If it is a collection, special parsing is required
             if (valueObject instanceof Collection<?>) {
                 List<?> list = (List<?>)valueObject;
                 tmpKeyPre = tmpKey;
 // tmpKey += key;
                 for (int i = 0; i < (); i++) {
                     String itemKey = tmpKey + key + "["+i+"]" + ".";
                     JSONObject itemValue = (JSONObject)(i);
                     json2prop(itemValue, itemKey, tmpKeyPre, configMap);
                 }
             } else if (valueObject instance of JSONObject) {
                 JSONObject jsonStr = (value);
                 tmpKeyPre = tmpKey;
                 tmpKey += key + ".";
                 json2prop(jsonStr, tmpKey, tmpKeyPre, configMap);
                 tmpKey = tmpKeyPre;
             } else {
                 (tmpKey + key, value);
                 continue;
             }
         }
     }

Step 3: Get the final result, the ultimate code is as follows:

public static void main(String[] args) throws FileNotFoundException {
         Yaml yaml = new Yaml();
         Map<String, Object> testMap = ( new BufferedReader(new FileReader("")));
         ((testMap));
         JSONObject jsonObject = ((testMap));
         // Recursively parse Map
         testMap = JsonUtil.json2propMap(jsonObject);
         ((testMap));
     }