Moved transaction-related tests to the StorageEngineTest class

As requested, this PR moves the test code related to transactions to the StorageEngineTest.