Introduce countRowsInTableWhere() and dropTables() in abstract transactional base classes in the TestContext framework [SPR-9665]

[spring-projects-issues]

Sam Brannen opened SPR-9665 and commented

Impetus

Due to the changes introduced in #13873 and #13630, we should introduce countRowsInTableWhere() and dropTables() convenience methods in the abstract transactional base classes in the TestContext framework

---

Deliverables

1. Introduce countRowsInTableWhere() and dropTables() convenience methods in:
   • AbstractTransactionalJUnit4SpringContextTests
   • AbstractTransactionalTestNGSpringContextTests
2. Update the changelog

---

Issue Links:

• Provide JdbcTemplate in abstract transactional base classes in the TestContext framework [SPR-8990] #13630 Provide JdbcTemplate in abstract transactional base classes in the TestContext framework ("depends on")
• Deprecate SimpleJdbcTestUtils in favor of JdbcTestUtils [SPR-9235] #13873 Deprecate SimpleJdbcTestUtils in favor of JdbcTestUtils ("depends on")

Referenced from: commits 015086c

[spring-projects-issues]

Sam Brannen commented

Completed as described in the Deliverables and in the comments for GitHub commit 015086cb9c:

Introduce new methods in tx base test classes

Recently new utility methods were added to JdbcTestUtils, and a
JdbcTemplate was introduced in abstract transactional base classes in
the TestContext framework. This presents an easy opportunity to make
these new utility methods available as convenience methods in the base
test classes.

This commit introduces new countRowsInTableWhere() and dropTables()
convenience methods in the abstract transactional base classes in the
TestContext framework. These new methods internally delegate to methods
of the same names in JdbcTestUtils.