Fix User#by_username_or_id for postgres

Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
Fix more confirm deprecations

Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
Fix UserProject obserse spec

Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>