CodeSampleX

샘플

modernc.org/sqlite v1.23.1

검증된 샘플 — golang modernc.org/sqlite v1.23.1. go 1.26 · linux alpine/x64 · docker에서 contract를 실행해 통과했습니다: sql.Open with modernc.org/sqlite opens in-memory…

sha256:5dc1b62eada922ca90125c290021b0d1669e8b2b78ca3f83e5f4216a97164913

이 네트워크가 제공하는 것은 하나입니다. 빌드되는 샘플. 샌드박스에서 돌리고 서명된 영수증을 보관합니다. 등급을 매기지 않고 무엇도 보증하지 않습니다 — 같은 코드가 당신 환경에서 빌드되는지는 측정한 적이 없습니다. 통과한 계약 영수증을 낸 서로 다른 서명 키의 수입니다. 하나면 작성자 혼자이고, 둘 이상이면 다른 사람도 빌드했다는 뜻입니다. 키는 스스로 만드는 것이고 뒤에 등록된 신원이 없으므로, 세는 것은 사람이 아니라 키입니다. MIT-0

실행 증거

선언된 환경과 서명된 실행을 분리해 두었습니다. 이 샘플이 무엇을 어디서 실행했는지 그대로 볼 수 있습니다.

증거 기준
서명된 컨트랙트 통과
검증 영수증
1
빌드한 서명 키
1
선언된 환경 linux 24 · ubuntu · glibc 2.39 x64 go

검증 실행 환경

환경 컨트랙트 단계 실행일
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
목표
verify pkg:golang/modernc.org/sqlite@v1.23.1
패키지
생성일
2026-08-19T23:21:47Z

컨트랙트

  1. sql.Open with modernc.org/sqlite opens in-memory database and executes table DDL and DML operations
  2. db.Prepare and Stmt.Exec execute parameterized SQL insert queries and return LastInsertId
  3. sqlite.RegisterDeterministicScalarFunction registers custom Go functions callable in SQL queries
  4. Tx.Commit persists transactional changes and Tx.Rollback reverts uncommitted changes

파일

  • PROMPT.md
  • csx.json
  • go.mod
  • go.sum
  • main.go
  • spec.json
  • test/contract.go

소스 아티팩트 내려받기 (tar.gz)

소스

PROMPT.md
Clean-room public code sample — generation instructions

Write a brand-new, minimal, self-contained code sample in this clean-room directory.
Do not copy, paraphrase, or reference any existing project source. Work only from this spec.

A csx.json manifest scaffold already exists. Do not recreate it from memory. Preserve its case.goal, packages and symbols; fill its empty case.contract with exact assertions and correct its environment, commands and verifierAdapter for the files you generate.

Goal: verify pkg:golang/modernc.org/sqlite@v1.23.1
Kind: HOW

Use EXACTLY these public packages and versions:
  - pkg:golang/modernc.org/sqlite@v1.23.1
Constraints:
  - executionContext: node
Required runtime conditions:
  - ecosystem: npm
  - language: javascript
  - moduleSystem: cjs
  - packageManager: npm@10.9.8
  - runtime: node@22.23.2

Rules:
  - One focused purpose; the smallest project that proves the goal.
  - Include a contract test (test/contract.*) that runs OFFLINE and exits 0 exactly when the goal behavior works.
  - Pin every dependency with a lockfile so resolution is reproducible.
  - No secrets, credentials, or tokens. No real URLs (only example.com or localhost). No absolute paths.
  - No personal names, emails, company names, or project identifiers of any kind.
  - No binaries and no generated output (node_modules, dist, target, venv, .git, .env).
  - Keep it under 200 files and 256KB packed.
