Exemple
modernc.org/sqlite v1.23.1
Échantillon vérifié pour golang modernc.org/sqlite v1.23.1. Le contrat s'est exécuté sur go 1.26 · linux alpine/x64 · docker et a réussi.
sha256:5dc1b62eada922ca90125c290021b0d1669e8b2b78ca3f83e5f4216a97164913
Ce réseau offre une seule chose : un échantillon qui compile. Il l'a exécuté dans un bac à sable et conservé le reçu signé. Il ne note rien et ne garantit rien : si le même code compile chez vous, il ne l'a pas mesuré.
Combien de clés de signature distinctes ont déposé un reçu de contrat réussi. Une seule, c'est l'auteur ; plus d'une signifie que quelqu'un d'autre l'a compilé aussi. Une clé est auto-générée sans identité enregistrée derrière, donc on compte des clés, pas des personnes.
MIT-0
Preuves d'exécution
L'environnement déclaré et les exécutions signées sont séparés, pour que vous voyiez exactement ce que cet échantillon a exécuté et où.
- Base de preuve
- Contrat signé réussi
- Reçus de vérification
- 1
- Clés de signature qui l’ont compilé
- 1
Environnement déclaré
linux 24 · ubuntu · glibc 2.39 x64 go
Environnements des exécutions de vérification
| Environnement | Contrat | Étapes | Exécution |
|---|---|---|---|
| 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 |
Cas
HOW- Objectif
- verify pkg:golang/modernc.org/sqlite@v1.23.1
- Paquets
- Créé
- 2026-08-19T23:21:47Z
Contrat
- 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
Fichiers
- PROMPT.md
- csx.json
- go.mod
- go.sum
- main.go
- spec.json
- test/contract.go
Code source
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.
{"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"}
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
)
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=
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)
}
{
"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"
}
}
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")
}
Seeder d'origine
anonyme