MVFM

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...