802dfa0703
* Add sort within inner query * Run tests for all vendors * Apply limit to all queries * Enable sorting in MSSQL subquery by setting a limit * Add tests * Parse function field names for a2o * Improve order string spacing * Update unit test * Fix mysql5 tests * Revert testing for all vendors * Extract original collection name * Add comment for MSSQL applyLimit helper Co-authored-by: Brainslug <br41nslug@users.noreply.github.com>
Blackbox tests
Setup
Make sure the containers for the databases are running by running docker compose up -d in this folder.
Running tests locally
Run npm run test:blackbox to run the blackbox tests for every supported database vendor.
Testing a specific database
Provide a csv of database drivers in the TEST_DB environment variable to test specific databases:
TEST_DB=cockroachdb npm run test:blackbox
Using an existing Directus instance
The test suite will spin up a fresh copy of the Directus API from the current build. To use an already running copy of
Directus, set the TEST_LOCAL flag:
TEST_DB=cockroachdb TEST_LOCAL=true npm run test:blackbox
This will use 127.0.0.1:8055 as the URL for every test. Note: make sure to connect your local Directus database
instance to the test database container found in docker-compose in this folder.
Watching for (test) changes
Use npm run test:blackbox:watch to enable Jest's --watch mode, especially useful in combination with the flags
above.
This does not watch changes to Directus; it only watches changes to the tests.