items

Function

ArgDescriptionType
itemAny

Description

Iterate over dict members producing _key and _value columns

This can be used to filter dict items by feeding the results to to_dict()

items

Plugin

ArgDescriptionType
itemThe item to enumerate.Any

Description

Enumerate all members of the item (similar to Python’s items() method).

This plugin allows iteration over dicts or queries.

Iterating dicts

If the item is a dict, then this plugin will iterate over its keys and values producing two columns:

  • The _key column is the dictionary key
  • The _value column is the dictionary value

Iterating queries

For queries or arrays, the items() plugin will produce two columns:

  • The _key column is the row index starting from 0
  • The _value column is the row itself as a dict.

The items() query is useful to treat the results of another query as a dict instead of a row. This is useful when the query produces unpredictable columns or you need to operate over the column names somehow.

For example:

SELECT * FROM items(item={ SELECT * FROM info() })

Produces:

[
  {
    "_key": 0,
    "_value": {
      "Hostname": "DESKTOP-BTI2T9T",
      "Uptime": 20445,
      "BootTime": 1641029930,
      "Architecture": "amd64"
    }
  }
]
comments powered by Disqus