Create Query via JSON

[Jeremy-Unruh-CK]

I just started playing with bolthold this evening and it was quick and easy to setup. Really digging it so far.

Maybe this is already supported, but is there any way to construct a *Query via JSON? I would make for a nice search capability on a REST endpoint I'm considering. Since it would allow a query via json to be passed and evaluated.

I could come up with my own mechanism but would take some work to map into the fluent aspects of the current Query with the hidden internals.

[timshannon]

There's no support for this yet. Shouldn't be too hard to add though.

[ghost]

i would really like to be able to do this.

For me, the intent is to allow others to write queries without recompiling.
I assume that the go types already need to be in the code though ?

[timshannon]

Yeah the types would have to be in code. The way I'm picturing this is a Function call QueryFromJSON or something, and you'd pass in something like this:

{
  "field": "Name",
  "op": "eq",
  "value": "John",
  "and": {
    "field": "ID",
    "op": "ge",
    "value": 3
  },
 "or": {
    "field": "Death",
    "op": "lt",
    "value":  {
      "field": "Birth", 
    }
  }
}

[ghost]

hey @timshannon. That looks like a good start.

Just as a side thought, I was wondering if its possible to write a query in golang and then just deserialize it out as JSON ? This would mean that you could gen the json as part of the build and then run the JSON as tests. Its also means that when you add new query predicates of your own the system is self adapting. If this is not possible its fine, but it was more of an idea.

Edit: This reminds me a lot of Bleve and the JSON based blast.
https://github.com/mosuka/blast
Blast wraps bleve so that you can just use JSON to query bleve. It also nicely manages the cluster of bleve indexes spread around.
He uses GRPC to expose everything.
The reason i am bringing it up is because its a nice model for BoltHold maybe if you every wanted to expose it as a service.

[ghost]

@timshannon found this
https://github.com/Cistern/cistern/blob/master/internal/query/query.go

the queries as serialisable :)
Might be useful.