Play20 Transactional Action sample

controller.scala

// zentasks example

object Projects extends Controller with Secured with Tx {

  /**
   * Display the dashboard.
   */
  def index = localTx { IsAuthenticated { username => _ =>
    User.findByEmail(username).map { user =>
      Ok(
        html.dashboard(
          Project.findInvolving(username),
          Task.findTodoInvolving(username),
          user
        )
      )
    }.getOrElse(Forbidden)
  }}

}

Tx.scala

trait Tx { self: Controller =>
  def localTx[A](action: Action[A]) = LocalTxActionDecorator[A](action)
}

case class LocalTxActionDecorator[A](action: Action[A]) extends Action[A] {

  def parser: BodyParser[A] = action.parser

  override def apply() = DB localTx { implicit s => action.apply() }

  def apply(request: Request[A]): Result = DB localTx { implicit s => action.apply(request) }

}