transation and unit testing for get method is implemented