SuperDB

Operator

  switch — route values based on cases

Synopsis

switch <expr>
  case <const> ( <branch> )
  case <const> ( <branch> )
  ...
  [ default ( <branch> ) ]

switch
  case <bool-expr> ( <branch> )
  case <bool-expr> ( <branch> )
  ...
  [ default ( <branch> ) ]

Description

The switch operator routes input values to parallel pipe branches based on case matching.

In this first form, the expression <expr> is evaluated for each input value and its result is compared with all of the case values, which must be distinct, compile-time constant expressions. The value is propagated to the matching branch.

In the second form, each case is evaluated for each input value in the order that the cases appear. The first case to match causes the input value to propagate to the corresponding branch. Even if later cases match, only the first branch receives the value.

In either form, if no case matches, but a default is present, then the value is routed to the default branch. Otherwise, the value is dropped.

Only one default case is allowed and it may appear anywhere in the list of cases; where it appears does not influence the result.

The output of a switch consists of multiple branches that must be merged. If the downstream operator expects a single input, then the output branches are combined without preserving order. Order may be reestablished by applying a sort at the merge point.

Examples

Split input into evens and odds

# spq
switch
  case this%2==0 ( {even:this} )
  case this%2==1 ( {odd:this} )
| sort odd,even
# input
1
2
3
4
# expected output
{odd:1}
{odd:3}
{even:2}
{even:4}

Switch on this with a constant case

# spq
switch this
  case 1 ( values "1!" )
  default ( values this::string )
| sort
# input
1
2
3
4
# expected output
"1!"
"2"
"3"
"4"