Treatment executeRaw

sql::executeRaw

Configuration

⬡ sql_pool: sql::SqlPool

Parameters

↳ var sql: string

Inputs

⇥ trigger: Block<void>

Outputs

↦ affected: Block<u64>
↦ completed: Block<void>
↦ error: Block<string>
↦ failed: Block<void>
↦ finished: Block<void>

Execute a raw SQL statement without parameter binding.

Waits for trigger, then runs sql directly against the pool. completed and affected are emitted on success; failed and error on failure. finished is always emitted.

⚠️ This treatment does not sanitise sql — only use it with trusted, static SQL strings.

graph LR
     T("executeRaw()")
     B["〈🟦〉"] -->|trigger| T
     T -->|completed| C["〈🟩〉"]
     T -->|affected| A["〈🟨〉"]
     T -->|failed| F["〈🟥〉"]
     T -->|error| E["〈🟫〉"]
     T -->|finished| FN["〈🟦〉"]
     style B fill:#ffff,stroke:#ffff
     style C fill:#ffff,stroke:#ffff
     style A fill:#ffff,stroke:#ffff
     style F fill:#ffff,stroke:#ffff
     style E fill:#ffff,stroke:#ffff
     style FN fill:#ffff,stroke:#ffff