High Database

Use transactions for multi-step operations

Rule Description

Wrap multi-step database operations in transactions:
- Ensures all-or-nothing execution
- Prevents partial updates on failure
- Maintains data consistency

```ruby
ActiveRecord::Base.transaction do
order.update!(status: 'paid')
Payment.create!(order: order, amount: order.total)
InventoryService.decrement(order.items)
end
# If any step fails, all changes are rolled back
```

Included in Rulesets

PostgreSQL Standards
25 rules • 0 standards
View
MySQL Standards
25 rules • 0 standards
View
MongoDB Best Practices
25 rules • 1 standard
View
Redis Guidelines
25 rules • 0 standards
View
SQLite Standards
25 rules • 0 standards
View
Code Review Standards
58 rules • 0 standards
View

Add This Rule

Sign in to add this rule to your workspace

Sign in with GitHub

Details

Severity
High
Category
Database
Used in
6 rulesets