csx.json
{"case":{"caseId":"case:sha256:7c9834a2b96d9fe1b78d8f353ecd7488f4af896d6f9a7705e8e6a5f486af6df1","contract":["sql.Open with modernc.org/sqlite opens in-memory database and executes table DDL and DML operations","db.Prepare and Stmt.Exec execute parameterized SQL insert queries and return LastInsertId","sqlite.RegisterDeterministicScalarFunction registers custom Go functions callable in SQL queries","Tx.Commit persists transactional changes and Tx.Rollback reverts uncommitted changes"],"goal":"verify pkg:golang/modernc.org/sqlite@v1.23.1","kind":"HOW","packages":["pkg:golang/modernc.org/sqlite@v1.23.1"],"schemaVersion":1},"contractCommand":["go","run","./test"],"environment":{"arch":"x64","distro":"ubuntu","ecosystem":"golang","libc":"glibc","libcVersion":"2.39","os":"linux","osVersionBucket":"24","packageManager":"go","schemaVersion":1},"license":"MIT-0","packages":["pkg:golang/modernc.org/sqlite@v1.23.1"],"schemaVersion":1,"verifierAdapter":"golang@1"}
go.mod
module example.com/sample

go 1.26.6

require modernc.org/sqlite v1.23.1

require (
	github.com/dustin/go-humanize v1.0.1 // indirect
	github.com/google/uuid v1.3.0 // indirect
	github.com/kballard/go-shellquote v0.0.0-20180428030007-95032a82bc51 // indirect
	github.com/mattn/go-isatty v0.0.16 // indirect
	github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec // indirect
	golang.org/x/mod v0.3.0 // indirect
	golang.org/x/sys v0.0.0-20220811171246-fbc7d0a398ab // indirect
	golang.org/x/tools v0.0.0-20201124115921-2c860bdd6e78 // indirect
	golang.org/x/xerrors v0.0.0-20200804184101-5ec99f83aff1 // indirect
	lukechampine.com/uint128 v1.2.0 // indirect
	modernc.org/cc/v3 v3.40.0 // indirect
	modernc.org/ccgo/v3 v3.16.13 // indirect
	modernc.org/libc v1.22.5 // indirect
	modernc.org/mathutil v1.5.0 // indirect
	modernc.org/memory v1.5.0 // indirect
	modernc.org/opt v0.1.3 // indirect
	modernc.org/strutil v1.1.3 // indirect
	modernc.org/token v1.0.1 // indirect
)
go.sum
github.com/dustin/go-humanize v1.0.1 h1:GzkhY7T5VNhEkwH0PVJgjz+fX1rhBrR7pRT3mDkpeCY=
github.com/dustin/go-humanize v1.0.1/go.mod h1:Mu1zIs6XwVuF/gI1OepvI0qD18qycQx+mFykh5fBlto=
github.com/google/go-cmp v0.5.9 h1:O2Tfq5qg4qc4AmwVlvv0oLiVAGB7enBSJ2x2DqQFi38=
github.com/google/go-cmp v0.5.9/go.mod h1:17dUlkBOakJ0+DkrSSNjCkIjxS6bF9zb3elmeNGIjoY=
github.com/google/pprof v0.0.0-20221118152302-e6195bd50e26 h1:Xim43kblpZXfIBQsbuBVKCudVG457BR2GZFIz3uw3hQ=
github.com/google/pprof v0.0.0-20221118152302-e6195bd50e26/go.mod h1:dDKJzRmX4S37WGHujM7tX//fmj1uioxKzKxz3lo4HJo=
github.com/google/uuid v1.3.0 h1:t6JiXgmwXMjEs8VusXIJk2BXHsn+wx8BZdTaoZ5fu7I=
github.com/google/uuid v1.3.0/go.mod h1:TIyPZe4MgqvfeYDBFedMoGGpEw/LqOeaOT+nhxU+yHo=
github.com/kballard/go-shellquote v0.0.0-20180428030007-95032a82bc51 h1:Z9n2FFNUXsshfwJMBgNA0RU6/i7WVaAegv3PtuIHPMs=
github.com/kballard/go-shellquote v0.0.0-20180428030007-95032a82bc51/go.mod h1:CzGEWj7cYgsdH8dAjBGEr58BoE7ScuLd+fwFZ44+/x8=
github.com/mattn/go-isatty v0.0.16 h1:bq3VjFmv/sOjHtdEhmkEV4x1AJtvUvOJ2PFAZ5+peKQ=
github.com/mattn/go-isatty v0.0.16/go.mod h1:kYGgaQfpe5nmfYZH+SKPsOc2e4SrIfOl2e/yFXSvRLM=
github.com/mattn/go-sqlite3 v1.14.16 h1:yOQRA0RpS5PFz/oikGwBEqvAWhWg5ufRz4ETLjwpU1Y=
github.com/mattn/go-sqlite3 v1.14.16/go.mod h1:2eHXhiwb8IkHr+BDWZGa96P6+rkvnG63S2DGjv9HUNg=
github.com/pmezard/go-difflib v1.0.0 h1:4DBwDE0NGyQoBHbLQYPwSUPoCMWR5BEzIk/f1lZbAQM=
github.com/pmezard/go-difflib v1.0.0/go.mod h1:iKH77koFhYxTK1pcRnkKkqfTogsbg7gZNVY4sRDYZ/4=
github.com/remyoudompheng/bigfft v0.0.0-20200410134404-eec4a21b6bb0/go.mod h1:qqbHyh8v60DhA7CoWK5oRCqLrMHRGoxYCSS9EjAz6Eo=
github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec h1:W09IVJc94icq4NjY3clb7Lk8O1qJ8BdBEF8z0ibU0rE=
github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec/go.mod h1:qqbHyh8v60DhA7CoWK5oRCqLrMHRGoxYCSS9EjAz6Eo=
github.com/yuin/goldmark v1.2.1/go.mod h1:3hX8gzYuyVAZsxl0MRgGTJEmQBFcNTphYh9decYSb74=
golang.org/x/crypto v0.0.0-20190308221718-c2843e01d9a2/go.mod h1:djNgcEr1/C05ACkg1iLfiJU5Ep61QUkGW8qpdssI0+w=
golang.org/x/crypto v0.0.0-20191011191535-87dc89f01550/go.mod h1:yigFU9vqHzYiE8UmvKecakEJjdnWj3jj499lnFckfCI=
golang.org/x/crypto v0.0.0-20200622213623-75b288015ac9/go.mod h1:LzIPMQfyMNhhGPhUkYOs5KpL4U8rLKemX1yGLhDgUto=
golang.org/x/mod v0.3.0 h1:RM4zey1++hCTbCVQfnWeKs9/IEsaBLA8vTkd0WVtmH4=
golang.org/x/mod v0.3.0/go.mod h1:s0Qsj1ACt9ePp/hMypM3fl4fZqREWJwdYDEqhRiZZUA=
golang.org/x/net v0.0.0-20190404232315-eb5bcb51f2a3/go.mod h1:t9HGtf8HONx5eT2rtn7q6eTqICYqUVnKs3thJo3Qplg=
golang.org/x/net v0.0.0-20190620200207-3b0461eec859/go.mod h1:z5CRVTTTmAJ677TzLLGU+0bjPO0LkuOLi4/5GtJWs/s=
golang.org/x/net v0.0.0-20201021035429-f5854403a974/go.mod h1:sp8m0HH+o8qH0wwXwYZr8TS3Oi6o0r6Gce1SSxlDquU=
golang.org/x/sync v0.0.0-20190423024810-112230192c58/go.mod h1:RxMgew5VJxzue5/jJTE5uejpjVlOe/izrB70Jof72aM=
golang.org/x/sync v0.0.0-20201020160332-67f06af15bc9/go.mod h1:RxMgew5VJxzue5/jJTE5uejpjVlOe/izrB70Jof72aM=
golang.org/x/sys v0.0.0-20190215142949-d0b11bdaac8a/go.mod h1:STP8DvDyc/dI5b8T5hshtkjS+E42TnysNCUPdjciGhY=
golang.org/x/sys v0.0.0-20190412213103-97732733099d/go.mod h1:h1NjWce9XRLGQEsW7wpKNCjG9DtNlClVuFLEZdDNbEs=
golang.org/x/sys v0.0.0-20200930185726-fdedc70b468f/go.mod h1:h1NjWce9XRLGQEsW7wpKNCjG9DtNlClVuFLEZdDNbEs=
golang.org/x/sys v0.0.0-20220811171246-fbc7d0a398ab h1:2QkjZIsXupsJbJIdSjjUOgWK3aEtzyuh2mPt3l/CkeU=
golang.org/x/sys v0.0.0-20220811171246-fbc7d0a398ab/go.mod h1:oPkhp1MJrh7nUepCBck5+mAzfO9JrbApNNgaTdGDITg=
golang.org/x/text v0.3.0/go.mod h1:NqM8EUOU14njkJ3fqMW+pc6Ldnwhi/IjpwHt7yyuwOQ=
golang.org/x/text v0.3.3/go.mod h1:5Zoc/QRtKVWzQhOtBMvqHzDpF6irO9z98xDceosuGiQ=
golang.org/x/tools v0.0.0-20180917221912-90fa682c2a6e/go.mod h1:n7NCudcB/nEzxVGmLbDWY5pfWTLqBcC2KZ6jyYvM4mQ=
golang.org/x/tools v0.0.0-20191119224855-298f0cb1881e/go.mod h1:b+2E5dAYhXwXZwtnZ6UAqBI28+e2cm9otk0dWdXHAEo=
golang.org/x/tools v0.0.0-20201124115921-2c860bdd6e78 h1:M8tBwCtWD/cZV9DZpFYRUgaymAYAr+aIUTWzDaM3uPs=
golang.org/x/tools v0.0.0-20201124115921-2c860bdd6e78/go.mod h1:emZCQorbCU4vsT4fOWvOPXz4eW1wZW4PmDk9uLelYpA=
golang.org/x/xerrors v0.0.0-20190717185122-a985d3407aa7/go.mod h1:I/5z698sn9Ka8TeJc9MKroUUfqBBauWjQqLJ2OPfmY0=
golang.org/x/xerrors v0.0.0-20191011141410-1b5146add898/go.mod h1:I/5z698sn9Ka8TeJc9MKroUUfqBBauWjQqLJ2OPfmY0=
golang.org/x/xerrors v0.0.0-20200804184101-5ec99f83aff1 h1:go1bK/D/BFZV2I8cIQd1NKEZ+0owSTG1fDTci4IqFcE=
golang.org/x/xerrors v0.0.0-20200804184101-5ec99f83aff1/go.mod h1:I/5z698sn9Ka8TeJc9MKroUUfqBBauWjQqLJ2OPfmY0=
lukechampine.com/uint128 v1.2.0 h1:mBi/5l91vocEN8otkC5bDLhi2KdCticRiwbdB0O+rjI=
lukechampine.com/uint128 v1.2.0/go.mod h1:c4eWIwlEGaxC/+H1VguhU4PHXNWDCDMUlWdIWl2j1gk=
modernc.org/cc/v3 v3.40.0 h1:P3g79IUS/93SYhtoeaHW+kRCIrYaxJ27MFPv+7kaTOw=
modernc.org/cc/v3 v3.40.0/go.mod h1:/bTg4dnWkSXowUO6ssQKnOV0yMVxDYNIsIrzqTFDGH0=
modernc.org/ccgo/v3 v3.16.13 h1:Mkgdzl46i5F/CNR/Kj80Ri59hC8TKAhZrYSaqvkwzUw=
modernc.org/ccgo/v3 v3.16.13/go.mod h1:2Quk+5YgpImhPjv2Qsob1DnZ/4som1lJTodubIcoUkY=
modernc.org/ccorpus v1.11.6 h1:J16RXiiqiCgua6+ZvQot4yUuUy8zxgqbqEEUuGPlISk=
modernc.org/ccorpus v1.11.6/go.mod h1:2gEUTrWqdpH2pXsmTM1ZkjeSrUWDpjMu2T6m29L/ErQ=
modernc.org/httpfs v1.0.6 h1:AAgIpFZRXuYnkjftxTAZwMIiwEqAfk8aVB2/oA6nAeM=
modernc.org/httpfs v1.0.6/go.mod h1:7dosgurJGp0sPaRanU53W4xZYKh14wfzX420oZADeHM=
modernc.org/libc v1.22.5 h1:91BNch/e5B0uPbJFgqbxXuOnxBQjlS//icfQEGmvyjE=
modernc.org/libc v1.22.5/go.mod h1:jj+Z7dTNX8fBScMVNRAYZ/jF91K8fdT2hYMThc3YjBY=
modernc.org/mathutil v1.5.0 h1:rV0Ko/6SfM+8G+yKiyI830l3Wuz1zRutdslNoQ0kfiQ=
modernc.org/mathutil v1.5.0/go.mod h1:mZW8CKdRPY1v87qxC/wUdX5O1qDzXMP5TH3wjfpga6E=
modernc.org/memory v1.5.0 h1:N+/8c5rE6EqugZwHii4IFsaJ7MUhoWX07J5tC/iI5Ds=
modernc.org/memory v1.5.0/go.mod h1:PkUhL0Mugw21sHPeskwZW4D6VscE/GQJOnIpCnW6pSU=
modernc.org/opt v0.1.3 h1:3XOZf2yznlhC+ibLltsDGzABUGVx8J6pnFMS3E4dcq4=
modernc.org/opt v0.1.3/go.mod h1:WdSiB5evDcignE70guQKxYUl14mgWtbClRi5wmkkTX0=
modernc.org/sqlite v1.23.1 h1:nrSBg4aRQQwq59JpvGEQ15tNxoO5pX/kUjcRNwSAGQM=
modernc.org/sqlite v1.23.1/go.mod h1:OrDj17Mggn6MhE+iPbBNf7RGKODDE9NFT0f3EwDzJqk=
modernc.org/strutil v1.1.3 h1:fNMm+oJklMGYfU9Ylcywl0CO5O6nTfaowNsh2wpPjzY=
modernc.org/strutil v1.1.3/go.mod h1:MEHNA7PdEnEwLvspRMtWTNnp2nnyvMfkimT1NKNAGbw=
modernc.org/tcl v1.15.2 h1:C4ybAYCGJw968e+Me18oW55kD/FexcHbqH2xak1ROSY=
modernc.org/tcl v1.15.2/go.mod h1:3+k/ZaEbKrC8ePv8zJWPtBSW0V7Gg9g8rkmhI1Kfs3c=
modernc.org/token v1.0.1 h1:A3qvTqOwexpfZZeyI0FeGPDlSWX5pjZu9hF4lU+EKWg=
modernc.org/token v1.0.1/go.mod h1:UGzOrNV1mAFSEB63lOFHIpNRUVMvYTc6yu1SMY/XTDM=
modernc.org/z v1.7.3 h1:zDJf6iHjrnB+WRD88stbXokugjyc0/pB91ri1gO6LZY=
modernc.org/z v1.7.3/go.mod h1:Ipv4tsdxZRbQyLq9Q1M6gdbkxYzdlrciF2Hi/lS7nWE=
main.go
package main

