Prisma throws an error “TypeError: cannot read property findmany of undefined”

Question

I wanted to make a chat app to practice working with graphql and node, for database I used prisma. I was doing everything like in this tutorial.

https://www.howtographql.com/graphql-js/0-introduction/

I just changed variable names.

so I have this code

const { PrismaClient } = require('@prisma/client')
const prisma = new PrismaClient()


const resolvers = {
  Query: {
    history: async (parent, args, context) => {
      return context.prisma.Messages.findMany()
    },
  },
  Mutation: {
    post: (parent, args, context) => {
      const newMessage = context.prisma.Messages.create({
        data: {
          username: args.username,
          message: args.message,
        },
      })
      return newMessage
    },
  },
}

const server = new GraphQLServer({
  typeDefs: './src/schema.graphql',
  resolvers,
  context: {
    prisma,
  }
})
server.start(() => console.log(`Server is running on https://localhost:4000`))

as my index.js

this is my schema.prisma

  provider = "sqlite"
  url      = "file:./dev.db"
}


generator client {
  provider = "prisma-client-js"
}


model Message {
  id       Int      @id @default(autoincrement())
  sendedAt DateTime @default(now())
  message  String
  username String
}

script.js

const { PrismaClient } = require("@prisma/client")


const prisma = new PrismaClient()


async function main() {
  const newMessage = await prisma.Messages.create({
    data: {
      message: 'Fullstack tutorial for GraphQL',
      username: 'www.howtographql.com',
    },
  })
  const allMessages = await prisma.Messages.findMany()
  console.log(allMessages)
}


main()
  .catch(e => {
    throw e
  })
  // 5
  .finally(async () => {
    await prisma.disconnect()
  })

and schema.graphql

type Query {
  history: [Message!]!
}

type Mutation {
  post(username: String!, message: String!): Message!
}

type Message {
  id: ID!
  message: String!
  username: String!
}

and that is what i got in my playground

  "data": null,
  "errors": [
    {
      "message": "Cannot read property 'findMany' of undefined",
      "locations": [
        {
          "line": 2,
          "column": 3
        }
      ],
      "path": [
        "history"
      ]
    }
  ]
}

please help

score 7 · Accepted Answer · 2022-11-29 23:59:03Z

7

It should be noted it is not actually lowercase but camel case.

Example:

Model name: Message -> Prisma client name: message

Model name: MessagePerUser -> Prisma client name: messagePerUser

answered Nov 29, 2022 at 23:59

Santiago Alvarado Orlandini

1111 silver badge3 bronze badges

Yunus SitdikovYunus Sitdikov 991 gold badge1 silver badge5 bronze badges · Accepted Answer · 2020-07-17 11:52:28Z

4

I managed to fix that. Actually, all I needed was to use the same name but lowercased as in schema.prisma

answered Jul 17, 2020 at 11:52

Yunus Sitdikov

991 gold badge1 silver badge5 bronze badges

1

10

The same name for what – can you elaborate what exactly was the error?

– Philzen

Apr 3, 2022 at 13:31

Lee LeonardLee Leonard 11 bronze badge · Accepted Answer · 2022-09-04 08:39:07Z

Would like to add on to the answer

Basically when calling await prisma.User.create, prisma allows the User model to be in caps, but when calling other models such as prisma.messages.create the m has to be in lowercase. Essentially,for all prisma calls, the models should be in lowercase. Hopefully this answers your question, prisma does not flag this error out

Gaurav PawarGaurav Pawar 294 bronze badges · Accepted Answer · 2022-12-01 16:18:48Z

0

use Table name as camelCase in prisma Client to make Queries

Example:
Table Name is: StudentData

then use camelCase according to table name
prisma.studentData.findMany();

answered Dec 1, 2022 at 16:18

Gaurav Pawar

294 bronze badges

SIDDHARTH MANJREKARSIDDHARTH MANJREKAR 1 · Accepted Answer · 2023-11-28 19:53:11Z

0

const { PrismaClient } = require(‘@prisma/client’)
const prisma = new PrismaClient()

so this in an imp part i resolved my issue just by doing this

answered 2 hours ago

SIDDHARTH MANJREKAR

1

New contributor

Prisma throws an error “TypeError: cannot read property findmany of undefined”