Cursor rule

1---
2description: Database schema changes, migrations, and query optimization
3globs: *.php, *.install, *.module
4---
5# Drupal Database Standards
6 
7Ensures proper database handling in Drupal applications.
8 
9## Rule Details
10 
11- **Name:** drupal_database_standards
12 
13- **Description:** Enforce Drupal database best practices and standards
14 
15## Filters
16- file extension pattern: `\\.(php|install|module)$`
17 
18## Enforcement Checks
19- Conditions:
20  - pattern `db_query` – Use Database API instead of db_query
21  - pattern `hook_update_N.*\\{\\s*[^}]*\\}` – Ensure hook_update_N includes proper schema changes
22  - pattern `\\$query->execute\\(\\)` – Consider using try-catch block for database operations
23 
24## Suggestions
25- Guidance:
26Database Best Practices:
27- Use Schema API for table definitions
28- Implement proper error handling
29- Use update hooks for schema changes
30- Follow Drupal's database abstraction layer
31- Implement proper indexing strategies
32 
33## Metadata
34- Priority: critical
35- Version: 1.1
36 
37