[golang]-golang获取多个json字符串中的指定key的值

た入场券 2022-12-08 04:55 489阅读 0赞

需求: 将一个字符串。它由多个json组成并以,分隔。想提取出各个json中指定的key，因为想通过gitlab api获取项目分支，而获取到的字符串就是这样的格式

测试的json 如下

> 前后带上\[\]也可以

{
        "store": {
            "book": [
                {
                    "category": "reference",
                    "author": "Nigel Rees",
                    "title": "Sayings of the Century",
                    "price": 8.95
                },
                {
                    "category": "fiction",
                    "author": "Evelyn Waugh",
                    "title": "Sword of Honour",
                    "price": 12.99
                },
                {
                    "category": "fiction",
                    "author": "Herman Melville",
                    "title": "Moby Dick",
                    "isbn": "0-553-21311-3",
                    "price": 8.99
                },
                {
                    "category": "fiction",
                    "author": "J. R. R. Tolkien",
                    "title": "The Lord of the Rings",
                    "isbn": "0-395-19395-8",
                    "price": 22.99
                }
            ],
            "bicycle": {
                "color": "red",
                "price": 19.95
            }
        },
        "expensive": 10
    }

主要代码

package api
    
    import (
    	"encoding/json"
    	"fmt"
    
    	"github.com/yalp/jsonpath"
    )
    
    type BranchController struct { 
    	BaseController
    }
    
    func (c *BranchController) GetBranch() { 
    
    	//1.准备一段json
    	raw := []byte(`[ { "category": "reference", "author": "Nigel Rees", "title": "Sayings of the Century", "price": 8.95 }, { "category": "fiction", "author": "Evelyn Waugh", "title": "Sword of Honour", "price": 12.99 }, { "category": "fiction", "author": "Herman Melville", "title": "Moby Dick", "isbn": "0-553-21311-3", "price": 8.99 }, { "category": "fiction", "author": "J. R. R. Tolkien", "title": "The Lord of the Rings", "isbn": "0-395-19395-8", "price": 22.99 } ]`)
    
    	helloFilter, err := jsonpath.Prepare("$..price")
    	if err != nil { 
    		panic(err)
    	}
    
    	var data interface{ }
    	if err = json.Unmarshal(raw, &data); err != nil { 
    		panic(err)
    	}
    
    	out, err := helloFilter(data)
    	if err != nil { 
    		panic(err)
    	}
    
    	fmt.Print(out)
    
    	c.Ctx.WriteString("获取配置成功")
    }

<table> 
 <thead> 
 <tr> 
 <th>JsonPath (click link to try)</th> 
 <th>Result</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 14: .store.book[*\̲]̲.author](http:/….store.book[*].author)</td> 
 <td>The authors of all books</td> 
 </tr> 
 <tr> 
 <td>[ . . a u t h o r ] ( h t t p : / / j s o n p a t h . h e r o k u a p p . c o m / ? p a t h = ..author](http://jsonpath.herokuapp.com/?path= ..author](http://jsonpath.herokuapp.com/?path=…author)</td> 
 <td>All authors</td> 
 </tr> 
 <tr> 
 <td>[ . s t o r e . ∗ ] ( h t t p : / / j s o n p a t h . h e r o k u a p p . c o m / ? p a t h = .store.*](http://jsonpath.herokuapp.com/?path= .store.∗](http://jsonpath.herokuapp.com/?path=.store.*)</td> 
 <td>All things, both books and bicycles</td> 
 </tr> 
 <tr> 
 <td>[ . s t o r e . . p r i c e ] ( h t t p : / / j s o n p a t h . h e r o k u a p p . c o m / ? p a t h = .store..price](http://jsonpath.herokuapp.com/?path= .store..price](http://jsonpath.herokuapp.com/?path=.store…price)</td> 
 <td>The price of everything</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 9: ..book[2\̲]̲](http://jsonpa……book[2])</td> 
 <td>The third book</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 10: ..book[-2\̲]̲](http://jsonpa……book[2])</td> 
 <td>The second to last book</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 11: ..book[0,1\̲]̲](http://jsonpa……book[0,1])</td> 
 <td>The first two books</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 10: ..book[:2\̲]̲](http://jsonpa……book[:2])</td> 
 <td>All books from index 0 (inclusive) until index 2 (exclusive)</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 11: ..book[1:2\̲]̲](http://jsonpa……book[1:2])</td> 
 <td>All books from index 1 (inclusive) until index 2 (exclusive)</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 11: ..book[-2:\̲]̲](http://jsonpa……book[-2:])</td> 
 <td>Last two books</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 10: ..book[2:\̲]̲](http://jsonpa……book[2:])</td> 
 <td>Book number two from tail</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 17: ….book[?(@.isbn)\̲]̲](http://jsonpa……book[?(@.isbn)])</td> 
 <td>All books with an ISBN number</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 28: …?(@.price &lt; 10)\̲]̲](http://jsonpa….store.book[?(@.price &lt; 10)])</td> 
 <td>All books in store cheaper than 10</td> 
 </tr> 
 <tr> 
 <td>[$…book[?(@.price &lt;= KaTeX parse error: Can't use function '\]' in math mode at position 13: ['expensive'\̲]̲)]](http://json……book[?(@.price &lt;= $[‘expensive’])])</td> 
 <td>All books in store that are not “expensive”</td> 
 </tr> 
 <tr> 
 <td>[KaTeX parse error: Can't use function '\]' in math mode at position 32: …r =~ /.*REES/i)\̲]̲](http://jsonpa……book[?(@.author =~ /.*REES/i)])</td> 
 <td>All books matching regex (ignore case)</td> 
 </tr> 
 <tr> 
 <td>[ . . ∗ ] ( h t t p : / / j s o n p a t h . h e r o k u a p p . c o m / ? p a t h = ..*](http://jsonpath.herokuapp.com/?path= ..∗](http://jsonpath.herokuapp.com/?path=…*)</td> 
 <td>Give me every thing</td> 
 </tr> 
 <tr> 
 <td>[ . . b o o k . l e n g t h ( ) ] ( h t t p : / / j s o n p a t h . h e r o k u a p p . c o m / ? p a t h = ..book.length()](http://jsonpath.herokuapp.com/?path= ..book.length()](http://jsonpath.herokuapp.com/?path=…book.length())</td> 
 <td>The number of books</td> 
 </tr> 
 </tbody> 
</table>

输出结果

![ed44167e18ba56d76c7503a48ee8b526.png][]

如果是gitlab 分支

![99531f0d3c5282102cb479b8418a6c30.png][]

也可以在线测试

地址https://play.golang.org/

![697c2d3e47e40cc13efa3dec50708691.png][]

参考

https://github.com/json-path/JsonPath

https://bbs.csdn.net/topics/397685692

[ed44167e18ba56d76c7503a48ee8b526.png]: /images/20221123/cf9ce0a985584810b255edba46dcf436.png
[99531f0d3c5282102cb479b8418a6c30.png]: /images/20221123/50e3d6010991433ab6f28a78b03c3248.png
[697c2d3e47e40cc13efa3dec50708691.png]: /images/20221123/467a0baa78144af7a9056966099e6150.png