prisma-plugin: Query returning empty array

[DimitReeis]

Hey there!

I'm new to GraphQL, Prisma and Pothos and I am missing something but I don't exactly know what. I'm using Next.js and an implicit many-to-many relation and the query returns an empty array.

My code:
schema.prisma:

model User {
  id        String   @id @default(uuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  email     String?  @unique
  image     String?
  role      Role     @default(USER)
  Posts     Post[] 
}

model Post {
  id          String   @id @default(uuid())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  title       String
  description String
  category    String
  User        User[]

Post.ts:

builder.prismaObject("Post", {
  fields: (t) => ({
    id: t.exposeID("id"),
    title: t.exposeString("title"),
    description: t.exposeString("description"),
    category: t.exposeString("category"),
    createdAt: t.exposeString("createdAt"),
    updatedAt: t.exposeString("updatedAt"),
    user: t.relation("User"),
  }),
});

builder.queryField("posts", (t) =>
  t.prismaField({
    type: ["Post"],

    resolve: async (query, _parent, _args, ctx, _info) =>
      prisma.post.findMany({
        ...query,
      }),
  })
);

When I query the following in the GraphQL-Playground:

query MyQuery {
  posts {
    title
    user {
      email
      id
    }
  }
}

This is the output:

{
  "data": {
    "posts": [
      {
        "title": "Lettuce",
        "user": []
      },
      {
        "title": "Banana",
        "user": []
      },
      {
        "title": "Carrot",
        "user": []
      }
    ]
  }
}

I tried using queryType but I get an error that happens when the page is generating saying:
PothosSchemaError: Duplicate typename: Another type with name Query already exists.#

I appreciate any feedback!

[hayes]

I don't see anything wrong with your code. Can you confirm you database actually has users associated with your posts?