Runner

[db/sqlite3/Runner]

icon

---

Runs a single SQL statement on the specified SQLite database, with the specified parameters. Further on SQLite3 syntax: https://www.sqlite.org/syntax.html

---

Keywords: run, execute, statement, insert, delete, update, sql

Input ports

• params:

  {"db-id": string, "sql": string, optional "params": (string or number)[]}

Output ports

• done: string

• last ID: string

• changes: number

• error: string