Test prompting DB password
We need a unit test that allows us to check if there is a prompt for the database password if it is not provided.
It requires refactoring the code to encapsulate the IsRunningInTerminal
and GetSecretInTerminal
method calls with an interface to allow mock their returns.