샘플

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

MIT-0

실행 증거

선언된 환경과 서명된 검증 실행을 분리해 이 샘플이 실제로 증명하는 범위를 보여줍니다.

선언된 환경 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
패키지: github.com/jackc/pgx/v5 v5.10.0
생성일: 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

익명