Providing Transaction Context for Specific Scope

db.transaction(tx => {
  const todoRepository = new TodoRepository(tx);
  return todoRepository.getById(...)
});

Effect.runPromise(
  pipe(
    WithTransaction.pipe(
      TodoRepository,
      Effect.map(todoRepository => todoRepository.getById(...)
    ),
    Effect.provideService(DatabaseService, ...),
  ),
);

const WithTransaction = Layer.scopedContext(
  pipe(
    DatabaseService,
    Effect.flatMap((database) => {
      const { promise, resolve } = Promise.withResolvers();
      return Effect.acquireRelease(
        Effect.sync(() => {
          let _transaction: Database;
          database.transaction((transaction) => {
            _transaction = transaction;
            return promise;
          });
          return _transaction!;
        }),
        () => Effect.sync(() => resolve()),
      );
    }),
  ),
);