Examples

Examples in Examples.json file below demonstrate boolean functions described in Boolean Functions

Note

The following JSON files are referenced in JsonQL expressions in Examples.json in example below:

• Data.json

• Companies.json

{
  "HasField": {
    "HasField_1": "$value(HasFieldData.Array1.Where(x => HasField(x, 'Id')))",
    "HasField_2": "$value(HasFieldData.Array1.Where(x => HasField(x.Address, 'Street')))",
    "HasField_3": "$(HasField(HasFieldData.InvalidPath, 'Street')) is false"
  },
  "IsEven": {
    "IsEven_1": "$value(IsEven(Count(Companies.Select(c => c.Employees))))",
    "IsEven_2": "$value(IsEvenIsOddData.Array1.Where(x => IsEven(x)))",
    "IsEven_3": "$(IsEven(IsEvenIsOddData.InvalidPath) is undefined) is true"
  },
  "IsOdd": {
    "IsOdd_1": "$value(IsOdd(Count(Companies.Select(c => c.Employees))))",
    "IsOdd_2": "$value(IsEvenIsOddData.Array1.Where(x => IsOdd(x)))",
    "IsOdd_3": "$(IsOdd(IsEvenIsOddData.InvalidPath) is undefined) is true"
  }
}

The result (i.e., an instance of JsonQL.Compilation.ICompilationResult) is serialized to a Result.json file below.

Note

For brevity, the serialized result includes only serialized evaluated Examples.json and does not include parent JSON files in JsonQL.Compilation.ICompilationResult.CompiledJsonFiles

Click to expand the result in instance of JsonQL.Compilation.ICompilationResult serialized into Result.json

{
  "CompiledJsonFiles":[
    {
      "TextIdentifier": "Examples",
      "CompiledParsedValue":
      {
        "HasField": {
          "HasField_1": [
            {
              "Id":  1,
              "Salary":  101000,
              "Address": {
                "Street":  "654 Cedar Road",
                "City":  "Phoenix",
                "State":  "AZ",
                "ZipCode":  "85001"
              }
            }
          ],
          "HasField_2": [
            {
              "Id":  1,
              "Salary":  101000,
              "Address": {
                "Street":  "654 Cedar Road",
                "City":  "Phoenix",
                "State":  "AZ",
                "ZipCode":  "85001"
              }
            }
          ],
          "HasField_3":  "false is false"
        },
        "IsEven": {
          "IsEven_1":  true,
          "IsEven_2": [
            4,
            2,
            12
          ],
          "IsEven_3":  "true is true"
        },
        "IsOdd": {
          "IsOdd_1":  false,
          "IsOdd_2": [
            1,
            3
          ],
          "IsOdd_3":  "true is true"
        }
      }
    }
  ],
  "CompilationErrors":
  {
    "$type": "System.Collections.Generic.List`1[[JsonQL.Compilation.ICompilationErrorItem, JsonQL]], System.Private.CoreLib",
    "$values": []
  }
}

The code snippet shows how the JSON file Examples.json was parsed using JsonQL.Compilation.IJsonCompiler

// Set the value of jsonCompiler to an instance of JsonQL.Compilation.IJsonCompiler here.
// The value of JsonQL.Compilation.JsonCompiler is normally created by Dependency Injection container
// and it is normally configured as a singleton.
JsonQL.Compilation.IJsonCompiler jsonCompiler = null!;

var sharedExamplesFolderPath = new []
{
    "DocFiles", "MutatingJsonFiles", "Examples"
};

var dataJsonTextData = new JsonTextData("Data", this.LoadExampleJsonFile("Data.json"));

var companiesJsonTextData = new JsonTextData("Companies",
    LoadJsonFileHelpers.LoadJsonFile("Companies.json", sharedExamplesFolderPath), dataJsonTextData);

var result = jsonCompiler.Compile(new JsonTextData("Examples",
    this.LoadExampleJsonFile("Examples.json"), companiesJsonTextData));