Insert and upsert database records with GORM using OnConflict clauses.
npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-create
Please help me install this Agent Skill. Skill: gorm-create Source: https://github.com/liurida/gorm-development-skill/tree/main/create Command: npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-create
This skill helps Go developers reliably insert and manage database records using GORM, reducing errors and boilerplate when performing single inserts, batch imports, upserts, and association handling.
Insert a new user record with name Jinzhu and age 18 and return the inserted ID and any error.
High-intent search queries and answers about installing and using this skill.
Insert and upsert database records reliably with GORM by using pointer-backed structs for single inserts, CreateInBatches for bulk imports, and OnConflict clauses for idempotent upserts. This approach ensures reliable persistence while reducing boilerplate and errors.
The best way to perform bulk imports in GORM is using CreateInBatches, which allows efficient batch insertion. You can skip hooks and associations during map-based creation to optimize performance-sensitive workflows and avoid unnecessary overhead.
GORM handles OnConflict upsert scenarios by applying clauses for conflict resolution. You can configure the upsert to DoNothing, update specific columns, or update all columns on conflict, ensuring idempotent operations that avoid duplicate rows in the database.
Yes, you can control which columns are inserted using GORM through field selection and omission. This allows you to specify exactly which columns to include or exclude during insertion, providing precise control over the persisted data and default value handling.
Yes, GORM supports association handling during record insertion with options to include or skip associations. You can also use map-based creation for dynamic inserts without invoking hooks or saving associations, giving you control over the persistence workflow.
You should skip hooks during GORM batch inserts when working with performance-sensitive workflows or performing large data imports. Map-based creation bypasses hooks entirely, making it ideal for efficient bulk operations where association saving is unnecessary.
liuridaDeclare GORM models with gorm.Model embedding and field tags.
liuridaProvide type-safe CRUD and query operations for GORM models using Go generics.
liuridaManage GORM model associations with auto-save control and batch operations.
javierhbrGuide Go developers on implementing data persistence with SQL, ORMs, and migrations.
