Using the framework in the h2 database for unit tests

Question

I am trying to configure the play framework application to load so that it uses the mysql database at startup and the memory database for tests. When I run the tests, it connects to the mysql database, not the memory database. Does anyone know why?

This is my configuration:

db.default.driver=com.mysql.jdbc.Driver db.default.url="jdbc:mysql://localhost/communityRoots?characterEncoding=UTF-8" db.default.user=root db.default.password= "" db.test.driver=org.h2.Driver db.test.url="jdbc:h2:mem:play;MODE=MYSQL" db.test.user=sa db.test.password="" 

this is my test:

 running(fakeApplication(inMemoryDatabase("test")), new Runnable() { public void run() { new User("[e-mail]", "Bob", "secret").save(); assertNotNull(User.authenticate("[e-mail]", "secret")); assertNull(User.authenticate("[e-mail]", "badpassword")); assertNull(User.authenticate("[e-mail]", "secret")); } }); 

Answer 1

From the real application that I am developing:

 import play.api.inject.bind import org.scalatest.mock.MockitoSugar import play.api.Application import play.api.inject.guice.GuiceApplicationBuilder import database.AccountDAO import play.api.Configuration import play.api.Mode class AccountDAOSpec extends Specification with MockitoSugar { // we add mockito to show that you can also bind your mocks val companyAccountDAOMock = mock[CompanyAccountDAO] // let us create a company account DAO mock def app = new GuiceApplicationBuilder() // you create your app .configure( Configuration.from( Map( // a custom configuration for your tests only "slick.dbs.default.driver" -> "slick.driver.H2Driver$", "slick.dbs.default.db.driver" -> "org.h2.Driver", "slick.dbs.default.db.connectionPool" -> "disabled", "slick.dbs.default.db.keepAliveConnection" -> "true", "slick.dbs.default.db.url" -> "jdbc:h2:mem:test", "slick.dbs.default.db.user" -> "sa", "slick.dbs.default.db.password" -> ""))) .bindings(bind[AccountDAO].to[AccountDAOImpl]) // here you can define your bindings for an actual implementation (note the use of square brackets) .bindings(bind[CompanyAccountDAO].to(companyAccountDAOMock)) // or bind to your mock (note the use of parentheses) .in(Mode.Test) .build() "AccountDAO" should { "throw an Exception when adding a user with an invalid data" in new WithApplication(app) { // here you can use the application you just created, it uses the db you defined for your tests val app2dao = Application.instanceCache[AccountDAO] val accountDAO = app2dao(app) // with this you get the DAO injected accountDAO.addAccount(testAccount).run must throwAn[Exception] } } } 

Answer 2

You must remove the "test". So your first line should be:

 running(fakeApplication(inMemoryDatabase()), new Runnable() { //test specific code });