Popularity
5.8
Declining
Activity
0.0
Stable
272
12
40

Programming language: Go
License: GNU General Public License v3.0 or later
Tags: Query Language    

jsonql alternatives and similar packages

Based on the "Query Language" category.
Alternatively, view jsonql alternatives based on common mentions on social networks and blogs.

Do you think we are missing an alternative of jsonql or a related project?

Add another 'Query Language' Package

README

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]] <nil>

    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