Kysely•10mo ago

Return `null` by default if no record found

Hey, I am looking to have my queries return null instead of undefined if no records match my query when using executeTakeFirst. Is there a way to set this in the Kysely client?

Solution:

There's no way to do modify Kysely to return null in those cases.

Jump to solution

4 Replies

Solution

koskimas•10mo ago

There's no way to do modify Kysely to return null in those cases.

Unknown User•10mo ago

Message Not Public

koskimas•10mo ago

const result = (await query.executeTakeFirst()) ?? null

const result = (await query.executeTakeFirst()) ?? null

bombillazo•10mo ago

Yeah thats how we handle it but didnt want to sprinkle this all over the code in our queries or have to create a helper if it was avoidable.

Gaming

Programming

Return `null` by default if no record found