graphql

prisma

schema.graphql

prisma1 deploy

{
  "data": {
    "addProject": null
  },
  "errors": [
    {
      "message": "Whoops. Looks like an internal server error. Search your server logs for request ID: local:ckoj44v3i02hc0877ny7w1j6q",
      "path": [
        "addProject"
      ],
      "locations": [
        {
          "line": 2,
          "column": 9
        }
      ],
      "requestId": "local:ckoj44v3i02hc0877ny7w1j6q"
    }
  ],
  "status": 200
}

Warning: Management API authentication is disabled. To protect your management server you should provide one (not both) of the environment variables 'CLUSTER_PUBLIC_KEY' (asymmetric, deprecated soon) or 'PRISMA_MANAGEMENT_API_JWT_SECRET' (symmetric JWT).

{"key":"error/unhandled","requestId":"local:ckoj44v3i02hc0877ny7w1j6q","payload":{"exception":"org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"Project_pkey\"\n Detail: Key (id)=(reviews$default) already exists.","query":" mutation addProject($name: String! $stage: String! $secrets: [String!]) {\n addProject(input: {\n name: $name,\n stage: $stage\n secrets: $secrets\n }) {\n project {\n name\n }\n }\n }\n ","variables":"{\"name\":\"reviews\",\"stage\":\"default\",\"secrets\":null}","code":"0","stack_trace":"org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)\\n org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)\\n org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)\\n org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)\\n org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)\\n org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)\\n org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)\\n com.prisma.connector.shared.jdbc.SharedSlickExtensions.$anonfun$insertToDBIO$1(SharedSlickExtensions.scala:37)\\n com.prisma.connector.shared.jdbc.SharedSlickExtensions.$anonfun$insertToDBIO$1$adapted(SharedSlickExtensions.scala:37)\\n com.prisma.connector.shared.jdbc.SharedSlickExtensions.$anonfun$jooqToDBIO$1(SharedSlickExtensions.scala:56)\\n slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:70)\\n slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:69)\\n slick.basic.BasicBackend$DatabaseDef$$anon$3.liftedTree1$1(BasicBackend.scala:276)\\n slick.basic.BasicBackend$DatabaseDef$$anon$3.run(BasicBackend.scala:276)\\n java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\\n java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\\n java.lang.Thread.run(Thread.java:748)","message":"ERROR: duplicate key value violates unique constraint \"Project_pkey\"\n Detail: Key (id)=(reviews$default) already exists."}}

prisma generate

+ NODE_OPTIONS=--max_old_space_size=3333 yarn prisma generate
yarn run v1.22.5
$ /opt/atlassian/pipelines/agent/build/node_modules/.bin/prisma generate
Prisma schema loaded from prisma/schema.prisma

root@627895f87344:/app# npx prisma migrate dev --name init
Environment variables loaded from prisma/.env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "opti_development", schema "public" at "db:5432"

PostgreSQL database opti_development created at db:5432

Response: Can't reach database server at `db`:`5432`

Please make sure your database server is running at `db`:`5432`.
Error: UserFacingError

root@627895f87344:/app# psql -h db -U user
Password for user user:
psql (11.11 (Debian 11.11-0+deb10u1), server 13.2)
WARNING: psql major version 11, server major version 13.
         Some psql features might not work.
Type "help" for help.

user=#

root@627895f87344:/app# npx prisma migrate dev --name init
Environment variables loaded from prisma/.env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "dev.db" at "file:./dev.db"

The following migration(s) have been created and applied from new schema changes:

migrations/
  └─ 20210512160133_init/
    └─ migration.sql

Your database is now in sync with your schema.

✔ Generated Prisma Client (2.22.1) to ./node_modules/@prisma/client in 389ms

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

datasource db {
  provider = "postgresql"
  url      = "<postgresql://user:password@db:5432/opti_development>"
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

model Post {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  title     String
  content   String?
  published Boolean  @default(false)
  viewCount Int      @default(0)
  author    User?    @relation(fields: [authorId], references: [id])
  authorId  Int?
}

subscriptions-transport-ws

model Model {
  id Int @id @default(autoincrement())
  domain String? @unique
  otherModels OtherModel[]
}


model OtherModule {
  id        Int      @id @default(autoincrement())
  modelId Int
  modelDomain String?
  model Model @relation(fields: [modelId, modelDomain], references: [id, domain])
}

Error validating: The argument `references` must refer to a unique criteria in the related model `Model`. But it is referencing the following fields that are not a unique criteria: id, domain

Prisma.validator