CodeSampleX

示例

Rewrite SQL queries with named parameters using pgx.NamedArgs, pgx.StrictNamedArgs, pgx.StructArgs, and pgx.StrictStructArgs

sha256:131a14492fa58a23e13d73e8003136e99833e1c106f643124de715af818965ed

发布状态。LOCAL_PASS 表示仅在作者环境中通过；PUBLISHED 表示已公开并等待独立验证；CROSS_PASS 表示另一验证者已复现；MATRIX_PASS 表示在不同环境中通过；STABLE 表示近期无失败且独立通过持续稳定。 证据强度。L0 仅有源码；L1 已解析依赖；L2 已编译或加载；L3 已通过契约；L4 已被独立复现；L5 已在不同环境中通过。 MIT-0

执行证据

分开显示声明环境和签名验证运行，明确样本的证明范围。

证据依据
独立交叉验证
验证回执
1
验证级别
L4_CROSS_PASS
声明的环境 linux 24 · ubuntu · glibc 2.39 x64 go wsl

验证运行环境

环境 契约 阶段 运行日期
go 1.26 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · golang@1		 2026-08-19

案例

HOW
目标
Rewrite SQL queries with named parameters using pgx.NamedArgs, pgx.StrictNamedArgs, pgx.StructArgs, and pgx.StrictStructArgs
包
符号
  • pgx.NamedArgs
  • pgx.StrictNamedArgs
  • pgx.StrictStructArgs
  • pgx.StructArgs
创建时间
2026-08-19T02:57:30Z

契约

  1. pgx.NamedArgs rewrites @name placeholders into positional $1 parameters, reuses parameter indices for repeated placeholders, and preserves PostgreSQL @@ operators without treating them as named placeholders
  2. pgx.NamedArgs allows unused arguments in the map and replaces missing query placeholders with nil values without error
  3. pgx.StrictNamedArgs returns an error when a query parameter is missing from the map or when unused keys are present in the map
  4. pgx.StructArgs converts struct and pointer fields with db tags (ignoring db:"-") into a query rewriter following NamedArgs semantics
  5. pgx.StrictStructArgs validates strict field matching and returns an error when struct fields are unreferenced in the query

文件

  • PROMPT.md
  • csx.json
  • go.mod
  • go.sum
  • main.go
  • spec.json
  • test/contract.go

下载源代码构件 (tar.gz)

原始种子者

匿名