Remove transaction.rollback() and use session fixture (#1117)

Remove transaction.rollback() and use session fixture (#1117) #150