How to test database records using Flyway in spring framewrok using in-memory Database

Channel:
Poland Status Code
Subscribers:
10,800
Published on ● Video Link: https://www.youtube.com/watch?v=VyQxe9mVQJc


Category:
Guide
Duration: 42:20
1,171 views
14

Testing Database using Flyway migration library.

Testing your data base without touching Your original data by using an in-memory Database such as Embedded PostgreSQL, also using flyway to migrate the SQL script to the databases, by this way you are guaranteeing the integrity of your data inside your production or your main database, that is because all of your tests are going to be in-memory database.

In this video I am explaining the concept of using in-memory database to test your Data Access Object DAO, I have explained according to my current experience and knowledge, hope it will be benefits for you.

Library used;
- Spring core - Spring Beans
- Spring context - Spring JDBC
- Spring test -PG Embedded
- Flyway

Find the Project on GitHub
https://github.com/JAVA-MSDT/FlywayDatabaseTest



Other Videos By Status Code


2020-02-01الجهل وانواعه
2020-01-03Sabdbag kicks
2019-11-1207 –المصفوفه بالجافا (Array) و for-loop
2019-11-0703 - Object Oriented Programming (OOP) { Inheritance } {Arabic}
2019-11-0405 – java methods and constructor
2019-11-0304 - variables in java المتغيير بالجافا
2019-11-0303 - مقدمه سريعه عن محتويات الكلاس فى الجافا
2019-11-0202 - المجلد PACKAGE
2019-11-0201 - ماهى لغه البرمجه ولماذا جافا وماذا بعد؟
2019-10-2702 - Object Oriented Programming (OOP) { Encapsulation } {Arabic}
2019-10-26How to test database records using Flyway in spring framewrok using in-memory Database
2019-01-031 - How To Sort Array {Jagged } In Java
2018-08-16EPAM 13_JScratch____Class 11 part 1 --- 16/08/2018
2018-08-16EPAM 13_JScratch____Class 11 part 2 --- 16/08/2018
2018-08-15EPAM 13_JScratch____Class 10 13/08/2018
2018-08-09EPAM 13_JScratch____Class 9 part 2 --- 09/08/2018
2018-08-09EPAM 13_JScratch____Class 9 part 1 --- 09/08/2018
2018-08-06EPAM 13_JScratch____Class 8 --- 30/07/2018
2018-08-03EPAM 13_JScratch____Class 7 --- 30/07/2018
2018-07-26EPAM 13_JScratch____Class 6 --- 26/07/2018
2018-07-23EPAM 13_JScratch____Class 5 _Part 2 ---- 23/07/2018


Tags:
flyway
spring core
Spring Beans
Spring JDBC
Spring context
Spring test
PG Embedded
database
sql
postgres
postgreql
github
project
idea
maven
pom
configuration
repository
dao
mvc
otj-pg-embedded
org.flywaydb
in-memory Database
SQL
script
migrate
Embedded
Embedded PostgreSQL
Flyway migration
How to test database
spring framewrok
SQL script