[#xx] Add support for select-filter expressions in policy playground #527

ale64bit · 2023-07-17T11:06:53Z

ale64bit commented

2023-07-17 11:06:53 +00:00

This allows the evaluation of fragments of a policy so that it can be understood and developed incrementally.

Usage:

Setup a test netmap:

> add 01 Char:A Shape:Circle  Color:Blue
> add 02 Char:B Shape:Circle  Color:Green
> add 03 Char:C Shape:Circle  Color:Red
> add 04 Char:D Shape:Square  Color:Blue
> add 05 Char:E Shape:Square  Color:Green
> add 06 Char:F Shape:Square  Color:Red
> add 07 Char:G Shape:Diamond Color:Blue
> add 08 Char:H Shape:Diamond Color:Green
> add 09 Char:I Shape:Diamond Color:Red

Evaluate filters:

> eval FILTER Color EQ 'Blue' AS BlueNodes
	 1: [01 07 04]
> eval FILTER Color EQ 'Red' AS RedNodes
	 1: [03 09 06]
> eval FILTER Color EQ 'Blue' AS BlueNodes FILTER Color EQ 'Red' AS RedNodes FILTER @RedNodes OR @BlueNodes AS RedOrBlueNodes
	 1: [06 07 04 03 09 01]

Evaluate selectors:

> eval SELECT 1 FROM *
	 1: [06 05 02]
> eval CBF 1 SELECT 1 FROM *
	 1: [06]
> eval SELECT 3 FROM *
	 1: [06 03 04]
	 2: [05 01 07]
	 3: [02 09 08]

Evaluate combined filters and selectors:

> eval CBF 2 SELECT 2 FROM RedOrBlueNodes FILTER Color EQ 'Blue' AS BlueNodes FILTER Color EQ 'Red' AS RedNodes FILTER @RedNodes OR @BlueNodes AS RedOrBlueNodes
	 1: [06 01]
	 2: [03 09]

Signed-off-by: Alejandro Lopez a.lopez@yadro.com

This allows the evaluation of fragments of a policy so that it can be understood and developed incrementally. Usage: Setup a test netmap: ``` > add 01 Char:A Shape:Circle Color:Blue > add 02 Char:B Shape:Circle Color:Green > add 03 Char:C Shape:Circle Color:Red > add 04 Char:D Shape:Square Color:Blue > add 05 Char:E Shape:Square Color:Green > add 06 Char:F Shape:Square Color:Red > add 07 Char:G Shape:Diamond Color:Blue > add 08 Char:H Shape:Diamond Color:Green > add 09 Char:I Shape:Diamond Color:Red ``` Evaluate filters: ```sql > eval FILTER Color EQ 'Blue' AS BlueNodes 1: [01 07 04] > eval FILTER Color EQ 'Red' AS RedNodes 1: [03 09 06] > eval FILTER Color EQ 'Blue' AS BlueNodes FILTER Color EQ 'Red' AS RedNodes FILTER @RedNodes OR @BlueNodes AS RedOrBlueNodes 1: [06 07 04 03 09 01] ``` Evaluate selectors: ```sql > eval SELECT 1 FROM * 1: [06 05 02] > eval CBF 1 SELECT 1 FROM * 1: [06] > eval SELECT 3 FROM * 1: [06 03 04] 2: [05 01 07] 3: [02 09 08] ``` Evaluate combined filters and selectors: ```sql > eval CBF 2 SELECT 2 FROM RedOrBlueNodes FILTER Color EQ 'Blue' AS BlueNodes FILTER Color EQ 'Red' AS RedNodes FILTER @RedNodes OR @BlueNodes AS RedOrBlueNodes 1: [06 01] 2: [03 09] ``` Signed-off-by: Alejandro Lopez <a.lopez@yadro.com>

ale64bit requested review from storage-core-committers 2023-07-17 11:07:15 +00:00

ale64bit requested review from storage-core-developers 2023-07-17 11:07:15 +00:00

ale64bit force-pushed feature/eval-select-filter-expr from 6371b286c1 to 62efde94f2

2023-07-17 11:07:53 +00:00

Compare

dstepanov-yadro approved these changes 2023-07-18 06:59:26 +00:00

fyrchik approved these changes 2023-07-18 10:48:52 +00:00

cmd/frostfs-cli/modules/container/policy_playground.go Outdated

					
				@ -92,2 +88,2 @@

					if err != nil {

						return fmt.Errorf("building container nodes: %v", err)

					if strings.HasPrefix(policyStr, "CBF") || strings.HasPrefix(policyStr, "SELECT") || strings.HasPrefix(policyStr, "FILTER") {