Spring Boot Testing Mini-Series Part #3: Database Tests

[@rajkrishna1933]

your videos on testing related code is amazing.frankly there are mo much actual hands on spring test on youtube.please make more such videos

[@codewitharho]

Much appreciated!

[@jesper7605]

Great content! You cover several useful things I've never heard someone talk about before.

[@codewitharho]

Thank you!

[@robinmathur5807]

Very clear explanation. After spending many hours finally found a good playlist on this topic. Great job man.

[@codewitharho]

Thank you, always glad when someone finds it useful!

[@cloudsquall88]

As always, amazing explanations! Thank you so much!

[@codewitharho]

Thanks, really means a lot that people find it useful!

[@gallanonim4914]

Arho - you provide wonderful content, great job 💪 Is there any chance to see new videos from you?

[@codewitharho]

Thank you! I should eventually get back to it - currently in the middle of moving places and renovations.

[@MrVitalirapalis]

Good music, man :) the content as well

[@codewitharho]

Thank you!

[@FadiQua]

Nice! Thank you for the tutorial

[@codewitharho]

I’m glad you found it useful.

[@pryflack3646]

Best presentation of Spring I've seen so far, thanks and please keep them coming! How would you stay with an SQL test script, and deal with deep hierarchies requiring foreign keys all the way up? I'd love to hear about the object mother pattern. PS: it's pronounced "skeema" not shama ;)

[@codewitharho]

Thanks! And also thank you for the pronunciation tip :D I try to avoid deep hierarchies but I understand that sometimes you need more complex data. I would look at Database Rider for more complex data setup. There's a little bit of information about the test data builder and object mother in the DRY vs DAMP video I made: kzbin.info/www/bejne/mXWXhZunndN0ppI (although I'm considering a separate video about those patterns).

[@pryflack3646]

Thanks I’ll have a look at database rider. I’m still a little unclear about the object mother pattern so I’ll be on the lookout then ;) I very much enjoy your channel, keep up the great work!

[@fotistsavalos2193]

Nice series and great job!! Thank you!!

[@codewitharho]

Thank you and you're welcome!

[@AndrulisTravel]

Your videos are very good. Just my suggestion. Create a simple Rest API model/repository/service/controller with the basic post, put, get methods and a little bit of logic in the service layer (check if email exists, etc.). And then write tests. I understand that this will require time, but a full detailed video will have much more views from beginners.

[@codewitharho]

In my testing videos I’m currently assuming some basic knowledge about Spring. But I’ll keep in mind that there could be demand for some beginner Spring tutorials as well. Thanks for the suggestion!

[@AndrulisTravel]

@@codewitharho Thanks for the replay. The idea was not to show how to create a Spring Boot app, but how to test it. You could use the already prepared app with 4 standard endpoints and some logic in the service layer. One entity and a repository. And show how to write all tests for this simple app :) It would cover all the basics in one video.

[@codewitharho]

Ah, I see. Actually, I have an overview video planned for the series. The reason that it is a series of smaller videos is that it takes a lot of time to make them and I wanted to see if they attract any interest. Will definitely consider a longer tutorial in the future! Thanks again for the feedback!

[@hypnoticlizard9693]

@@codewitharho I think these videos are great but I dont think they have mainstream appeal as they are on a niche subject. You should set up some kind of donation link so you can get supported by the few people who benefit from these videos. As that will allow you to make great content even if the viewership isnt very high. I appreciate the efforts to make these videos.

[@rajkrishna1933]

protobuf with rest api java is a topic which has limited resources in youtube.if you can,please add videos on this topic too..

[@codewitharho]

That’s quite a specific topic and unfortunately don’t have experience on.

[@hendisantika]

How do we mix testcontainers, mysql & flyway? Do You have article about that? Thanks

[@codewitharho]

I don’t have an article about MySQL specifically but you should be able to follow the article that uses Postgres and just replace the Postgres image with a MySQL image.

[@MrNoxior]

Why do you use an EntityManager in the tests? Isn't it better to use an injected repository?

[@codewitharho]

TestEntityManager helps you to test the full cycle of storing and retrieving the entity, e.g. flush the persistence context cache and then read the entity from the database. Otherwise the test could just end up reading from in-memory cache.

[@tko1176]

When you remove the flush part, when does the flush occurs to make fail the test again? 14:36

[@codewitharho]

It fails because it doesn't flush. Without specifically flushing it's up to the framework to do the flushing and we have no control of when that happens. The constraint check only happens on the database level after the flush.

[@tko1176]

@@codewitharho I understand. Thank you.

[@kalyankasyapgarimella1047]

Test Containers using private registry url images??? Can we have a video on this

[@codewitharho]

Thanks for the suggestion! It’s a very specific question and making these videos takes quite a lot of time, so I’d suggest asking in stackoverflow.com

[@ductamnguyen8257]

Hi Arho, hope you're doing well. Do you know about Database Migration? and do you how to Unit Testing for Database Migration? Thanks in advance.

[@codewitharho]

I’m not sure what you mean. I went briefly through the migrations in the video. What kind of information are you after?

[@ductamnguyen8257]

@@codewitharho Thanks for your reply, yes you have gone briefly through database Migration.

[@sohrabsheykhmohammadi1909]

thank you so much

[@codewitharho]

You’re welcome!

[@rajkrishna1933]

your videos on testing related code is amazing.frankly there are mo much actual hands on spring test on youtube.please make more such videos

[@codewitharho]

Thanks, I appreciate that a lot! I have been struggling to find a good work life balance and am currently trying to arrange things so that I can focus more on this channel.