scala - 鳞状的jdbc。在不显式依赖 Scalikejdbc 和 session 的情况下管理事务

Question

据我从 Scalikejdbc 的文档中了解到，如果我想要进行交易，我需要通过 session 。像这样:

  class FooBarService {

    val fooDao = new FooDao
    val barDao = new BarDao

    def fooBar(): Unit = {
      DB localTx { session =>
        fooDao.foo(new Foo())
        barDao.bar(new Bar())
      }
    }
  }

  class FooDao {
    def foo(foo: Foo)(implicit session: DBSession): Unit = {
      sql"""bla bla bla"""
    }
  }

  class BarDao {
    def bar(bar: Bar)(implicit session: DBSession): Unit = {
      sql"""bla bla bla"""
    }
  }

那件事让我明确地依赖于 Scalikejdbc。我不想在我的领域特征中依赖 Scalike。我想要的是这样的:

class FooBarService {

    val fooDao = new FooDao
    val barDao = new BarDao

    def fooBar(): Unit = {
      // My wrapper which abstract and is not dependent on Scalike or other library
      MyWrapper.withinTransaction {
        fooDao.foo(new Foo())
        barDao.bar(new Bar())
    }
      // or at least not to pass session to daos
      DB withinTransaction {
        fooDao.foo(new Foo())
        barDao.bar(new Bar())
      }
    }
  }

  class FooDao {
    def foo(foo: Foo): Unit = {
      sql"""bla bla bla"""
    }
  }

  class BarDao {
    def bar(bar: Bar): Unit = {
      sql"""bla bla bla"""
    }
  }

有没有办法在类签名中拥有事务并且不依赖于 session 和 scalike？

Answer 1

如果您的应用程序不是非阻塞架构，您可以使用本地线程进行数据库 session 。

• http://scalikejdbc.org/documentation/connection-pool.html#thread-local-connection-pattern
• https://github.com/skinny-framework/skinny-framework/blob/master/orm/src/main/scala/skinny/orm/servlet/TxPerRequestFilter.scala