@vrajat doubt about test:
If we try to connect server, without migrating and setting up the table , the connection wont be created, since there is no data in db. But if we do migration before using flyway, then we wont be able to check if server succesfully ran the migration or not.
So, what I think is, we can call DriverManager.connect in a try/catch block and catch the error, since there is no data in db it is bound to fail when we create DataSourceSchema. But Migration would have run by then and we can test the schema-version table.
is the approach ok?