#$transactional

#Import

1import { $transactional } from "alepha/orm";

#Overview

Middleware that wraps handler execution in a database transaction.

All Repository operations inside the handler automatically participate in the transaction - no explicit { tx } drilling required.

Nesting joins: inside another $transactional block, the handler runs on the outer transaction, and a throw rolls the whole of it back. Options the outer transaction cannot honour throw instead of being ignored: a different isolation, or access: "read write" inside a read only transaction. Set them on the outermost block.

⚠️ A no-op on a driver without transactions (Cloudflare D1, PGlite): the handler runs in place, and a throw rolls nothing back. Each primitive logs one warning the first time it runs there. Code that must be correct on D1 guards its writes instead: preconditions in the WHERE, db.version(), or an order in which a failure leaves harmless state.

 1class OrderService { 2  createOrder = $action({ 3    method: "POST", 4    path: "/createOrder", 5    use: [$transactional()], 6    handler: async ({ body }) => { 7      await this.orders.create(body);      // auto-uses tx 8      await this.audit.create({ ... });     // auto-uses tx 9      // throw → rollback, return → commit (not on D1: see above)10    },11  });12}

#Options