Eliminating contextmanager based transaction-handling

To close #8277
This is not needed anymore I think? (TestMySQLLegacy inherits from TestSQLiteLegacy)