GitHub - elgs/jsonql: JSON query expression library in Golang. (original) (raw)

jsonql

JSON query expression library in Golang.

This library enables query against JSON. Currently supported operators are: (precedences from low to high)

||
&&
= != > < >= <= ~= !~= is isnot contains
+ -
* / %
^
( )

The following are the operator mapings to SQL:

• AND to &&
• OR to ||
• RLIKE to ~=
• NOT RLIKE to !~=

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, "hobby": null, "skills": [ "IC", "Electric design", "Verification" ] }, { "name": "sam", "gender": "m", "age": 1, "hobby": "dancing", "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]]

fmt.Println(parser.Query("name='elgs' && gender='f'"))
//[] <nil>

fmt.Println(parser.Query("age<10 || (name='enny' && gender='f')"))
// [map[hobby:<nil> skills:[IC Electric design Verification] name:enny gender:f age:36] map[name:sam gender:m age:1 hobby:dancing skills:[Eating Sleeping Crawling]]] <nil>

fmt.Println(parser.Query("age<10"))
// [map[gender:m age:1 hobby:dancing skills:[Eating Sleeping Crawling] name:sam]] <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 hobby:<nil>]] <nil>

fmt.Println(parser.Query("name ~= 'e.*'"))
// [map[name:elgs gender:m age:35 skills:[Golang Java C]] map[hobby:<nil> skills:[IC Electric design Verification] name:enny gender:f age:36]] <nil>

fmt.Println(parser.Query("name='el'+'gs'"))
fmt.Println(parser.Query("age=30+5.0"))
fmt.Println(parser.Query("age=40.0-5"))
fmt.Println(parser.Query("age=70-5*7"))
fmt.Println(parser.Query("age=70.0/2.0"))
fmt.Println(parser.Query("age=71%36"))
// [map[name:elgs gender:m age:35 skills:[Golang Java C]]] <nil>

fmt.Println(parser.Query("hobby is defined"))
// [map[name:enny gender:f age:36 hobby:<nil> skills:[IC Electric design Verification]] map[name:sam gender:m age:1 hobby:dancing skills:[Eating Sleeping Crawling]]] <nil>

fmt.Println(parser.Query("hobby isnot defined"))
// [map[name:sam gender:m age:1 skills:[Eating Sleeping Crawling]]] <nil>

fmt.Println(parser.Query("hobby is null"))
// [map[hobby:<nil> skills:[IC Electric design Verification] name:enny gender:f age:36]] <nil>

fmt.Println(parser.Query("hobby isnot null"))
// [map[name:sam gender:m age:1 hobby:dancing skills:[Eating Sleeping Crawling]]] <nil>

fmt.Println(parser.Query("skills contains 'Eating'"))
// [map[age:1 gender:m hobby:dancing name:sam skills:[Eating Sleeping Crawling]]] <nil>

}

Query Expressions

For details of query expressions, please read: https://github.com/elgs/gojq