select with limit of 1

Is there a cleaner way of selecting only one item with proper type safety than this?

const user: User | undefined = (await db.select().from(users).where(eq(users.id, userId)).limit(1))[0];

const user: User | undefined = (await db.select().from(users).where(eq(users.id, userId)).limit(1))[0];

8 Replies

Dan•2y ago

well, you don't need to specify the type explicitly, other than that it's fine

FloOP•2y ago

When i don't specify the type it's only User but it can be undefined when the user with that id does not exist in the database. That's why i do that. idk it feels a bit weird that the select returns an array with a limit of 1

Dan•2y ago

set "noUncheckedIndexedAccess": true in tsconfig

FloOP•2y ago

oh didn't know that exists ohh that produces so much chaos in my codebase 😅

Mario564•2y ago

you could also add ?. before [0] so the type is User | undefined

grimrippa•2y ago

I've been doing something like

const [user] = await db.select().from(users).where(eq(users.id, userId)).limit(1);

const [user] = await db.select().from(users).where(eq(users.id, userId)).limit(1);

Which seems to get the inference right but I don't know how typesafe this is.

yamiteru•2y ago

Why not just use .get()?

taijitu ☯•15mo ago

does .get() returns object or array? nevermind. i tested it, it returns object | undefined, thanks ❤️

Gaming

Programming

select with limit of 1