Can I use database transactions?

[kjurenec]

Does keystore support transactions? I know that prisma does but when i try something like this (item name is unique) one item is created and then the rest of it fails.

mutation {
  createCategory(
    data: { name: "C1", items: { create: [{ name: "I1" }, { name: "I1" }] } }
  ) {
    id
    name
    items {
      id
      name
    }
  }
}

[dcousens]

Hi @kjurenec,

There is no support for database transactions at this time, which is unfortunate.
We aren't unaware of the problem, and it is something we are trying to integrate into existing functionality, but for now, it is not supported.

The problems aren't new to us, but different solutions have different trade-offs which we are always trying to balance with productivity and availability.

Related

• Create Nested Relationships from create/update mutation #207
• Support Database Transactions #211
• Hooks - rollback on failure #534
• Decouple backlink queue operations from nested mutation resolving #535
• Can I use database transactions? #7642
• When creating items, if validation fails any relationship items remain. #7217
• Database Transactions #8084

[dcousens]

Transactions have now been added in #9122

[korzewski]

Hey, I'm using "@keystone-6/core: 3.1.1" and issue with transactions still occurs.

I wonder if this was solved at any further version, so if I upgrade to the newest (5.7.2) this would be fixed already?