go語言搬磚之go jmespath實現查詢json數據

package main
import (
   "encoding/json"
   "fmt"
   "github.com/jmespath/go-jmespath"
)
func main() {
   //基本查詢
   var jsonData = []byte(`{"foo": {"bar": {"baz":[0,1,2,3,4]}}}`)
   var data interface{}
   err := json.Unmarshal(jsonData, &data)
   if err != nil {
      fmt.Println(err)
   }
   re1, _ := jmespath.Search("foo.bar", data)
   fmt.Println("data查詢結果: ", re1)
   re2, _ := jmespath.Search("foo.bar.baz[2]", data)
   fmt.Println("data查詢結果: ", re2)
   //通配符查詢
   var jsonData2 = []byte(`{"foo": [{"first": "a", "last": "b"},
                           {"first": "c", "last": "d"}]}`)
   var data2 interface{}
   _ = json.Unmarshal(jsonData2, &data2)
   re3, _ := jmespath.Search("foo[*].first", data2)
   fmt.Println("data2查詢結果: ", re3)
   re4, _ := jmespath.Search("foo[:1].first", data2)
   fmt.Println("data2查詢結果: ", re4)
   //運算符查詢
   var jsonData3 = []byte(`{"foo": [{"age": 20}, {"age": 25},
                           {"age": 30}, {"age": 35},
                           {"age": 40}]}`)
   var data3 interface{}
   _ = json.Unmarshal(jsonData3, &data3)
   re5, _ := jmespath.Search("foo[?age > `30`]", data3)
   fmt.Println("data3查詢結果: ", re5)
   //過濾查詢
   var jsonData4 = []byte(`{
    "machines": [
        {"name": "a", "state": "running"},
        {"name": "b", "state": "stopped"},
        {"name": "b", "state": "running"}]
    }`)
   var data4 interface{}
   _ = json.Unmarshal(jsonData4, &data4)
   re6, _ := jmespath.Search("machines[?state=='running'].name", data4)
   fmt.Println("data4查詢結果: ", re6)
   //管道查詢
   var jsonData5 = []byte(`{
    "people": [
        {"first": "James", "last": "d"},
        {"first": "Jacob", "last": "e"},
        {"first": "Jayden", "last": "f"},
        {"missing": "different"}
     ],
     "foo": {"bar": "baz"}
    }`)
   var data5 interface{}
   _ = json.Unmarshal(jsonData5, &data5)
   re7, _ := jmespath.Search("people[*].first | [0]", data5)
   fmt.Println("data5查詢結果: ", re7)
   //多選查詢並帶自定義名稱
   var jsonData6 = []byte(`{
    "people": [
    {
      "name": "a",
      "state": {"name": "up"}
    },
    {
      "name": "b",
      "state": {"name": "down"}
    },
    {
      "name": "c",
      "state": {"name": "up"}
    }
    ]
    }`)
   var data6 interface{}
   _ = json.Unmarshal(jsonData6, &data6)
   re8, _ := jmespath.Search("people[].{Name: name, State: state.name}", data6)
   fmt.Println("data6查詢結果: ", re8)
   //函數
   var jsonData7 = []byte(`{
    "people": [
    {
      "name": "b",
      "age": 30,
      "state": {"name": "up"}
    },
    {
      "name": "a",
      "age": 50,
      "state": {"name": "down"}
    },
    {
      "name": "c",
      "age": 40,
      "state": {"name": "up"}
    }
    ]
    }`)
   var data7 interface{}
   _ = json.Unmarshal(jsonData7, &data7)
   re9, _ := jmespath.Search("length(people)", data7)
   fmt.Println("data7查詢結果: ", re9)
   re10, _ := jmespath.Search("max_by(people, &age).name", data7)
   fmt.Println("data7查詢結果: ", re10)
}