Kendo data query for Go

Go (Golang) library to parse and apply Kendo data query on a MongoDB database using mgo.

• Kendo data query for Go
  • Install
  • Examples
    • Handler example
      • DataResult example
  • Limitations
  • Roadmap

Install

go get -u github.com/x22n/kendo-data-query

Examples

Handler example

func MyHandler(w http.ResponseWriter, r *http.Request) {
    ds, err := kendo.NewDataStateFromRequest(ctx.Request)
    if err != nil {
        // Error handling
    }
    ...
    // the following should not be directly in the handler, for reference only
    session, err := mgo.DialWithInfo(mongoDBDialInfo)
    collection := session.DB("db").C("collection")
    dr := ds.Apply(collection)
}

DataResult example

{"data":[{"title":"cat","due":1.98},{"title":"dog","due":8.21},...],"total":325}

Limitations

• Does not support multiple sorts on base columns BUT supports multiple sorted groups
• Only supports and logic between filters
• Only supports avg and sum aggregates

Roadmap

• Support for or logic between filters
• Support for complex/nested filters
• Support for more aggregates