Better Auth•2mo ago

How to create new user using drizzle to better-auth users schema

hey, im using tRPC, drizzle and better auth to handle my authentication , i want admin to be able to add new users to the system

export async function getAllUsers() {
  return await db.select().from(user);
}

export async function getAllUsers() {
  return await db.select().from(user);
}

// Add a new user //there is an error here !!

export async function addUser(name: string, email: string) {
  return await db.insert(user).values({ name, email, emailVerified: false });
}

export async function addUser(name: string, email: string) {
  return await db.insert(user).values({ name, email, emailVerified: false });
}

but im facing this error in the screenshot, im not sure if this is the right way to do it

23 Replies

j_slno•2mo ago

you're missing setting the id Also why not just use the admin plugin?

codecret | Software EngineerOP•2mo ago

i was thinking of this but it sounded weird because i had to call authclient inside my trpc route? im not sure if it's the right approach or not

const newUser = await authClient.admin.createUser({
  name: "Test User",
  email: "[email protected]",
  password: "password123",
  role: "user",
  data: {
    // any additional on the user table including plugin fields and custom fields
    customField: "customValue"
  }
});

const newUser = await authClient.admin.createUser({
  name: "Test User",
  email: "[email protected]",
  password: "password123",
  role: "user",
  data: {
    // any additional on the user table including plugin fields and custom fields
    customField: "customValue"
  }
});

j_slno•2mo ago

its basically just a fetch. so it works client and server side but you could also call it from auth.api

Unknown User•2mo ago

Message Not Public

codecret | Software EngineerOP•2mo ago

i still dont understand why such an error occurs

export const userRouter = router({
  getUsers: publicProcedure.query(async () => {
    return getAllUsers();
  }),
  addUser: publicProcedure
    .input(
      z.object({
        username: z.string(),
        name: z.string(),
        email: z.string().email(),
        password: z.string().min(8),
        role: z.string().optional(),
      })
    )
    .mutation(async ({ username, name, email, password, role }: User) => {
      // Your logic to add a user
      const newUser = await auth.api.createUser({
        body: {
          username,
          name,
          email,
          password,
          role,
        },
      });
      return newUser;
    }),
});

export const userRouter = router({
  getUsers: publicProcedure.query(async () => {
    return getAllUsers();
  }),
  addUser: publicProcedure
    .input(
      z.object({
        username: z.string(),
        name: z.string(),
        email: z.string().email(),
        password: z.string().min(8),
        role: z.string().optional(),
      })
    )
    .mutation(async ({ username, name, email, password, role }: User) => {
      // Your logic to add a user
      const newUser = await auth.api.createUser({
        body: {
          username,
          name,
          email,
          password,
          role,
        },
      });
      return newUser;
    }),
});

j_slno•2mo ago

role must be inside data

const newUser = await auth.api.createUser({
        body: {
          username,
          name,
          email,
          password,
          data: { role }
        },
      });

const newUser = await auth.api.createUser({
        body: {
          username,
          name,
          email,
          password,
          data: { role }
        },
      });

codecret | Software EngineerOP•2mo ago

Object literal may only specify known properties, and 'username' does not exist in type '{ password: string; email: string; name: string; role: string; data?: Record<string, any> | undefined; }'.ts(2353)

addUser: publicProcedure
    .input(
      z.object({
        username: z.string(),
        name: z.string(),
        email: z.string().email(),
        password: z.string().min(8),
        role: z.string().optional(),
      })
    )
    .mutation(async ({ input }) => {
      // Your logic to add a user
      const newUser = await auth.api.createUser({
        body: {
          username: input.username,
          name: input.name,
          email: input.email,
          password: input.password,
          data: {
            role: input.role,
          },
        },
      });
      return newUser;
    }),

addUser: publicProcedure
    .input(
      z.object({
        username: z.string(),
        name: z.string(),
        email: z.string().email(),
        password: z.string().min(8),
        role: z.string().optional(),
      })
    )
    .mutation(async ({ input }) => {
      // Your logic to add a user
      const newUser = await auth.api.createUser({
        body: {
          username: input.username,
          name: input.name,
          email: input.email,
          password: input.password,
          data: {
            role: input.role,
          },
        },
      });
      return newUser;
    }),

j_slno•2mo ago

body doesnt take in username do u use the username plugin? try also adding it to data

codecret | Software EngineerOP•2mo ago

export const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "pg",
    schema: { user, account, session, verification },
  }),
  user: {
    additionalFields: {
      role: {
        type: ["admin", "user"],
      },
    },
  },
  plugins: [username(), admin(), nextCookies()],
  emailAndPassword: {
    enabled: true,
  },
});

export const auth = betterAuth({
  database: drizzleAdapter(db, {
    provider: "pg",
    schema: { user, account, session, verification },
  }),
  user: {
    additionalFields: {
      role: {
        type: ["admin", "user"],
      },
    },
  },
  plugins: [username(), admin(), nextCookies()],
  emailAndPassword: {
    enabled: true,
  },
});

oh no i had it on my auth client tho oh yea i have it !!

codecret | Software EngineerOP•2mo ago

i think i should fill it right? i have been struggeling with typescript

j_slno•2mo ago

yes u have to define role

codecret | Software EngineerOP•2mo ago

that's true , it worked after changing

role: z.string().optional(),

role: z.string().optional(),

role: z.string(),

role: z.string(),

let me try to do my request

j_slno•2mo ago

yes and you have to specify role inside body

codecret | Software EngineerOP•2mo ago

{error: {message: "API Error: UNAUTHORIZED ", code: -32603,…}} /

{error: {message: "API Error: UNAUTHORIZED ", code: -32603,…}} /

gosh

j_slno•2mo ago

role has to be in body not data

codecret | Software EngineerOP•2mo ago

yea thanks i did this although i have logged in using my admin account

j_slno•2mo ago

try passing the headers on createUser

codecret | Software EngineerOP•2mo ago

is it the right way i dont think so

 
const newUser = await auth.api.createUser({
        headers: headers,
        body: {
          name: input.name,
          email: input.email,
          password: input.password,
          role: input.role,
          data: {
            username: input.username,
          },
        },
      })

 
const newUser = await auth.api.createUser({
        headers: headers,
        body: {
          name: input.name,
          email: input.email,
          password: input.password,
          role: input.role,
          data: {
            username: input.username,
          },
        },
      })

j_slno•2mo ago

do u use nextjs? if so, you have to headers: await headers()

codecret | Software EngineerOP•2mo ago

yes, it worked thanks when redirecting to all employees page it doesnt get added, until i refresh the page , i have to do revalidation in some way i guess

j_slno•2mo ago

when listing users? u can write a hook to add your additional fields to the response

j_slno•2mo ago

https://www.better-auth.com/docs/concepts/hooks#after-hooks

Hooks | Better Auth

Better Auth Hooks let you customize BetterAuth's behavior

Gaming

Programming

How to create new user using drizzle to better-auth users schema

Did you find this page helpful?