单元测试的简单播放幻灯片设置

Question

我使用play-slick进行slick集成，并使用Guice注入DAO。创建表格和填充种子数据的进化，即1.sql, 2.sql, ...。我几乎完成了，我想把我的Evolutions文件和application.conf分成两个环境。

我创建了两组指向不同数据库的conf/application.conf和test/conf/application.test.conf，用于测试和实时部署。我已经设置了build.sbt，将application.test.conf用于test，

javaOptions in Test += "-Dconfig.file=test/conf/application.test.conf"

application.test.conf含量，

slick.dbs.h2test.driver = "slick.driver.H2Driver$"
slick.dbs.h2test.db.driver = org.h2.Driver
slick.dbs.h2test.db.url = "jdbc:test.h2:mem:play;MODE=MYSQL;DB_CLOSE_DELAY=-1"

如何将我的测试用例/套件配置为使用h2test上下文（即conf/evolutions/h2test/1.sql）而不是default来填充测试数据并再次运行Slick查询h2test？我尝试使用FakeApplication和GuiceApplicationBuilder方法，但收效甚微。感谢

Answer 1

我看到了我流畅的示例

  class EmployeeRepositorySpec extends PlaySpecification{
     import models._
     "Employee repository" should {
       def empRepo(implicit app: Application) = Application.instanceCache[EmployeeRepository].apply(app)
    "get all rows" in new WithApplication()  {
      val result = await(empRepo.getAll)
      result.length === 4
      result.head.name === "sky"
     }
  "get single rows" in new  WithApplication()  {
      val result = await(empRepo.getById(1))
    result.isDefined === true
      result.get.name === "Vikas"
  }
   "insert a row" in new  WithApplication()  {
    val knolId = await(empRepo.insert(Employee("sky", "[e-mail]",  "knoldus","Senior Consultant")))
     knolId === 5
    }
   "insert multiple rows" in new  WithApplication()  {
     val result = empRepo.insertAll(List(Employee("sky1", "[e-mail]", "knoldus","Senior Consultant"),
    Employee("sky2", "[e-mail]", "knoldus","Senior Consultant")))
      val knolIds = await(result)
     knolIds === Seq(5, 6)
    }
    "update a row" in new  WithApplication()  {
      val result = await(empRepo.update(Employee("sky", "[e-mail]",  "knoldus","Senior Consultant", Some(1))))
      result === 1
     }
     "delete a row" in new  WithApplication()  {
       val result = await(empRepo.delete(1))
       result === 1
     }
    }
   def await[T](v: Future[T]): T = Await.result(v, Duration.Inf)
 }

Answer 2

我添加了play.slick.db.default = test以覆盖application.test.conf中的默认。除此之外，我添加了

play.evolutions.db.default.autoApply = false
slick.dbs.default.driver = "slick.driver.H2Driver$"
slick.dbs.default.db.driver = "org.h2.Driver"
slick.dbs.default.db.url = "jdbc:h2:mem:nothing"

否则，Evolution还会填充由"默认"定义的其他数据库，而我的"其他数据库"没有运行，这导致我的测试失败，因为连接到不存在的数据库失败。

Answer 3

您可以创建一个通用类，为所有存储库编写测试用例，如下所示：

 class TestModel[T: ClassTag] extends WithApplicationLoader {
  lazy val app2dao = Application.instanceCache[T]
  lazy val repository: T = app2dao(app)
  def result[R](response: Future[R]): R =
    Await.result(response, 2.seconds)
}

现在，通过TestModel中的测试类，从测试用例中创建一个对象，如下所示：

class TestRepositoryTest extends Specification {
  private val modelTest = new ModelsTest[TestRepository]
  "Test Repository" should {
    "store a user" in {
      val testObj = Test(0, "[e-mail]", new DateTime(System.currentTimeMillis))
      val storeResult =
        modelTest.result(modelTest.repository.store(testObj))
      storeResult must equalTo(1)
    }
  }
}