I am writing a tsqlt unit testing where I am not faking the table and I am using the real SQL table ex:sendEmail to test the email sending functionality.
I am inserting the value like below from tsqlt to the sendEmail table
Email: '[email protected]'
Status : 0
Template : 'New User Creation'
There is an automation job outside of tsqlt that will look for these table entries which have Status :0 process the email to the sender address and update back to the table's column value as Status:1
But I am not seeing the automation job is able to do success with email sending during this tsqlt regression scenario. Can't we access the SQL table and its value outside use when tsqlt is running? Any guidance would be highly appreciated.
tSqlt will be running only in the isolated way and can't integrate with any other code or application?