DAO integration test with TestContainers , Spring boot , Liquibase and PostgresSQL

We will cover here how to do DAO integration test when you have spring boot application with PostgreSQL DB and liquibase for schema versioning , last time we have explained how to do the same without liquibase using embedded PostgreSQL in this post but this time we will do the same but using docker with test containers which will apply your liquibase changes and making sure you DAO integration test has the same environment as production database environment if you are using docker for your data base in production .

The whole code example is on Github.

Maven dependencies :

Beside spring boot starter dependencies we will need to add liquibase and test containers dependencies , whole maven pom file can be viewed in Github code

Your liquibase database simple master configuration will be in your resources source set which will create simple customer table with file name changelog-master.xml .

Spring boot DAO integration test configuration :

We will highlight the important sections , the whole configuration java file can be viewed into the github code : DbConfig.java

Data source configuration for test:

Spring liquibase configuration for test :

Do not forget to disable hibernate DDL generation in hibernate properties as you can see in the Dbconfig:

ps.put("hibernate.hbm2ddl.auto", "none");

As we use liquibase for our schema definition and versioning .

Now how how we can trigger the DAO integration test and use that configuration in practice :

Where when you run the test from your IDEA , you should see the spring boot application is started properly and the docker image of the postgreSQL is started with liquibase changes applied so you can trigger your DAO integration test a production like situation .

The PostgreSQL docker image starting , off-course you need docker kernel installed in our machine to be able to test the same :

the docker image start for postgreSQL test container

And liquibase changes being applied as you can see in the console logs :

liquibase changes being applied for customer table

References :

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s