Make content_add validate its input using swh-model.

The initial goal of this commit was to make the in-mem content_add raise
errors on input that would make postgresql error.

As a side-effect, the pgsql content_add now validate its input as well,
so clients get a nice/meaningful error instead of postgresql's error.