Issue using findUnique in Typescript

[tomwray13]

Hey there!

I'm having an issue using the findUnique method with typescript.

I'm using a simple login resolver which takes an email as the only argument, and want to use the findUnique to find the respective user in the database.

Here's the code for the resolver:

login: (parent: any, args: any) => {
    const findSpecificUser = (email: string) => {
        return Prisma.validator<Prisma.userWhereUniqueInput>()({
            email,
        })
    }
    const user = prisma.user.findUnique({ where: findSpecificUser(args.email) })
}

I'm getting a couple of errors show in VScode to do with the userWhereUniqueInput Prisma validator. It's saying:

Type '{ email: string; }' has no properties in common with type 'userWhereUniqueInput'.

Hovering over the userWhereUniqueInput shows the following type:

type Prisma.userWhereUniqueInput = {
    id?: number | undefined;
}

Which is confusing - it looks like the email is not included? Tried following the docs but can't figure it out!

[ryands17]

@tomwray13 👋

You need to add @unique in front of the email field and then update your database via migrations like this. This will make sure it appears in userWhereUniqueInput.

[tomwray13]

Doh! Thank you so much for the quick reply @ryands17!

[ludralph]

Hi there,

To keep our discussions organized and focused on the most relevant topics, we’re reviewing and tidying up our backlog. As part of this process, we’re closing discussions that have already been marked as answered but remain open.

If this discussion still requires further input or clarification, feel free to reopen it or start a new one with updated details. Your contributions are invaluable to the community, and we’re here to help!

For more details about our priorities and vision for the future of Prisma ORM, check out our latest blog post: https://www.prisma.io/blog/prisma-orm-manifesto.

Thank you for your understanding and ongoing support of the Prisma community!