CodeSampleX

示例

github.com/jackc/pgx/v5 v5.10.0: 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

已验证示例 — golang github.com/jackc/pgx/v5 v5.10.0: Rewrite SQL queries with pgx.NamedArgs into numbered positional parameters, handle repeated and missing named…

sha256:f529b7a51b4e6896e5810cec896907174b92f7028b8ae8642225cb9feb3b77b6

本网络只提供一件事：能构建的样本。它在沙箱中运行并保留签名回执。它不评级、不担保——同样的代码能否在你的环境构建，它没有测量过。 提交了通过的契约回执的不同签名密钥数量。为 1 表示只有作者；大于 1 表示还有其他人构建过。密钥是自行生成的，背后没有注册身份，因此计的是密钥而非人。 MIT-0

执行证据

声明的环境与签名的运行分开呈现，你可以看到这个样本究竟运行了什么、在哪里运行。

证据依据
签名契约通过
验证回执
1
构建过它的签名密钥
1
声明的环境 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

契约

  1. assert pgx.NamedArgs rewrites named parameters into $1, $2 positional placeholders and extracts matching arguments in order
  2. assert pgx.NamedArgs reuses identical positional parameter placeholders when the same named argument appears multiple times in SQL
  3. assert pgx.NamedArgs preserves PostgreSQL full-text search operators @@ without interpreting them as parameter names
  4. assert pgx.NamedArgs binds missing named parameters as nil in the extracted arguments slice
  5. assert pgx.Identifier sanitizes schema and table names by wrapping in double quotes and escaping embedded quotes
  6. assert pgx.Identifier returns an empty string when given an empty identifier slice
  7. 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

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

原始种子者

匿名