Missing Acceptance tests

[jason-johnson]

We currently do not have any acceptance tests. The reason is that what this provider does is to enable Azure AD authentication on an Azure SQL database. As we don't currently have a way to do this, we just don't do any tests.

Possible ways to do ACC tests:

• Azure account

  • set up free account
  • set up secrets/service principle on github for using this account
  • set up terraform resources to create the infrastructure for the tests
  • run tests
  • tear down infrastructure

• Docker containers

  • Gitactions support running services during a pipeline run
  • Run MS SQL instance as docker service
  • Run some kind of AD as a docker service
  • Set up the database to have an AD admin (or equivalent)
  • ACC tests will ensure they can cause a user to authenticate against the MS SQL instance

Issues with Docker containers approach

• Can the containerised MS SQL be made to do AD authentication against a containerised solution (e.g. LDAP)?
• Are the SQL commands the same even if this can be done?
• Even if the above can be done, will this use too many resources for a free github account?

[jason-johnson]

We now have a test which can be run when locally developing by setting some variables. If these variables are not present the test is skipped.