Perform JUnit test using in memory database PlayFramework

Question

I try to perform some JUnit test in PlayFramework 2.3.8 I would like this test to be performed in the in memory database, so that I keep the "real" database untouched. This it what I've done:

public class SaveToolsTest extends WithApplication{

    @Before
public void startApp(){

    // Start the app in the in memory database. 
    Map<String, String> settings = new HashMap<String, String>();
    settings.put("db.default.url", "jdbc:h2:mem:play");
    settings.put("db.default.user", "");
    settings.put("db.default.password", "");
    app = Helpers.fakeApplication(settings);
    Helpers.start(app);
    }

    @Test
    public void saveUser(){     
         User user = createUser(); 

        // Save the user into DB. 
        Ebean.save(user);

        // Test if user != null
        assertNotNull(user); 
        assertThat(user.id).isNotNull(); 
    }

But by doing this, I connect the test to the actual db. How can I connect it to an in memory db?

did you check [similar](http://stackoverflow.com/questions/18305326/multiple-databases-with-play-framework-2-1-x) — singhakash, Mar 17 '15 at 11:11
@singhakash I did, and do something like the edited code above. Is that right? — Mornor, Mar 17 '15 at 12:47
@Mornor seems ive also answered this question in my answer to your other question: https://stackoverflow.com/questions/29101562/test-http-response-with-playframework-junit — jsonmurphy, Mar 17 '15 at 20:38

ollie · Answer 1 · 2015-08-17T12:58:21.333

In Play 2.3 and higher, you can specify the test application (and its settings like the used database) by overriding the provideFakeApplication() method. Play will call this method and start the application you have returned before running your tests.

import play.test.*;
import static play.test.Helpers.*;

public class MyTest extends WithApplication {

@Override
public FakeApplication provideFakeApplication(){
    return fakeApplication(inMemoryDatabase());
}

@Test
public void myTest(){
     //your tests here
}

Perform JUnit test using in memory database PlayFramework

1 Answers1