import (
	"database/sql"
	"database/sql/driver"
	"fmt"
	"os"
	"strings"

	"modernc.org/sqlite"
)

func main() {
	// Register deterministic scalar function
	err := sqlite.RegisterDeterministicScalarFunction("custom_upper", 1, func(ctx *sqlite.FunctionContext, args []driver.Value) (driver.Value, error) {
		if len(args) == 0 || args[0] == nil {
			return nil, nil
		}
		str, ok := args[0].(string)
		if !ok {
			return fmt.Sprintf("%v", args[0]), nil
		}
		return strings.ToUpper(str), nil
	})
	if err != nil {
		fmt.Fprintf(os.Stderr, "failed to register scalar function: %v\n", err)
		os.Exit(1)
	}

	db, err := sql.Open("sqlite", ":memory:")
	if err != nil {
		fmt.Fprintf(os.Stderr, "failed to open database: %v\n", err)
		os.Exit(1)
	}
	defer db.Close()

	if _, err := db.Exec(`CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, score REAL NOT NULL);`); err != nil {
		fmt.Fprintf(os.Stderr, "failed to create table: %v\n", err)
		os.Exit(1)
	}

	stmt, err := db.Prepare("INSERT INTO users (name, score) VALUES (?, ?)")
	if err != nil {
		fmt.Fprintf(os.Stderr, "failed to prepare statement: %v\n", err)
		os.Exit(1)
	}
	defer stmt.Close()

	if _, err := stmt.Exec("alice", 95.5); err != nil {
		fmt.Fprintf(os.Stderr, "failed to insert user: %v\n", err)
		os.Exit(1)
	}

	var formattedName string
	var score float64
	if err := db.QueryRow("SELECT custom_upper(name), score FROM users WHERE name = ?", "alice").Scan(&formattedName, &score); err != nil {
		fmt.Fprintf(os.Stderr, "failed to query user: %v\n", err)
		os.Exit(1)
	}

	fmt.Printf("User: %s, Score: %.1f\n", formattedName, score)
}
spec.json
{
  "schemaVersion": 1,
  "goal": "verify pkg:golang/modernc.org/sqlite@v1.23.1",
  "kind": "HOW",
  "packages": [
    "pkg:golang/modernc.org/sqlite@v1.23.1"
  ],
  "constraints": {
    "executionContext": "node"
  },
  "runtimeConditions": {
    "ecosystem": "npm",
    "language": "javascript",
    "moduleSystem": "cjs",
    "packageManager": "npm@10.9.8",
    "runtime": "node@22.23.2"
  }
}
test/contract.go
package main

