Encapsulate GORM query logic into reusable scope functions.
npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-scopes
Please help me install this Agent Skill. Skill: gorm-scopes Source: https://github.com/liurida/gorm-development-skill/tree/main/scopes Command: npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-scopes
Reusable query conditions in GORM often get duplicated across handlers and models, making maintenance error-prone and inconsistent; this Skill consolidates query logic into composable scope functions to enforce consistent filtering, pagination, and routing across an application.
Create parameterized GORM scopes for pagination and tenant isolation and show example usage combining them with db.Scopes to query orders.
High-intent search queries and answers about installing and using this skill.
You can build reusable GORM query filters by encapsulating conditions into scope functions of type func(*gorm.DB) *gorm.DB, then combining them with db.Scopes. This approach ensures consistent filtering across handlers without duplicating query logic.
Multi-tenant row isolation in a GORM application is implemented using parameterized scope functions that filter queries by tenant ID. Applying these scopes to update and delete operations also enforces row-level constraints for safe data separation across organizations.
Parameterized pagination in GORM is set up by creating closure-based scope functions that accept dynamic values for Offset and Limit. You combine these pagination scopes with other filtering scopes using db.Scopes to build complex queries without duplicating logic.
Yes, GORM scopes can be used for dynamic table routing and sharding by swapping table names or schemas at runtime within the scope function. This allows the application to route queries to specific shards or separate multi-org data dynamically.
To safely constrain update and delete operations in GORM, apply row-level constraints as scope functions before executing the mutation. This restricts the operation scope by organization or tenant and requires explicit error propagation for the mutating operation.
GORM supports composable query logic by using closure-based parameterized scopes that accept dynamic values for date ranges and statuses. Multiple scopes are chained together with db.Scopes to build complex, reusable queries from simple filtering components.
liuridaRetrieve the underlying *sql.DB* object from a GORM *gorm.DB* instance.
liuridaChain GORM methods to build dynamic database queries with isolated sessions.
javierhbrImplement Go HTTP middleware for context propagation, slog logging, and panic recovery.
liuridaBuild complex GORM database queries with subqueries, row locking, and scopes.
