spring-boot-restful | git @ github.com | Security Framework library

I have followed https://dzone.com/articles/spring-boot-restful-api-documentation-with-swagger and developing the Swagger using the springfox-swagger-ui and springfox-swagger2 version 2.9.2.

I used the below configurations, but I want module-name to be printed out here. Also, @Api(tags = "User Catalouge", description = "List Of Users"), description is deprecated.

I followed this tutorial https://springframework.guru/spring-boot-restful-api-documentation-with-swagger-2/ to generate a swagger documentation. It's working but when I try to add some validation in my bean I don't find the information in the documentation:

I am somewhat new to Spring Boot and for learning purposes, I wrote a simple REST API using an in-memory database (H2).

Everything works fine when I actually run the application: the database is loaded into memory and populated using an import.sql file I provided, my endpoints do what they are supposed to do. Now I´m trying to write a controller test that is supposed to call a "find stuff by id" endpoint. Here lies the problem: when I run this test, it doesn't find any entry in the database and fails, i.e., it seems my database has not been populated on startup. I don´t know what´s happening because, as I said, when I actually run the application and test it using Postman, everything is on memory and works as intended.

What should I do in order to get my database properly populated in a testing scenario?

Just for reference, I´ve read this article (very useful btw) and there, although he uses an alternative approach to populate his database, he doesn't do anything special regarding his testing needs. Everything runs fine both using Postman and when testing. This is what I try to accomplish.

Any help would be truly appreciated. I´ve done a lot of research, tried a lot of things, but to no avail.

These are the files I assume are relevant:

** my application.properties under /scr/main/resources