Convert explicit session get/begin to transaction context

Convert the explicit common.sql.get_session() and subsequent
session.begin() to the transaction context manager for Trust
SQL backend.

Change-Id: I52745118782301ef26452063628e16e92e8ee276
Merge "Convert explicit session get/begin to transaction context"