Move database-layer endpoints to API

[AndreasHuber]

https://github.com/serlo/api.serlo.org/pull/1234 already provided the database access to the API gateway and as an example moved a first endpoint, UserSetDescriptionMutation, to the API gateway. Now the other endpoints can be moved in similar fashion. The goal of this is to reduce complexity, as the separation in different services with different programming languages has not added a lot of advantage.

• [x] namespace user
  • [x] ActiveAuthorsQuery (almost done, test has to be fixed before stop using db layer)
  • [x] ActiveReviewersQuery -> https://github.com/serlo/api.serlo.org/pull/1572
  • [x] ActivityByTypeQuery -> https://github.com/serlo/api.serlo.org/pull/1572
  • [x] UserAddRoleMutation -> https://github.com/serlo/api.serlo.org/pull/1518
  • [x] UserPotentialSpamUsersQuery -> https://github.com/serlo/api.serlo.org/pull/1572
  • [x] UserCreateMutation -> https://github.com/serlo/api.serlo.org/pull/1570
  • [x] UserDeleteBotsMutation
  • [x] UserDeleteRegularUsersMutation
  • [x] UsersByRoleQuery -> https://github.com/serlo/api.serlo.org/pull/1572
  • [x] UserSetDescriptionMutation
  • [x] UserRemoveRoleMutation
  • [x] UserSetEmailMutation -> https://github.com/serlo/api.serlo.org/pull/1480
  • [x] UuidQuery (user) -> https://github.com/serlo/api.serlo.org/issues/1417
• [x] general / uuid namespace
  • [x] AliasQuery -> https://github.com/serlo/api.serlo.org/pull/1573
  • [x] DeletedEntitiesQuery -> https://github.com/serlo/api.serlo.org/pull/1592
  • [x] https://github.com/serlo/api.serlo.org/pull/1468
• [x] EntitiesMetadataQuery
• [x] Entity namespace:
  • [x] EntityAddRevisionMutation -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] EntityCheckoutRevisionMutation -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] EntityRejectRevisionMutation -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] EntityCreateMutation -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] EntitySetLicenseMutation -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] ~EntitySortMutation~ Is not needed after https://github.com/serlo/db-migrations/issues/338
  • [x] UnrevisedEntitiesQuery -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] UuidQuery (Entity) -> https://github.com/serlo/api.serlo.org/pull/1469
  • [x] UuidQuery (Revision) -> https://github.com/serlo/api.serlo.org/pull/1469
• [x] events / notifications:
  • [x] EventsQuery
  • [x] NotificationsQuery
  • [x] NotificationSetStateMutation
  • [x] delete endpoint notificationEvent, see https://github.com/serlo/api.serlo.org/issues/1454
• [x] page namespace via https://github.com/serlo/api.serlo.org/issues/1556
  • [x] PageAddRevisionMutation -> https://github.com/serlo/api.serlo.org/pull/1586
  • [x] PageCheckoutRevisionMutation -> https://github.com/serlo/api.serlo.org/pull/1586
  • [x] PageRejectRevisionMutation -> https://github.com/serlo/api.serlo.org/pull/1586
  • [x] PageCreateMutation -> https://github.com/serlo/api.serlo.org/pull/1586
  • [x] PagesQuery -> https://github.com/serlo/api.serlo.org/pull/1586
  • [x] UuidQuery (Page) -> https://github.com/serlo/api.serlo.org/pull/1586
  • [x] UuidQuery (PageRevision) -> https://github.com/serlo/api.serlo.org/pull/1586
• [x] subjects:
  • [x] SubjectsQuery
• [x] https://github.com/serlo/api.serlo.org/pull/1520
• [x] taxonomy namespace:
  • [x] https://github.com/serlo/api.serlo.org/pull/1460
  • [x] https://github.com/serlo/api.serlo.org/pull/1467
  • [x] https://github.com/serlo/api.serlo.org/pull/1466
  • [x] https://github.com/serlo/api.serlo.org/pull/1458
  • [x] https://github.com/serlo/api.serlo.org/pull/1456
  • [x] https://github.com/serlo/api.serlo.org/pull/1465
• [x] threads namespace:
  • [x] ThreadCreateCommentMutation -> https://github.com/serlo/api.serlo.org/pull/1528
  • [x] ThreadCreateThreadMutation -> https://github.com/serlo/api.serlo.org/pull/1528
  • [x] ThreadEditCommentMutation
  • [x] ThreadSetThreadArchivedMutation -> https://github.com/serlo/api.serlo.org/pull/1527
  • [x] ThreadSetThreadStatusMutation
  • [x] ThreadsQuery -> https://github.com/serlo/api.serlo.org/pull/1527
  • [x] UuidQuery (comment)

See https://github.com/serlo/api.serlo.org/blob/staging/packages/server/src/model/database-layer.ts

[hugotiburtino]

Completed