Prisma在一对一的关系上插入外键的无效价值

Question

相关模式零件。

model ShopifyOfflineStoreSession {
  pk          String    @id(map: "PK_d371917bab72a48d6cce7880fc5") @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  id          String    @unique(map: "UQ_91ede9e23efbd7ee27b37bdd9ba") @db.VarChar
  store       Store?    @relation(fields: [pk], references: [shopifyOfflineSessionPk], onDelete: Cascade, onUpdate: Cascade, map: "FK_901a837fbbf20119aded3682f90")

  @@map("shopify_store_session")
}


model Store {
  id                       Int                         @id(map: "PK_f3172007d4de5ae8e7692759d79") @default(autoincrement())
  shopifyOfflineSessionPk  String?                     @unique(map: "UQ_901a837fbbf20119aded3682f90") @db.Uuid
  shopifyOfflineSession    ShopifyOfflineStoreSession?

  @@map("store")
}

此查询失败：

await this.prisma.shopifyOfflineStoreSession.create({
        data: {
          ...session,
          store: { connect: { id: store.id } },
        },
      });

错误：

2022-06-10 16:41:02.035 UTC [15541] ERROR:  null value in column "pk" violates not-null constraint
2022-06-10 16:41:02.035 UTC [15541] DETAIL:  Failing row contains (null, offline_subbooks2.myshopify.com, 2022-06-10 16:41:02.033, 2022-06-10 16:41:02.033, null, subbooks2.myshopify.com, 005148992241858, f, null, null, null).
2022-06-10 16:41:02.035 UTC [15541] STATEMENT:  INSERT INTO "public"."shopify_store_session" ("pk","id","createdAt","updatedAt","shop","state","isOnline") VALUES ($1,$2,$3,$4,$5,$6,$7) RETURNING "public"."shopify_store_session"."pk"
Issue saving Shopify offline token. Err: PrismaClientKnownRequestError:
Invalid `this.prisma.shopifyOfflineStoreSession.create()` invocation in
/usr/src/api/src/store/store.service.ts:576:52
   573     data: session,
   574   });
   575 } else {
→  576   await this.prisma.shopifyOfflineStoreSession.create(
  Null constraint violation on the fields: (`pk`)
    at cb (/usr/src/api/node_modules/@prisma/client/runtime/index.js:38683:17) {
  code: 'P2011',
  clientVersion: '3.6.0',
  meta: { constraint: [ 'pk' ] }
}
query: DELETE FROM "store" WHERE "id" IN ($1) -- PARAMETERS: [18]

我不明白Prisma为何在shopifyflinestoressession上设置pk to null。有人可以帮助我了解导致此错误的原因吗？

Answer 1

prisma docs 状态：

在一对一的关系中，关系的侧面没有关系标量（代表数据库中的外键的字段）必须是可选的。

对我来说，我希望store记录能够在没有shopifyofflinestoresession的情况下存在，这意味着我必须将关系标量放在上ShopifyOfflinestoresession而不是Store。

这就是最终状态现在的外观，也没有问题：

model Store {
  id                       Int                         @id(map: "PK_f3172007d4de5ae8e7692759d79") @default(autoincrement())
  shopifyOfflineSession    ShopifyOfflineStoreSession?
  
  @@map("store")
}

model ShopifyOfflineStoreSession {
  pk          String    @id(map: "PK_d371917bab72a48d6cce7880fc5") @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  id          String    @unique(map: "UQ_91ede9e23efbd7ee27b37bdd9ba") @db.VarChar
  store       Store     @relation(fields: [storeId], references: [id], onDelete: Cascade, onUpdate: Cascade, map: "FK_901a837fbbf20119aded3682f90")
  storeId     Int       @unique

  @@map("shopify_store_session")
}

我必须执行一些迁移才能实现这一目标：

• 创建storeID（nullable）（nullable）shopifyofflinestoresession
• 添加<<<代码>存储使其
• 制作StoreID non Null
• 更改FK从Store shopifyofflineStoresession
• drop drobine frictional fk（shopify> shopify> shopifyflineseensepk ）来自存储。

如果您想要有关这些迁移的更多详细信息，请在评论中询问。