db
SQLite: open, exec, query with parameters.
benutzen "db". Engine must be "sqlite".
Use #[param, ...] for ? placeholders.
Functions
Open SQLite, run statements, and query rows with `?` placeholders.
| Symbol | Description | Example |
|---|---|---|
open(path, "sqlite") | Open connection | benutzen "db";
var c = db::open("app.db", "sqlite"); |
exec(conn, sql) | Run SQL without params | benutzen "db";
var c = db::open("app.db", "sqlite");
db::exec(c, "CREATE TABLE t (id INTEGER)"); |
exec(conn, sql, params) | Run SQL with `?` placeholders | benutzen "db";
var c = db::open("app.db", "sqlite");
db::exec(c, "INSERT INTO t VALUES (?)", #[1]); |
query(conn, sql) | SELECT → array of row objects | benutzen "db";
var c = db::open("app.db", "sqlite");
var rows = db::query(c, "SELECT * FROM t"); |
query(conn, sql, params) | SELECT with placeholders | benutzen "db";
var c = db::open("app.db", "sqlite");
var rows = db::query(c, "SELECT * FROM t WHERE id = ?", #[1]); |
lastId(conn) | Last inserted row id | benutzen "db";
var c = db::open("app.db", "sqlite");
print db::lastId(c); |
changes(conn) | Rows changed by last statement | benutzen "db";
var c = db::open("app.db", "sqlite");
print db::changes(c); |
close(conn) | Close connection | benutzen "db";
var c = db::open("app.db", "sqlite");
db::close(c); |