Move database-layer endpoints to API

[AndreasHuber]

#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.

• namespace user
  • ActiveAuthorsQuery (almost done, test has to be fixed before stop using db layer)
  • ActiveReviewersQuery -> migrate user queries from database-layer into resolvers #1572
  • ActivityByTypeQuery -> migrate user queries from database-layer into resolvers #1572
  • UserAddRoleMutation -> Migrate add role incl. user description bugfix and test updates #1518
  • UserPotentialSpamUsersQuery -> migrate user queries from database-layer into resolvers #1572
  • UserCreateMutation -> migrate UserCreateMigration from database-layer into api.serlo.org #1570
  • UserDeleteBotsMutation
  • UserDeleteRegularUsersMutation
  • UsersByRoleQuery -> migrate user queries from database-layer into resolvers #1572
  • UserSetDescriptionMutation
  • UserRemoveRoleMutation
  • UserSetEmailMutation -> Migrate setEmail #1480
  • UuidQuery (user) -> make resolveUuidFromDatabase also return users #1417
• general / uuid namespace
  • AliasQuery -> refactor(uuid): Replace AliasQuery with MYSQL query #1573
  • DeletedEntitiesQuery -> refactor(deleted-entities): Migrate to SQL query #1592
  • refactor(uuid): Replace UuidSetState with SQL #1468
• EntitiesMetadataQuery
• Entity namespace:
  • EntityAddRevisionMutation -> refactor: Migrate DB-Layer into entity namespace #1469
  • EntityCheckoutRevisionMutation -> refactor: Migrate DB-Layer into entity namespace #1469
  • EntityRejectRevisionMutation -> refactor: Migrate DB-Layer into entity namespace #1469
  • EntityCreateMutation -> refactor: Migrate DB-Layer into entity namespace #1469
  • EntitySetLicenseMutation -> refactor: Migrate DB-Layer into entity namespace #1469
  • EntitySortMutation Is not needed after Move CoursePages into Course (first step) db-migrations#338
  • UnrevisedEntitiesQuery -> refactor: Migrate DB-Layer into entity namespace #1469
  • UuidQuery (Entity) -> refactor: Migrate DB-Layer into entity namespace #1469
  • UuidQuery (Revision) -> refactor: Migrate DB-Layer into entity namespace #1469
• events / notifications:
  • EventsQuery
  • NotificationsQuery
  • NotificationSetStateMutation
  • delete endpoint notificationEvent, see Remove endpoint notificationEvent #1454
• page namespace via Merge static pages into entities #1556
  • PageAddRevisionMutation -> feat: Move static pages into entity namespace #1586
  • PageCheckoutRevisionMutation -> feat: Move static pages into entity namespace #1586
  • PageRejectRevisionMutation -> feat: Move static pages into entity namespace #1586
  • PageCreateMutation -> feat: Move static pages into entity namespace #1586
  • PagesQuery -> feat: Move static pages into entity namespace #1586
  • UuidQuery (Page) -> feat: Move static pages into entity namespace #1586
  • UuidQuery (PageRevision) -> feat: Move static pages into entity namespace #1586
• subjects:
  • SubjectsQuery
• refactor(subscription): Add SQL to subscriptions #1520
• taxonomy namespace:
  • refactor(taxonomy): Move SQL for creating taxonomies #1460
  • refactor(taxonomy): Move SQL into taxonomy.createEntityLinks() #1467
  • refactor(taxonomy): Add SQL to taxonomy.deleteEntityLink() #1466
  • refactor(taxonomy): Add SQL for TaxonomySetNameAndDescription #1458
  • refactor: Move taxonomy to uuid query #1456
  • refactor(taxonomy): Add SQL for sort taxonomies #1465
• threads namespace:
  • ThreadCreateCommentMutation -> refactor(thread): Add SQL for create threads and comments #1528
  • ThreadCreateThreadMutation -> refactor(thread): Add SQL for create threads and comments #1528
  • ThreadEditCommentMutation
  • ThreadSetThreadArchivedMutation -> refactor(thread): Add SQL for ThreadQuery and set-thread-archived #1527
  • ThreadSetThreadStatusMutation
  • ThreadsQuery -> refactor(thread): Add SQL for ThreadQuery and set-thread-archived #1527
  • UuidQuery (comment)

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

[hugotiburtino]

Completed