test(api): Clear cache before counting number of queries

[ERosendo]

This PR addresses a flaky test identified in issue #4624. The test was failing because the number of database queries was lower than expected.

Django's caching mechanism can sometimes reduce the number of database queries, leading to unexpected results. To resolve this, we've implemented a solution suggested in Django tickets #11505 and #23746. By clearing the cache before counting the queries, we ensure accurate results and prevent the test from failing.

Since applying this fix, the test has been consistently passing.

Links:

• #11505 - Django's TestCase should reset the cache
• #23746 - Allow assertNumQueries to clear caches before it runs

[mlissner]

This one meant to still be a draft?

[ERosendo]

sorry @mlissner, I thought I'd marked the PR as ready for review

[mlissner]

Thank you. Fun stuff.