deleteMany

import {prisma} from './generated/prisma-client/index.js'

import prisma from './generated/prisma-client/index.js'

{
  human(id: "1000") {
    name
    height
  }
}

id

where

prisma.user.findOne({...})

prisma.user.findOne({...}).getRawQuery().

prisma.user({ id }).boxes({ where: { number: boxNumber } }).slots({ where: { number: slotNumber } });

getServerSideProps()

PromiseReturnType<typeof fn>

fn

type X = PromiseReturnType<typeof fn>

fn

Module not found: Can't resolve 'child_process' in...

Error:
Invalid `prisma.project.findMany()` invocation in
webpack-internal:///./packages/prisma/repository/Project.ts:41:84

  Unknown error in Prisma Client

This is a non-recoverable error which probably happens when the Prisma Query Engine has a panic.

type Frame{
  id: ID! @id
  primaryBoardSize: HolePattern
  supportedBoardSizes: [HolePattern] @scalarList(strategy: RELATION)
}

supportedBoardSizes

FrameWhereInput

primaryBoardSize

primaryBoardSize_in, primaryBoardSize_not_in, primaryBoardSize, primaryBoardSize_not

Frame.supportedBoardSizes

Invalid prisma invocation

async createItem(parent, args, context) {
    const item = await context.prisma.item.create(
      {
        data: { ...args },
      },
    );
    return item;
  },
// Got this error
"message": "\nInvalid `prisma.item.create()` invocation

model ProjectPro {
    id                 Int               @default(autoincrement()) @id
    name               String
    slug               String            @unique
    type               TypeProjectPro    @default(PLUGIN)
    settings_users_pro SettingsUserPro[] @relation(references: [id])
    created_at         DateTime?         @default(now())
    updated_at         DateTime?         @updatedAt
    deleted_at         DateTime?
}

model SettingsUserPro {
    id             Int          @default(autoincrement()) @id
    userId         Int
    type           String?      @default("month")
    User           User         @relation(fields: [userId], references: [id])
    projects_pro   ProjectPro[] @relation(references: [id])
    created_at     DateTime?    @default(now())
    updated_at     DateTime?    @updatedAt
    deleted_at     DateTime?
}

await prisma.settingsUserPro.update({
        data: {
            projects_pro: {
                set: {
                    id: Number(projectProId),
                },
            },
        },
        where: {
            id: Number(userId),
        },
    });

AssertionError("[Query Graph] Expected a valid parent ID to be present for a nested set (disconnect part) on a many-to-many relation.

model BrandCategory {
  id     String  @id
  title  String
  hero   String?
  brands Brand[]
}

const BrandCategory = objectType({
  name: "BrandCategory",
  definition(t) {
    t.string("id");
    t.string("title");
    t.string("hero", {
      nullable: true,
    });
    t.list.field("brands", {
      type: "Brand",
      resolve: (parent) =>
        prisma.brandCategory
          .findOne({
            where: { id: String(parent.id) },
          })
          .brands(),
    });
  },
});

Type 'Promise<Brand[]>' is not assignable to type 'PromiseLike<{...}>

Type 'Promise<Brand[]>' is not assignable to type 'MaybePromise<{...}>

findMany

id

model User {
  id  Int @default(autoincrement()) @id
  email String
  ...
}

SELECT id FROM public.user
WHERE
  id % 10 = 1
ORDER BY id DESC

queryRaw

IntFilter

findMany

schema.prisma

prisma generate

include

tenantId

where

public find = ({ where, ...args }: FindManyProductArgs) =>
      this.prisma.product.findMany({
         where: { ...where, tenantId: this.identity.tenantId, ...args }
      })

find

include

public find: PrismaClient["product"]["findMany"] = ({ where, ...args }) =>
      this.prisma.product.findMany({
         where: { ...where, tenantId: this.identity.tenantId, ...args } as any
      }) as any

any

prisma-client-js

t.crud.updateOne*

export type Game_server_port.gameServerId_binding_protocol_uniqueCompoundUniqueInput = {
  gameServerId: number
  binding: number
  protocol: GameServerPortProtocol
}

export type Game_server_port.gameServerId_identifier_uniqueCompoundUniqueInput = {
  gameServerId: number
  identifier: string
}

export type Game_server_port.gameServerId_number_protocol_uniqueCompoundUniqueInput = {
  gameServerId: number
  number: number
  protocol: GameServerPortProtocol
}

export type Game_server_setting.gameServerId_gameSettingId_uniqueCompoundUniqueInput = {
  gameServerId: number
  gameSettingId: number
}

export type Game_server_setting_preset.gameServerId_name_uniqueCompoundUniqueInput = {
  gameServerId: number
  name: string
}

npx prisma generate

Authentication failed against database server at `<postgres-url>`, the provided database credentials for `<user>` are not valid.

Please make sure to provide valid database credentials for the database server at `<postgres-url>`.
    at $w.request (/Users/jh/coprime/hq/node_modules/@prisma/client/runtime/index.js:212:54)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'P1000',
  clientVersion: '2.9.0',
  meta: {
    database_user: 'coprime',
    database_host: '<postgres-url>'
  }
}

graphql-nexus

schema.prisma

model Person {
  name String
  age Int
}

{
  name: "String",
  age: "Int"
}

ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState("22021"), message: "invalid byte sequence for encoding \"UTF8\": 0x00", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("wchar.c"), line: Some(2017), routine: Some("report_invalid_encoding") }) }) })

insert into test (foo) values ('{"a":1}')

invalid input syntax for type json

insert into test (foo) values ('{"a": 1}')

insert into test (foo) values ('{"a":"1"}')

type User {

id: ID! @id

name: String!

username: String! @unique

}

type Friend {

id: ID! @id

user1: User! @relation(name: "FriendToUser1", onDelete: SET_NULL)

user2: User! @relation(name: "FriendToUser2", onDelete: SET_NULL)

status: Int!

}