Replace api.trans() with api.new_store()

Implement __enter__/__exit__ on StoqlibStore instead.
Update tests and callsites.

Change-Id: I6c61caa7aaf5854a63ad13903c85d99b47c48d16