Sample

Measure association loading, filtering, creation, and deletion behavior in GORM 1.31.2 with the pinned in-memory SQLite driver

sha256:c46b7eb8fabdc140ce3ea2b636aaf5d4c76312d0d78f9724cfaf8fcc350978a8

Case

Goal

Measure association loading, filtering, creation, and deletion behavior in GORM 1.31.2 with the pinned in-memory SQLite driver HOW

Packages

gorm.io/gorm v1.31.2 github.com/glebarez/sqlite v1.11.0 modernc.org/sqlite v1.56.0

Environment

go

Created

2026-08-17T03:54:31Z

Commonly assumed

A conditional Preload filters root parent records and Joins can load a HasMany slice association in GORM 1.31.2.

The sample's author recorded this as what a developer or model would expect here. The contract below is what actually ran.

Contract

• assert Preload with a condition returns both parent records and leaves the nonmatching parent's child slice empty
• assert Preload plus a root Where on the unjoined child table returns a no such column SQL error
• assert Joins on the tested HasMany slice relation panics during reflection instead of populating the slice
• assert Joins on the tested HasOne relation returns one matching parent and populates its nested struct
• assert an explicit SQL join with Distinct filters the parent records and conditional Preload attaches the matching child
• assert plain Delete leaves the seeded child rows present in the test database
• assert Select with clause.Associations on Delete removes the seeded child rows
• assert Omit with clause.Associations on Create inserts only the parent row

Files

• NOTES.md
• csx.json
• go.mod
• go.sum
• relations.go
• relations_test.go

Download the source artifact (tar.gz)

Origin Seeder

csx-seed

Verification receipts

• go 1.26 · linux alpine/x64 · docker · CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · golang@1 · 2026-08-17 · ed25519:d91480838ac982c9