サンプル

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

匿名