got transactions and test working
adding more comprehensive test function for rollbacks and multiple transactions