import (
	"database/sql"
	"database/sql/driver"
	"fmt"
	"os"
	"strings"

	"modernc.org/sqlite"
)

func main() {
	// Assertion 1: sql.Open with modernc.org/sqlite opens in-memory database and executes table DDL and DML operations
	db, err := sql.Open("sqlite", ":memory:")
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: sql.Open failed: %v\n", err)
		os.Exit(1)
	}
	defer db.Close()

	if err := db.Ping(); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: db.Ping failed: %v\n", err)
		os.Exit(1)
	}

	createTableSQL := `
	CREATE TABLE items (
		id INTEGER PRIMARY KEY AUTOINCREMENT,
		name TEXT NOT NULL,
		value REAL NOT NULL,
		active INTEGER NOT NULL DEFAULT 1
	);`
	if _, err := db.Exec(createTableSQL); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: CREATE TABLE failed: %v\n", err)
		os.Exit(1)
	}

	// Assertion 2: db.Prepare and Stmt.Exec execute parameterized SQL insert queries and return LastInsertId
	insertStmt, err := db.Prepare("INSERT INTO items (name, value, active) VALUES (?, ?, ?)")
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: Prepare insert failed: %v\n", err)
		os.Exit(1)
	}
	defer insertStmt.Close()

	res, err := insertStmt.Exec("Alpha", 12.34, 1)
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: insertStmt.Exec failed: %v\n", err)
		os.Exit(1)
	}
	lastID, err := res.LastInsertId()
	if err != nil || lastID != 1 {
		fmt.Fprintf(os.Stderr, "FAIL: LastInsertId expected 1, got %d, err: %v\n", lastID, err)
		os.Exit(1)
	}

	if _, err := insertStmt.Exec("Beta", 56.78, 1); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: insertStmt.Exec 2 failed: %v\n", err)
		os.Exit(1)
	}

	var name string
	var val float64
	if err := db.QueryRow("SELECT name, value FROM items WHERE id = ?", 2).Scan(&name, &val); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: QueryRow failed: %v\n", err)
		os.Exit(1)
	}
	if name != "Beta" || val != 56.78 {
		fmt.Fprintf(os.Stderr, "FAIL: QueryRow values mismatch: got %s, %f\n", name, val)
		os.Exit(1)
	}

	// Assertion 3: sqlite.RegisterDeterministicScalarFunction registers custom Go functions callable in SQL queries
	err = sqlite.RegisterDeterministicScalarFunction("contract_upper", 1, func(ctx *sqlite.FunctionContext, args []driver.Value) (driver.Value, error) {
		if len(args) == 0 || args[0] == nil {
			return nil, nil
		}
		str, ok := args[0].(string)
		if !ok {
			return fmt.Sprintf("%v", args[0]), nil
		}
		return strings.ToUpper(str), nil
	})
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: RegisterDeterministicScalarFunction failed: %v\n", err)
		os.Exit(1)
	}

	dbFunc, err := sql.Open("sqlite", ":memory:")
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: sql.Open for dbFunc failed: %v\n", err)
		os.Exit(1)
	}
	defer dbFunc.Close()

	var upperResult string
	if err := dbFunc.QueryRow("SELECT contract_upper('sample_text')").Scan(&upperResult); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: QueryRow with contract_upper failed: %v\n", err)
		os.Exit(1)
	}
	if upperResult != "SAMPLE_TEXT" {
		fmt.Fprintf(os.Stderr, "FAIL: contract_upper expected 'SAMPLE_TEXT', got '%s'\n", upperResult)
		os.Exit(1)
	}

	// Assertion 4: Tx.Commit persists transactional changes and Tx.Rollback reverts uncommitted changes
	txRollback, err := db.Begin()
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: db.Begin for rollback failed: %v\n", err)
		os.Exit(1)
	}
	if _, err := txRollback.Exec("INSERT INTO items (name, value, active) VALUES (?, ?, ?)", "Gamma", 99.9, 0); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: txRollback.Exec failed: %v\n", err)
		os.Exit(1)
	}
	if err := txRollback.Rollback(); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: txRollback.Rollback failed: %v\n", err)
		os.Exit(1)
	}

	var count int
	if err := db.QueryRow("SELECT COUNT(*) FROM items WHERE name = 'Gamma'").Scan(&count); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: QueryRow after rollback failed: %v\n", err)
		os.Exit(1)
	}
	if count != 0 {
		fmt.Fprintf(os.Stderr, "FAIL: Rollback did not discard row, count: %d\n", count)
		os.Exit(1)
	}

	txCommit, err := db.Begin()
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: db.Begin for commit failed: %v\n", err)
		os.Exit(1)
	}
	if _, err := txCommit.Exec("INSERT INTO items (name, value, active) VALUES (?, ?, ?)", "Delta", 42.0, 1); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: txCommit.Exec failed: %v\n", err)
		os.Exit(1)
	}
	if err := txCommit.Commit(); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: txCommit.Commit failed: %v\n", err)
		os.Exit(1)
	}

	if err := db.QueryRow("SELECT COUNT(*) FROM items WHERE name = 'Delta'").Scan(&count); err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: QueryRow after commit failed: %v\n", err)
		os.Exit(1)
	}
	if count != 1 {
		fmt.Fprintf(os.Stderr, "FAIL: Commit did not persist row, count: %d\n", count)
		os.Exit(1)
	}

	fmt.Println("PASS: modernc.org/sqlite contract passed")
}

오리진 시더

익명