SELECT published, COUNT(*) FROM Posts GROUP BY published

const data = await prisma.posts.groupBy({
        by: ["published"],
        _count: {
          published: true,
        },
      });

npx prisma generate

package.json

"type": "module"

import { PrismaClient }  from '../../prisma-client/index.js' 
let prisma = new PrismaClient();```

node --experimental-specifier-resolution=node server.js

The requested module '../../prisma-client/index.js' does not provide an export named 'PrismaClient'

model User {
  id            String    @id @default(auto()) @map("_id") @db.ObjectId
  email         String    @unique
  description   String?
  name          String?
  username      String?
  password      String?
  followedBy    User[]    @relation("UserFollows", fields: [followedByIDs], references: [id])
  followedByIDs String[]  @db.ObjectId
  following     User[]    @relation("UserFollows", fields: [followingIDs], references: [id])
  followingIDs  String[]  @db.ObjectId
  role          Role      @default(USER)
  reivews       Review[]
  emailVerified DateTime? @map("email_verified")
  image         String?
  accounts      Account[]
  sessions      Session[]
  @@fulltext([name(sort: Desc), username, email])
  @@map("users")
}

await prisma.user.update({
            where:{
                email:'<mailto:alf@votaryfilms.com|alf@votaryfilms.com>'
            },
            data:{
                following: {connect: [{id: data}]}
            }
        })

The current database provider doesn't support a feature that the query used: Unhandled and unsupported value
mapping for MongoDB: 6223c13a26bb3d44fc98dad5 as Int.

BEGIN

SAVEPOINT

_count

20220413095619_init

"message": "TypeIdentifier not yet supported in Import as ID. com.prisma.shared.models.TypeIdentifier$Int$@4a2acc6c",
      "requestId": "eu1:cl24f25t66z6v09991kjjvzck"

schema.prisma

web

schema.prisma

error - Error: ENOENT: no such file or directory, open '/Users/xxx/rootDir/apps/web/.next/server/pages/api/trpc/schema.prisma'

apps/web

packages/database

packages/database/dist

apps/
├─ web/                          # <-- nextJS app (unable to detect schema)
packages/
├─ database/
│  ├─ prisma/                    # prisma setup
│  │  ├─ schema.prisma
│  ├─ src/
│  │  ├─ client.ts               # exports PrismaClient & global.prisma type in prod
│  │  ├─ index.ts                # exports from prisma client
│  │  ├─ seed.ts                 # prisma seeding script for local dev
│  ├─ .env.example               # `DATABASE_URL` env var
│  ├─ tsup.config.js             # builds to /dist folder in this package

prisma.create

INSERT INTO membership(orgId, email, role)
SELECT orgId, @email as email, @role as role
FROM membership
WHERE orgId = @orgId
  AND userId = @userId
  AND (role = 'OWNER' OR (role = 'ADMIN' AND @role = 'USER'));

userId

prisma.findUnique

Type '(_: {}, args: { name: string; }, ctx: Context) => Prisma__ExchangeClient<Exchange>' is not assignable to type 'FieldResolver<"Mutation", "addExchange">'.
  Type 'Prisma__ExchangeClient<Exchange>' is not assignable to type 'MaybePromise<{ id: string; name: string; } | null>'.
    Type 'Prisma__ExchangeClient<Exchange>' is not assignable to type 'PromiseLike<{ id: string; name: string; } | null>'.
      Types of property 'then' are incompatible.
        Type '<TResult1 = Exchange, TResult2 = never>(onfulfilled?: ((value: Exchange) => TResult1 | PromiseLike<TResult1>) | null | undefined, onrejected?: ((reason: any) => TResult2 | PromiseLike<...>) | null | undefined) => Promise<...>' is not assignable to type '<TResult1 = { id: string; name: string; } | null, TResult2 = never>(onfulfilled?: ((value: { id: string; name: string; } | null) => TResult1 | PromiseLike<TResult1>) | null | undefined, onrejected?: ((reason: any) => TResult2 | PromiseLike<...>) | ... 1 more ... | undefined) => PromiseLike<...>'.
          Types of parameters 'onfulfilled' and 'onfulfilled' are incompatible.
            Types of parameters 'value' and 'value' are incompatible.
              Type 'Exchange' is not assignable to type '{ id: string; name: string; }'.
                Types of property 'id' are incompatible.
                  Type 'number' is not assignable to type 'string'.ts(2322)

schema.prisma

schema.graphql

//schema.prisma
model Exchange {
  id   Int    @id @default(autoincrement())
  name String @unique
}
//schema.graphql
type Exchange {
  id: ID!
  name: String!
}

type Mutation {
  addExchange(name: String!): Exchange
}

type Query {
  exchanges: [Exchange!]!
  hello: String
}

nexus-prisma

playlistId

videoId

id

id

schema.prisma