❔ Which database for integration test using db transactions
Hi there,
I am coding my integration test project.
And I want to test the transactionnal aspect of two functions called.
I installed sqllite inmemory on my project. And set it in memory
I well mocked my the last function called before the commit and do a
But I get a "no such table : Buy" when I run my test. I don't understand why I will have to do migration on a inmemory database. For me, it's a no-sense.
So, what do you advise me to use for my test ? in prod I use sql server
I am coding my integration test project.
And I want to test the transactionnal aspect of two functions called.
I installed sqllite inmemory on my project. And set it in memory
I well mocked my the last function called before the commit and do a
.throw(new Exception());context.rollbackTransaction()But I get a "no such table : Buy" when I run my test. I don't understand why I will have to do migration on a inmemory database. For me, it's a no-sense.
So, what do you advise me to use for my test ? in prod I use sql server
