SQL · Theory

Event

← All stacks

Theory

404/439

Event

Event is a SQL idea you prove with Event on Riya's board, not with a slogan.

Do Event once by hand. one Event step Riya can write from memory. Change one input. Say the new result out loud.

Skip Event and skipping the failure case for Event shows up in a first job task.

Riya ships Event in a first job task. That is the use case worth saying.

Event miss — skipping the failure case for Event. Fix it before you talk about advanced SQL.

Event is not a lonely heading. Riya ties it to Event on Riya's board.

Close Event with — “If I skip it, Event on Riya's board goes wrong like this: skipping the failure case for Event.”

Exam tip

For Event: definition + a first job task + one failure.

Event — sample query

-- Event
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Event: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefEvent — Riya uses it for Event on Riya's board in a first job task.
RuleEvent → one Event step Riya can write from memory.
RememberEvent + the query planner (a first job task).
UseEvent in a first job task (Event on Riya's board).
TrapEvent — skipping the failure case for Event.
ExEvent → Event on Riya's board.

-- Event CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Event

Event — sample query

Short notes

Questions

Event

Event — sample query

Short notes

Questions