Rollback database transaction after each test

What currently happens after each test that uses the database:

• Close all database sessions
• Drop all tables in a new session
• Create all tables in a new session

Preferably we would want to use a single session for all the tests, as this would greatly speed up the tests. This can be achieved by:

• Using a single database session for all tests
• Start a transaction before each test
• Rollback transaction after test