Make TitleMoveComplete hook events apply in transactions

Make TitleMoveComplete hook events apply in transactions

* All updates for an event are atomic for the main DB.
* This follows-up 9e51328790c0a by reverting the auto-commit
  behavoir which was a side-effect of that change.
* Added TitleMoveCompleting hook with is a pre-commit version
  of the same hook. Various extension could benefit from the
  atomicity of running in the main transaction.

Change-Id: Ife5990bbedca1de78bcf83f2d6fdeeae8086ffad