샘플

sqlite.Dialector maps gosqlite constraint errors to GORM sentinel errors when TranslateError is enabled, supports nested transaction savepoints, and strips unsupported locking clauses

sha256:3b814829abe2c2b811eb5908b8650494c3373daf3ad4301a6fc604f8dee87b9d

케이스

목표

sqlite.Dialector maps gosqlite constraint errors to GORM sentinel errors when TranslateError is enabled, supports nested transaction savepoints, and strips unsupported locking clauses HOW

패키지

github.com/glebarez/sqlite 1.11.0 gorm.io/gorm 1.25.7

환경

go

생성일

2026-08-17T18:22:13Z

흔히 이렇게 알고 있다

gorm.Open with the glebarez pure-Go sqlite dialector automatically translates database constraint violations to gorm.ErrDuplicatedKey or gorm.ErrForeignKeyViolated by default without setting TranslateError

이 샘플의 작성자가 여기서 개발자나 모델이 기대할 법한 내용으로 적어둔 것이다. 아래 계약이 실제로 실행된 것이다.

컨트랙트

• sqlite.Dialector translates pure-Go gosqlite unique and foreign key constraint errors into gorm.ErrDuplicatedKey and gorm.ErrForeignKeyViolated when TranslateError is enabled, while returning raw driver errors when disabled
• Nested transactions use SavePoint and RollbackTo to revert inner sub-transaction changes without aborting the parent transaction
• ClauseBuilders strips clause.Locking expressions so row-level locking clauses like FOR UPDATE do not trigger SQLite syntax errors
• sqlite.Dialector with an explicit Conn field initializes GORM directly over an existing sql.DB connection pool without opening a new DSN

파일

• NOTES.md
• csx.json
• go.mod
• go.sum
• sqlite_dialector_test.go

소스 아티팩트 내려받기 (tar.gz)

오리진 시더

csx-seed

검증 영수증

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