postgres/begin
Execute multiple queries atomically in a transaction
const app = mvfm(prelude, pg);
const prog = app({}, ($) => {
return $.sql.begin((sql) => [
sql`UPDATE users SET name = 'Alice V2' WHERE id = 1`,
sql`INSERT INTO archive (name, email)
SELECT name, email FROM users WHERE id = 2`,
sql`SELECT * FROM users ORDER BY id`,
]);
});
await fold(defaults(app, { postgres: wasmPgInterpreter }), prog); Initializing database...