scalikejdbc.scalatest

AsyncAutoRollback for ScalaTest

import org.scalatest.fixture.AsyncFlatSpec
class MemberSpec extends AsyncFlatSpec with AsyncAutoRollback {
 describe of "Member"
 it should "create a new record" in { implicit session =>
  Future {
    Member.create(1, "Alice")
    Member.find(1).isDefined should be(true)
  }
 }
}
class LegacyAccountSpec extends AsyncFlatSpec with AsyncAutoRollback {
 override def db() = NamedDB('db2).toDB
 override def fixture(implicit session: DBSession) {
   SQL("insert into legacy_accounts values ...").update.apply()
 }

 it should "create a new record" in { implicit session =>
   Future {
     LegacyAccount.create(2, "Bob")
     LegacyAccount.find(2).isDefined should be(true)
   }
 }
}

AutoRollback for ScalaTest

import org.scalatest.flatspec.FixtureAnyFlatSpec
class MemberSpec extends FixtureAnyFlatSpec with AutoRollback {
 describe of "Member"
 it should "create a new record" in { implicit session =>
   Member.create(1, "Alice")
   Member.find(1).isDefined should be(true)
 }
}
class LegacyAccountSpec extends FlatSpec with AutoRollback {
 override def db() = NamedDB('db2).toDB
 override def fixture(implicit session: DBSession) {
   SQL("insert into legacy_accounts values ...").update.apply()
 }

 it should "create a new record" in { implicit session =>
   LegacyAccount.create(2, "Bob")
   LegacyAccount.find(2).isDefined should be(true)
 }
}