fixed transaction function

can't delete soda after transaction because then it would cascade down
and delete the SodaTransaction whose foreign key it's connected to