Query json for array size.

[lefscode]

Hello,

This is an "info request".

I have the following json and I would like to check if the input contains a father (fid) with two children.

{
  "data": [
    {
      "fid": 10,
      "children": [
        {
          "cid": 123
        },
        {
          "cid": 124
        }

      ]
    }
  ]
}

The code so far is

package main

import (
    "fmt"

    "github.com/thedevsaddam/gojsonq"
)

const json = `{
    "data": [
      {
        "fid": 10,
        "children": [
          {
            "cid": 123
          },
          {
            "cid": 124
          }

        ]
      }
    ]
  }`

func main() {

    q := gojsonq.New().JSONString(json).From("data").
        Where("fid", "=", 10)
    fmt.Println(q.Get())
}

How can I modify the source code to decide if fid=10 AND children.size() = 2?

In principle how can I use the "array size" to query the json file/input?

Thanks

[thedevsaddam]

Probably we should add this feature soon.

[lefscode]

Thanks for the follow up. I think that this would be very helpful .... From("data").Where("fid", "=", 10).Where("children" "OP", number).

Where OP could be count, contains, max, min, etc.... .... From("data").Where("fid", "=", 10).Where("children" "count", 2)

[thedevsaddam]

@lefscode For this time you can add custom Macro function to solve the problem

[lefscode]

@thedevsaddam, thanks. That's interesting. How can we get the existence of the "children" array and the capacity of this array?

[thedevsaddam]

@lefscode Here is a quick solution, please check errors and more types for your need.

package main

import (
    "fmt"

    "github.com/davecgh/go-spew/spew"
    "github.com/thedevsaddam/gojsonq"
)

const json = `{
  "data":[
    {
      "fid":10,
      "children":[
        {
          "cid":121
        },
        {
          "cid":122
        },
        {
          "cid":125
        }
      ]
    },
    {
      "fid":10,
      "children":[
        {
          "cid":123
        },
        {
          "cid":124
        }
      ]
    }
  ]
}`

func main() {

    var count = func(x, y interface{}) (bool, error) {
        yv, ok := y.(int)
        if !ok {
            return false, fmt.Errorf("%v is must be an integer", y)
        }

        xv, ok := x.([]interface{}) // do various check for yourself
        if !ok {
            return false, fmt.Errorf("%v must be an array", x)
        }

        if len(xv) == yv {
            return true, nil
        }

        return false, nil
    }
    q := gojsonq.New().Macro("count", count).JSONString(json).From("data").
        Where("fid", "=", 10).Where("children", "count", 3)
    spew.Dump(q.Get(), q.Error())
}

As this type of task can be done by Macro I'm closing the issue.

[thedevsaddam]

@lefscode This is a good feature. You can use it from gojsonq v1.7.0

1. https://github.com/thedevsaddam/gojsonq/wiki/Queries#wherelenequalkey-val

2. https://github.com/thedevsaddam/gojsonq/wiki/Queries#wherekey-op-val