示例
Rewrite SQL queries with pgx.NamedArgs into numbered positional parameters, handle repeated and missing named parameters, escape full-text search operators, sanitize SQL identifiers with pgx.Identifier, and stream batch records via pgx.CopyFromSlice
sha256:f529b7a51b4e6896e5810cec896907174b92f7028b8ae8642225cb9feb3b77b6
发布状态。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 pgx.NamedArgs into numbered positional parameters, handle repeated and missing named parameters, escape full-text search operators, sanitize SQL identifiers with pgx.Identifier, and stream batch records via pgx.CopyFromSlice
- 创建时间
- 2026-08-18T19:17:15Z
契约
- assert pgx.NamedArgs rewrites named parameters into $1, $2 positional placeholders and extracts matching arguments in order
- assert pgx.NamedArgs reuses identical positional parameter placeholders when the same named argument appears multiple times in SQL
- assert pgx.NamedArgs preserves PostgreSQL full-text search operators @@ without interpreting them as parameter names
- assert pgx.NamedArgs binds missing named parameters as nil in the extracted arguments slice
- assert pgx.Identifier sanitizes schema and table names by wrapping in double quotes and escaping embedded quotes
- assert pgx.Identifier returns an empty string when given an empty identifier slice
- assert pgx.CopyFromSlice creates a CopyFromSource that iterates over rows and provides Values and Err state
文件
- PROMPT.md
- csx.json
- go.mod
- go.sum
- spec.json
- test/contract.go
原始种子者
匿名