ACTION

DEFINE ACTION

Specifies a named action that is a parameterizable block of multiple top-level expressions.

Syntax

1. DEFINE ACTION: action definition.
2. Name of the action, as part of which the declared action is further available for the call.
3. The values of parameter names are listed in parentheses.
4. AS keyword.
5. List of top-level expressions.
6. END DEFINE: The marker of the last expression inside the action.

One or more of the last parameters can be marked with a question mark ? as optional. If they are omitted during the call, they will be assigned the NULL value.

DO

Executes an ACTION with the specified parameters.

Syntax

1. DO: Executing an action.
2. The named expression for which the action is defined.
3. The values to be used as parameters are listed in parentheses.

EMPTY_ACTION: An action that does nothing.

Example

DEFINE ACTION $hello_world($name, $suffix?) AS
    $name = $name ?? ($suffix ?? "world");
    SELECT "Hello, " || $name || "!";
END DEFINE;

DO EMPTY_ACTION();
DO $hello_world(NULL);
DO $hello_world("John");
DO $hello_world(NULL, "Earth");

BEGIN .. END DO

Performing an action without declaring it (anonymous action).

Syntax

1. BEGIN;
2. List of top-level expressions.
3. END DO.

An anonymous action can't include any parameters.

Example

DO BEGIN
    SELECT 1;
    SELECT 2  -- here and in the previous example of ';' you can omit
END DO before END

EVALUATE IF

EVALUATE IF: Executing an action depending on the condition. It's followed by:

1. Condition.
2. DO with the name and parameters of the action or an anonymous action.
3. An optional ELSE followed by the second DO for a situation where the condition is not met.

EVALUATE FOR

EVALUATE FOR: Executing an action for each item in the list. It's followed by:

1. A named expression applied to each next element in the list.
2. IN keyword.
3. The above-declared named expression applied to the list the action is executed on.
4. DO with the name and parameters of an action or an anonymous action. In the parameters, you can use both the current element from the first paragraph and any named expressions declared above, including the list itself.
5. An optional ELSE followed by the second DO for the situation when the list is empty.

Examples

DEFINE ACTION $hello() AS
    SELECT "Hello!";
END DEFINE;

DEFINE ACTION $bye() AS
    SELECT "Bye!";
END DEFINE;

EVALUATE IF RANDOM(0) > 0.5
    DO $hello()
ELSE
    DO $bye();

EVALUATE IF RANDOM(0) > 0.1 DO BEGIN
    SELECT "Hello!";
END DO;

EVALUATE FOR $i IN AsList(1, 2, 3) DO BEGIN
    SELECT $i;
END DO;

-- copy the table $input to $count new tables
$count = 3;
$input = "my_input";
$inputs = ListReplicate($input, $count);
$outputs = ListMap(
    ListFromRange(0, $count),
    ($i) -> {
        RETURN "tmp/out_" || CAST($i as String)
    }
);
$pairs = ListZip($inputs, $outputs);

DEFINE ACTION $copy_table($pair) as
    $input = $pair.0;
    $output = $pair.1;
    INSERT INTO $output WITH TRUNCATE
    SELECT * FROM $input;
END DEFINE;

EVALUATE FOR $pair IN $pairs
    DO $copy_table($pair)
ELSE
    DO EMPTY_ACTION(); -- you can skip specifying this ELSE,
                       -- default value implies doing nothing