testing mysql etl using java and junit tests

Question

I would like to test an etl process I have built out in java to load data up in mysql. Basically I would like to create an in memory database of mysql and then load data then run queries against it to make sure I have what I think I have. What is the current best practice for doing this? Thanks!

Community · Accepted Answer · 2017-05-23 12:15:47Z

2

There are a already a bunch of related questions and answers, but I will share what I did for myself: using jcabi. It's not in-memory , but it starts a real live mysql instance and tears it down after the test. Another thing: you would then have integration test for this, not unit test. Read about the difference and see if you like this.

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jun 10, 2014 at 14:33

dr0i

2,5502 gold badges21 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

testing mysql etl using java and junit tests

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related