Fix #548
Fix #535

Add strategies_in and plugins_in filter to Space.

This allow query such as:

query Spaces {
  spaces(
    first: 10,
    where: { plugins_in: ["poap", "progress"], strategies_in: ["whitelist"], network: "1" }
  ) {
    strategies {
      name
    }
    plugins
    network
  }
}

Those filters behave differently than the proposal's strategies_contains.

strategies_contains is using string search, and can match anything, such as {.
strategies/plugins_in filter will exact match the strategy/plugin name.

Feature has been applied to Proposal via #705

The strategies search only apply to level 2 strategies, and will not match nested strategies

Creating the following indices will improve search performance

ALTER TABLE spaces
ADD INDEX strategies_idx ((CAST(JSON_EXTRACT(settings, "$.strategies[*].name") AS CHAR(255) ARRAY) )) USING BTREE;

ALTER TABLE spaces
ADD INDEX plugins_idx ((CAST(JSON_KEYS(settings, "$.plugins") AS CHAR(255) ARRAY) )) USING BTREE;

ALTER TABLE spaces
ADD INDEX network_idx ((CAST(JSON_UNQUOTE(JSON_EXTRACT(settings, "$.network")) AS CHAR(255)) COLLATE utf8mb4_bin )) USING BTREE;

The goal of those new filters will be to enable the snapshot UI to show the list of spaces using specific network/strategy/plugin

Note

JSON_OVERLAPS require Mysql version >= 8.0.17