A GraphQL API built with prisma with subscriptions for basic CRUD mutations

This example uses the following packages:

• @pothos/core: For building the schema
• @pothos/plugin-prisma: For prisma based type definitions, and efficient queries
• @prisma/client: For querying data from a database
• prisma: For running migrations and generating @prisma/client
• graphql-yoga: For creating a server that executes the schema

This is a fairly basic implementation, and may not represent best practices for production, but should help demonstrate how subscriptions could be implemented.

Schema

1type Comment {
2  author: User!
3  comment: String!
4  id: ID!
5  post: Post!
6}
7
8type Mutation {
9  createPost(authorId: ID!, content: String!, title: String!): Post!
10  createUser(firstName: String!, lastName: String!): User!
11  deletePost(id: ID!): Post
12  deleteUser(id: ID!): User
13  updatePost(content: String, id: ID!, title: String): Post
14  updateUser(firstName: String, id: ID!, lastName: String): User
15}
16
17enum MutationType {
18  CREATED
19  DELETED
20  UPDATED
21}
22
23type Post {
24  author: User!
25  comments: [Comment!]!
26  content: String!
27  id: ID!
28  title: String!
29}
30
31type Query {
32  post(id: ID!): Post
33  posts(skip: Int, take: Int): [Post!]!
34  user(id: ID!): User
35}
36
37type Subscription {
38  post(id: ID!): SubscriptionPostEvent
39  posts: SubscriptionPostEvent!
40  user(id: ID!): SubscriptionUserEvent
41  users: SubscriptionUserEvent!
42}
43
44interface SubscriptionEvent {
45  mutationType: String!
46}
47
48type SubscriptionPostEvent implements SubscriptionEvent {
49  mutationType: String!
50  post: Post
51}
52
53type SubscriptionUserEvent implements SubscriptionEvent {
54  mutationType: String!
55  user: User
56}
57
58type User {
59  comments: [Comment!]!
60  firstName: String!
61  fullName: String!
62  id: ID!
63  lastName: String!
64  posts: [Post!]!
65}