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

Screenshot_2025-02-13_at_12.27.01_AM.png

jslno•2/12/25, 9:31 PM

you're missing setting the id

jslno•2/12/25, 9:31 PM

Also why not just use the admin plugin?

Jjslno you're missing setting the id

codecret | Software EngineerOP•2/12/25, 9:34 PM

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

jslno•2/12/25, 9:34 PM

its basically just a fetch. so it works client and server side

jslno•2/12/25, 9:35 PM

but you could also call it from auth.api

Ttheboxer from server side, u can call `auth.api.createUser` if using the admin plugin

codecret | Software EngineerOP•2/12/25, 10:25 PM

i still dont understand why such an error occurs

jslno•2/12/25, 10:29 PM

role must be inside data

jslno•2/12/25, 10:29 PM

codecret | Software EngineerOP•2/12/25, 10:29 PM

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)

codecret | Software EngineerOP•2/12/25, 10:30 PM

jslno•2/12/25, 10:30 PM

body doesnt take in

jslno•2/12/25, 10:31 PM

do u use the username plugin?

jslno•2/12/25, 10:31 PM

try also adding it to data

codecret | Software EngineerOP•2/12/25, 10:31 PM

oh no

codecret | Software EngineerOP•2/12/25, 10:31 PM

i had it on my auth client tho

codecret | Software EngineerOP•2/12/25, 10:32 PM

oh yea i have it !!

codecret | Software EngineerOP•2/12/25, 10:33 PM

codecret | Software EngineerOP•2/12/25, 10:33 PM

i think i should fill it right?

codecret | Software EngineerOP•2/12/25, 10:34 PM

i have been struggeling with typescript

jslno•2/12/25, 10:34 PM

yes u have to define

codecret | Software EngineerOP•2/12/25, 10:36 PM

that's true ,
it worked after
changing

codecret | Software EngineerOP•2/12/25, 10:36 PM

let me try

codecret | Software EngineerOP•2/12/25, 10:36 PM

to do my request

jslno•2/12/25, 10:36 PM

yes and you have to specify inside

body

body

codecret | Software EngineerOP•2/12/25, 10:38 PM

gosh

jslno•2/12/25, 10:38 PM

role has to be in

body

body

not

data

data

Jjslno role has to be in `body` not `data`

codecret | Software EngineerOP•2/12/25, 10:38 PM

yea thanks i did this

codecret | Software EngineerOP•2/12/25, 10:38 PM

although i have logged in using my admin account

jslno•2/12/25, 10:39 PM

try passing the headers on createUser

codecret | Software EngineerOP•2/12/25, 10:55 PM

is it the right way i dont think so

jslno•2/12/25, 10:59 PM

do u use nextjs?

jslno•2/12/25, 11:02 PM

if so, you have to

codecret | Software EngineerOP•2/12/25, 11:30 PM

yes, it worked thanks

codecret | Software EngineerOP•2/12/25, 11:30 PM

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

jslno•2/13/25, 12:59 AM

when listing users?

jslno•2/13/25, 1:00 AM

u can write a hook to add your additional fields to the response

jslno•2/13/25, 1:02 AM

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

Hooks | Better Auth

Better Auth Hooks let you customize BetterAuth's behavior