Extending Database with more tables

[yannickgloster]

How do I extend the database to have another table

I'm creating groups of users and am trying to create a database that contains groups and another one that has list of users connected to a groups

Feedback

• Found the documentation helpful
• Found documentation but was incomplete
• Could not find relevant documentation
• Found the example project helpful
• Did not find the example project helpful

[j-lee8]

Is it possible to intercept the database user insert and add additional fields? I'm using Prisma2 and have additional columns and I need to populate these on sign up.

[yannickgloster]

I managed to do this by using the JWT callback. I'm not sure that this is the correct way to do it though.

  callbacks: {
    async jwt(token, user, account, profile, isNewUser) {
      if (isNewUser) {
        try {
          const folder = await axios.post(
            "https://www.googleapis.com/drive/v3/files",
            {
              name: "SECURE",
              mimeType: "application/vnd.google-apps.folder",
            },
            {
              headers: {
                authorization: "Bearer " + account.accessToken,
              },
            }
          );
          await prisma.user.update({
            where: { id: user.id },
            data: { folderID: folder.data.id },
          });
        } catch (error) {
          console.log(error);
          console.log("Couldn't create folder");
        }
      }
      // Add access_token to the token right after signin
      if (account?.accessToken) {
        token.accessToken = account.accessToken;
      }

      return token;
    }

You could also maybe use the creatUser event:

  events: {
    async createUser(message) {},
  }

It all just depends where you get that information from.

Probably the most correct way would be to fork the prisma database adapter and change the onSignup function.

[xcaeser]

the events is the right answer, thank you!

[yannickgloster]

I was able to do this by switching to using Prisma instead of TypeORM which allowed me to define my DB schema.