Eliminating contextmanager based transaction-handling

To close #8277
this line should normally not be needed (all tables are dropped in `tearDown`)