Can't use test database about play-slick HOT 6 CLOSED

Hi,
Can you show us the error message you have with your configuration?
It might me related to this issue #14

from play-slick.

Thanks for your reply. Actually there is no error message and the test passes. The problem is that test database is not used even though I specified the test database configuration.

Here is the way to reproduce the problem

• Set database configuration like this

db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://localhost/play_test"
db.default.user=test_user
db.default.password=test_user_pass

test.db.default.driver=com.mysql.jdbc.Driver
test.db.default.url="jdbc:mysql://localhost/play_test"
test.db.default.user=test_user
test.db.default.password=test_user_pass

• play run to apply evolution
• Insert some data to Cat table
• Change database configuration to this

db.default.driver=org.h2.Driver
db.default.url="jdbc:h2:mem:play"
db.default.user=sa
db.default.password=""

test.db.default.driver=com.mysql.jdbc.Driver
test.db.default.url="jdbc:mysql://localhost/play_test"
test.db.default.user=test_user
test.db.default.password=test_user_pass

• Run test

class SlickSpec extends Specification {

  // Assume there are more than 2 columns inserted at step 3
  // So this test should fail
  "Slick" should {
    "use test database" in {
      running(FakeApplication()) {
        import play.api.Play.current

         DB.withSession { implicit session =>
          val count = Query((for (c <- Query(Cats)) yield c.id).countDistinct).first
          count must beEqualTo(1) 
        }     
      }
    }
  }

}

Test should fail, but it passes. This proves test database(in this case MySQL) is not used.
Could you check this?

from play-slick.

Ok I get it now,
This is because the default datasource is always loaded for the slick session if you don't specify a name : https://github.com/freekh/play-slick/blob/master/src/main/scala/play/api/db/slick/DB.scala
You can load a specific DB session with the name parameter of the DB object

from play-slick.

But there is indeed a little problem.
You need to define DB like this :

      DB("test").withSession { implicit session =>
          val count = Query((for (c <- Query(Cats)) yield c.id).countDistinct).first
          count must beEqualTo(1) 
        }     

The datasource will look datasource named ("db.test") and not ("test.default.db")
I will do a little pull request to change this defaults (used in driver loading)

Right now you can configure your application like this :

test.db.default.driver=com.mysql.jdbc.Driver

db.test.driver=com.mysql.jdbc.Driver
db.test.url="jdbc:mysql://localhost/play_test"
db.test.user=test_user
db.test.password=test_user_pass

from play-slick.

With this pull request the convention for driver and datasource will be the same.
But there is another problem : if you want to test some controllers or models that use DB.withSession you will be binded to the default datasource, not to the test datasource

from play-slick.

I appreciate your PR and reply. I understand how and another problem.
I'll investigate the way I can use environment specified database.

from play-slick.