AgentSkillsCN

prisma-transactions

全面指南与参考手册，深入讲解 Prisma 事务的使用方法，包括顺序操作、交互式事务、嵌套写入，以及乐观并发控制。适用于用户询问如何在 Prisma 中处理事务、保障原子性、执行批量操作，或防止竞态条件时使用。

SKILL.md
--- frontmatter
name: prisma-transactions
description: Comprehensive guide and reference for using Prisma Transactions, including sequential operations, interactive transactions, nested writes, and optimistic concurrency control. Use when the user asks about handling transactions, atomicity, batch operations, or preventing race conditions in Prisma.

Prisma Transactions Skill

This skill provides detailed information and examples for using transactions in Prisma.

Available Resources

  • •Overview: overview.md - General concepts, ACID properties, and available techniques.
  • •Nested Writes: nested-writes.md - Creating/Updating related records atomically (dependent writes).
  • •Batch Operations: batch-operations.md - Bulk operations like createMany, updateMany, deleteMany.
  • •Transaction API: transaction-api.md - Sequential ($transaction([])) and Interactive ($transaction(fn)) transactions.
  • •Concurrency Patterns: concurrency-patterns.md - Idempotency and Optimistic Concurrency Control (OCC).

Common Use Cases

  1. •Sequential Operations: Executing a list of queries in order. See transaction-api.md.
  2. •Interactive Transactions: Using a function to run logic within a transaction. See transaction-api.md.
  3. •Nested Writes: Creating/Updating related records atomically. See nested-writes.md.
  4. •Optimistic Concurrency Control: Handling race conditions without locks. See concurrency-patterns.md.