Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.aws.amazon.com/iot/latest/developerguide/iot-sql-case.html below:

Case statements - AWS IoT Core

Case statements can be used for branching execution, like a switch statement.

Syntax:

CASE v WHEN t[1] THEN r[1] 
  WHEN t[2] THEN r[2] ... 
  WHEN t[n] THEN r[n] 
  ELSE r[e] END

The expression v is evaluated and matched for equality against the t[i] value of each WHEN clause. If a match is found, the corresponding r[i] expression becomes the result of the CASE statement. The WHEN clauses are evaluated in order so that if there's more than one matching clause, the result of the first matching clause becomes the result of the CASE statement. If there are no matches, r[e] of the ELSE clause is the result. If there's no match and no ELSE clause, the result is Undefined.

CASE statements require at least one WHEN clause. An ELSE clause is optional.

For example:

Incoming payload published on topic topic/subtopic:

{
    "color":"yellow"
} 

SQL statement:

SELECT CASE color
        WHEN 'green' THEN 'go'
        WHEN 'yellow' THEN 'caution'
        WHEN 'red' THEN 'stop'
        ELSE 'you are not at a stop light' END as instructions
    FROM 'topic/subtopic'

The resulting output payload would be:

{
    "instructions":"caution"
}

If v is Undefined, the result of the case statement is Undefined.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4