Add tox-based Integration Testing support for this package

emmyoop commented 2 months ago

dbt Labs is running integration tests for popular open source packages as part of continuous testing and release of dbt.

Add support for testing this package using tox, as described in Standardizing integration tests for popular dbt packages.

Tests reside in the /integration_tests directory.
Supported adapters are defined in supported_adapters.env at the project root. The variable SUPPORTED_ADAPTERS lists the supported adapters, separated by commas. (Note: Only adapters running in dbt Cloud are currently supported.)
tox is used for running tests.
Each adapter test is defined in the tox.ini file using the naming pattern testenv:dbt_integration_<ADAPTER>.
The profiles.yml for integration tests uses specific naming conventions for the target and environment variables. Examples can be found in dbt-package-testing.

This change will enable:

dbt Labs to test this package, ensuring that dbt Cloud customers can confidently receive continuous dbt updates ("Versionless")
dbt Labs to proactively identify any incompatibilities or functional regressions before they are released in final versions of dbt Core OSS.
Package maintainers to consistently test changes in the same manner as dbt Labs will test new releases.

dbt Labs will commence running tests only after the new tests have been released and are available in the latest package version on the hub.

clausherther commented 2 months ago

Thanks for the head up @emmyoop. Will you also be pushing a PR for these changes on both packages?

jtcohen6 commented 2 months ago

@clausherther I've just opened:

Let me know what you think - happy to incorporate suggested changes.

(Thanks @emmyoop for helping me get set up!)

calogica / dbt-expectations