[Golang] 用类SQL语句查询JSON

elgs

由 elgs 发布于 2016年01月01日

无人欣赏。

我刚刚发布了一个用类SQL语句查询JSON的Golang项目。同样是为了满足查询配置信息和通过用户输入查询JSON的问题。希望对玩Golang的同学有用。

https://github.com/elgs/jsonql

jsonql

SQL like JSON query library in Golang.

This library enables query against JSON using SQL like WHERE clause. Currently supported operators are: (precedences from low to high, case insensitive)

OR
AND
= != > < >= <= RLIKE
+ -
* / %
^
( )

Please note I decided not to implement LIKE or NOTE LIKE operations because RLIKE is enough to handle the cases LIKE and NOT LIKE handle.

Install

go get -u github.com/elgs/jsonql

Example

package main
import (
 "fmt"
 "github.com/elgs/jsonql"
)
var jsonString = `
[
 {
 "name": "elgs",
 "gender": "m",
 "age": 35,
 "skills": [
 "Golang",
 "Java",
 "C"
 ]
 },
 {
 "name": "enny",
 "gender": "f",
 "age": 36,
 "skills": [
 "IC",
 "Electric design",
 "Verification"
 ]
 },
 {
 "name": "sam",
 "gender": "m",
 "age": 1,
 "skills": [
 "Eating",
 "Sleeping",
 "Crawling"
 ]
 }
]
`
func main() {
 parser, err := jsonql.NewStringQuery(jsonString)
 if err != nil {
 fmt.Println(err)
 return
 }
 fmt.Println(parser.Query("name='elgs'"))
 //[map[skills:[Golang Java C] name:elgs gender:m age:35]] <nil>
 fmt.Println(parser.Query("name='elgs' and gender='f'"))
 //[] <nil>
 fmt.Println(parser.Query("age<10 or (name='enny' and gender='f')"))
 //[map[gender:f age:36 skills:[IC Electric design Verification] name:enny] map[age:1 skills:[Eating Sleeping Crawling] name:sam gender:m]] <nil>
 fmt.Println(parser.Query("age<10"))
 //[map[name:sam gender:m age:1 skills:[Eating Sleeping Crawling]]] <nil>
 fmt.Println(parser.Query("1=0"))
 //[] <nil>
 fmt.Println(parser.Query("age=(2*3)^2"))
 //[map[skills:[IC Electric design Verification] name:enny gender:f age:36]] <nil>
 fmt.Println(parser.Query("name RLIKE 'e.*'"))
 //[map[age:35 skills:[Golang Java C] name:elgs gender:m] map[skills:[IC Electric design Verification] name:enny gender:f age:36]] <nil>
}

golang json sql