github.com/mattn/go-sqlite3 v1.14.49: Verify go-sqlite3 driver registration, SQLiteConn stub methods, and connection error handling under CGO_ENABLED=0

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 go-sqlite3 driver registration, SQLiteConn stub methods, and connection error handling under CGO_ENABLED=0
Kind: HOW

Use EXACTLY these public packages and versions:
  - pkg:golang/github.com/mattn/go-sqlite3@v1.14.49
Required runtime conditions:
  - ecosystem: golang
  - language: go
  - packageManager: go@1.26.6
  - runtime: go@1.26.6

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.

{"case":{"caseId":"case:sha256:1970ca80fdda2b6caa0bbcfb0a3c4fe7a463deb3b88443e22e823cdeeab81114","contract":["database/sql registers the sqlite3 driver name upon importing github.com/mattn/go-sqlite3","sql.Open returns a valid *sql.DB handle without attempting an immediate connection","db.Ping returns an error with message indicating binary was compiled with CGO_ENABLED=0 when cgo is disabled","sqlite3.SQLiteConn stub methods RegisterFunc, RegisterAggregator, and RegisterCollation return the CGO_ENABLED=0 error","sqlite3.SQLiteConn hook registration methods RegisterCommitHook, RegisterRollbackHook, RegisterUpdateHook, and RegisterAuthorizer execute cleanly"],"goal":"Verify go-sqlite3 driver registration, SQLiteConn stub methods, and connection error handling under CGO_ENABLED=0","kind":"HOW","packages":["pkg:golang/github.com/mattn/go-sqlite3@v1.14.49"],"schemaVersion":1},"contractCommand":["go","run","./test"],"environment":{"arch":"x64","distro":"ubuntu","ecosystem":"golang","language":"go","libc":"glibc","libcVersion":"2.39","os":"linux","osVersionBucket":"24","packageManager":"go","packageManagerVersion":"1.26.6","runtime":"go","runtimeVersion":"1.26.6","schemaVersion":1},"license":"MIT-0","packages":["pkg:golang/github.com/mattn/go-sqlite3@v1.14.49"],"schemaVersion":1,"subject":"pkg:golang/github.com/mattn/go-sqlite3@v1.14.49","verifierAdapter":"golang@1"}

module example.com/sample

go 1.26.6

require github.com/mattn/go-sqlite3 v1.14.49

github.com/mattn/go-sqlite3 v1.14.49 h1:B8jBHC3xhxZgxztrgruTuLucebnULQnx4W7cF7SAE9w=
github.com/mattn/go-sqlite3 v1.14.49/go.mod h1:6JTjA44L93a0QCyJef5YvlPoKXntQPjzWv5gtm9sB6w=

package main

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

	_ "github.com/mattn/go-sqlite3"
)

func main() {
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil {
		fmt.Printf("failed to open database handle: %v\n", err)
		return
	}
	defer db.Close()

	err = db.Ping()
	if err != nil {
		if strings.Contains(err.Error(), "CGO_ENABLED=0") {
			fmt.Println("Detected CGO_ENABLED=0 environment: go-sqlite3 requires cgo for database operations")
			return
		}
		fmt.Printf("unexpected ping error: %v\n", err)
		return
	}

	fmt.Println("Database connection established successfully")
}

{
  "schemaVersion": 1,
  "goal": "Verify go-sqlite3 driver registration, SQLiteConn stub methods, and connection error handling under CGO_ENABLED=0",
  "kind": "HOW",
  "packages": [
    "pkg:golang/github.com/mattn/go-sqlite3@v1.14.49"
  ],
  "runtimeConditions": {
    "ecosystem": "golang",
    "language": "go",
    "packageManager": "go@1.26.6",
    "runtime": "go@1.26.6"
  }
}

package main

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

	"github.com/mattn/go-sqlite3"
)

func main() {
	// Contract 1: database/sql registers the sqlite3 driver name upon importing github.com/mattn/go-sqlite3
	var registered bool
	for _, driver := range sql.Drivers() {
		if driver == "sqlite3" {
			registered = true
			break
		}
	}
	if !registered {
		fmt.Fprintln(os.Stderr, "FAIL: sqlite3 driver is not registered in database/sql")
		os.Exit(1)
	}

	// Contract 2: sql.Open returns a valid *sql.DB handle without attempting an immediate connection
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil {
		fmt.Fprintf(os.Stderr, "FAIL: sql.Open failed: %v\n", err)
		os.Exit(1)
	}
	defer db.Close()

	if db == nil {
		fmt.Fprintln(os.Stderr, "FAIL: sql.Open returned nil *sql.DB")
		os.Exit(1)
	}

	// Contract 3: db.Ping returns an error with message indicating binary was compiled with CGO_ENABLED=0 when cgo is disabled
	pingErr := db.Ping()
	if pingErr == nil {
		fmt.Fprintln(os.Stderr, "FAIL: expected db.Ping to return error when compiled with CGO_ENABLED=0")
		os.Exit(1)
	}
	expectedStubMsg := "Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub"
	if !strings.Contains(pingErr.Error(), expectedStubMsg) {
		fmt.Fprintf(os.Stderr, "FAIL: db.Ping error message mismatch. Got: %q, Expected substring: %q\n", pingErr.Error(), expectedStubMsg)
		os.Exit(1)
	}

	// Contract 4: sqlite3.SQLiteConn stub methods RegisterFunc, RegisterAggregator, and RegisterCollation return the CGO_ENABLED=0 error
	conn := &sqlite3.SQLiteConn{}
	errFunc := conn.RegisterFunc("test_func", func() {}, true)
	if errFunc == nil || !strings.Contains(errFunc.Error(), expectedStubMsg) {
		fmt.Fprintf(os.Stderr, "FAIL: RegisterFunc did not return expected stub error: %v\n", errFunc)
		os.Exit(1)
	}

	errAgg := conn.RegisterAggregator("test_agg", nil, true)
	if errAgg == nil || !strings.Contains(errAgg.Error(), expectedStubMsg) {
		fmt.Fprintf(os.Stderr, "FAIL: RegisterAggregator did not return expected stub error: %v\n", errAgg)
		os.Exit(1)
	}

	errColl := conn.RegisterCollation("test_coll", func(a, b string) int { return 0 })
	if errColl == nil || !strings.Contains(errColl.Error(), expectedStubMsg) {
		fmt.Fprintf(os.Stderr, "FAIL: RegisterCollation did not return expected stub error: %v\n", errColl)
		os.Exit(1)
	}

	// Contract 5: sqlite3.SQLiteConn hook registration methods RegisterCommitHook, RegisterRollbackHook, RegisterUpdateHook, and RegisterAuthorizer execute cleanly
	conn.RegisterCommitHook(func() int { return 0 })
	conn.RegisterRollbackHook(func() {})
	conn.RegisterUpdateHook(func(op int, db, table string, rowid int64) {})
	conn.RegisterAuthorizer(func(action int, arg1, arg2, db string) int { return 0 })

	fmt.Println("All contract assertions passed successfully.")
}