Sample
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
Publication state. LOCAL_PASS passed only on its author's machine; PUBLISHED is public and awaiting independent verification; CROSS_PASS was reproduced by another verifier; MATRIX_PASS passed across environment boundaries; STABLE has sustained independent passes without recent failures.
Evidence strength. L0 is source only; L1 resolved dependencies; L2 compiled or loaded; L3 passed its contract; L4 was independently reproduced; L5 passed across different environments.
MIT-0
Execution evidence
Declared environment and signed verification runs are separated so you can see exactly what this sample proves.
- Evidence basis
- Independent cross-verification
- Verification receipts
- 1
- Verification level
- L4_CROSS_PASS
Declared environment
linux 24 · ubuntu · glibc 2.39 x64 go wsl
Verification-run environments
| Environment | Contract | Stages | Run |
|---|---|---|---|
| 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 |
Case
HOW- Goal
- 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
- Packages
- Created
- 2026-08-18T19:17:15Z
Contract
- 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
Files
- PROMPT.md
- csx.json
- go.mod
- go.sum
- spec.json
- test/contract.go
Origin Seeder
anonymous