TTC
Theo's Typesafe Cultiboughtbed

Next Auth Drizzle Adapter does not include extra columns (fields)

auth.ts 
providers: [
    GoogleProvider({
      clientId: env.GOOGLE_CLIENT_ID,
      clientSecret: env.GOOGLE_CLIENT_SECRET,
      profile(profile: GoogleProfile) {
        return {
          id: profile.sub,
          name: profile.name,
          email: profile.email,
          image: profile.picture,
          username: removeEmailDomain(profile.email) ?? profile.email,
        };
      },
    }),
providers: [
    GoogleProvider({
      clientId: env.GOOGLE_CLIENT_ID,
      clientSecret: env.GOOGLE_CLIENT_SECRET,
      profile(profile: GoogleProfile) {
        return {
          id: profile.sub,
          name: profile.name,
          email: profile.email,
          image: profile.picture,
          username: removeEmailDomain(profile.email) ?? profile.email,
        };
      },
    }),
I have a schema for the user table with username field. When I try to add the username field in the profile callback as initial data for user creation, the Drizzle adapter doesn't include the username field, and instead returns default fields only. Is there a way to fix this?
Solution
I
iboughtbed•13d ago
Found a workaround: https://github.com/nextauthjs/next-auth/pull/8561 auth.ts 
export const authOptions {
...
  adapter: {
    ...(DrizzleAdapter(db, createTable) as Adapter),
    // @ts-expect-error drizzle adapter does not include extra columns
    async createUser(data) {
      return await db
        .insert(users)
        .values({ ...data, id: crypto.randomUUID() })
        .returning()
        .then((res) => res[0] ?? null);
    },
  },
export const authOptions {
...
  adapter: {
    ...(DrizzleAdapter(db, createTable) as Adapter),
    // @ts-expect-error drizzle adapter does not include extra columns
    async createUser(data) {
      return await db
        .insert(users)
        .values({ ...data, id: crypto.randomUUID() })
        .returning()
        .then((res) => res[0] ?? null);
    },
  },
GitHub
feat(adapter-drizzle): add option to pass in schema by juliusmarmin...
☕️ Reasoning In other adapters, the adapter returns the entire table so if you have additional fields they will also be returned when the adapter queries the table. A good example here is if your ...
Want results from more Discord servers?
Add your server
More Posts
useUploadthing hook is slowHi, I recently started using Uploadthing. My use case involves attaching images to messages in my chCaching getSignedUrl without DB?In my tRPC using app, I store image files on Cloudflare R2. The client browse these images by listiVercel and Cloudflare DDoS protectionHello! I have a question, If I host my site on vercel and put static files on the site like logo orSystemError [ERR_TTY_INIT_FAILED]: TTY initialization failed: uv_tty_init returned EINVAL (invalid aI cloned create t3 app locally, then I tried to run it locally by first running pnpm install then pnAnimating a background moving between grid elementsI made this simple switch but I wanna animate the background moving from left to right instead of haIs Theo's new tutorial any good for a Vue Dev?Truth be told I have never touched React or any .tsx before. However I have been doing vue for the lEmail exist verificationdoes anyone knows a way to verify if an email exists? like is there such a package or services with Issues with Clerk and Unit testingI am working on a project for work and we have a strict requirement for unit tests. I decided to go