Cursor rule

1---
2description: Database related design rules
3globs: internal/datastore/*.go
4---
5# Database code rules
6 
7- Libraries
8    - Database related tasks should use GORM ORM library
9 
10- Dialect support
11    - SQLite and MySQL dialects must be supported
12 
13- Source file locations
14    - Database related code is in datastore package located at internal/datastore
15        - database model
16            - internal/model.go
17        - sqlite dependend code
18            - internal/datastore/sqlite.go
19        - mysql depended code
20            - internal/datastore/mysql.go
21        - common database interactions
22            - internal/datastore/interfaces.go
23        - GORM auto migration related code
24            - internal/datastore/manage.go
25 
26- Database session
27    - Database session is initialized in
28        - internal/analysis/realtime.go
29 
30- Lock Management
31    - Required: Yes
32    - Transaction Handling
33        - Required: Yes
34            - Best Practices:
35            - Wrap lock operations in transactions
36            - Use context with timeout for transactions
37            - Implement proper rollback on errors
38    - Retry Mechanism
39        - Required: Yes
40            - Configuration:
41                - Max Retries: 5
42                - Base Delay: 500ms
43                - Strategy: Exponential Backoff
44    - Best Practices:
45        - Implement exponential backoff
46        - Log retry attempts
47        - Handle database-specific lock errors
48 
49- Query Optimization
50    - Required: Yes
51    - Indexes
52        - Requirements:
53            - Index frequently queried columns
54            - Index foreign key columns
55            - Consider composite indexes for common query patterns
56    - Joins
57        - Best Practices:
58            - Use preload for related data loading
59            - Optimize join conditions
60            - Limit joined data sets
61 
62- Error Handling
63    - Required: Yes
64    - Best Practices:
65        - Wrap database errors with context
66        - Distinguish between lock and other errors
67        - Provide clear error messages
68 
69