샘플
github.com/glebarez/go-sqlite v1.21.2
검증된 샘플 — golang github.com/glebarez/go-sqlite v1.21.2. go 1.26 · linux alpine/x64 · docker에서 contract를 실행해 통과했습니다: sqlite.RegisterDeterministicScalarFunction…
sha256:3920e75bf3a8eae33fe5c62d53db666a74b365d7238d947afde9199bd0ccc54d
이 네트워크가 제공하는 것은 하나입니다. 빌드되는 샘플. 샌드박스에서 돌리고 서명된 영수증을 보관합니다. 등급을 매기지 않고 무엇도 보증하지 않습니다 — 같은 코드가 당신 환경에서 빌드되는지는 측정한 적이 없습니다.
통과한 계약 영수증을 낸 서로 다른 서명 키의 수입니다. 하나면 작성자 혼자이고, 둘 이상이면 다른 사람도 빌드했다는 뜻입니다. 키는 스스로 만드는 것이고 뒤에 등록된 신원이 없으므로, 세는 것은 사람이 아니라 키입니다.
MIT-0
실행 증거
선언된 환경과 서명된 실행을 분리해 두었습니다. 이 샘플이 무엇을 어디서 실행했는지 그대로 볼 수 있습니다.
- 증거 기준
- 서명된 컨트랙트 통과
- 검증 영수증
- 1
- 빌드한 서명 키
- 1
선언된 환경
go 1.26 linux 24 · ubuntu · glibc 2.39 x64 go 1.26 go go 1
검증 실행 환경
| 환경 | 컨트랙트 | 단계 | 실행일 |
|---|---|---|---|
| go 1.26 · linux alpine/x64 · docker ed25519:c1973797be207ac4 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · golang@1 |
2026-08-20 |
케이스
HOW- 목표
- verify pkg:golang/github.com/glebarez/go-sqlite@v1.21.2
- 환경
- go 1.26.6
- 생성일
- 2026-08-20T14:53:42Z
컨트랙트
- sqlite.RegisterDeterministicScalarFunction registers a deterministic scalar function callable within SQL queries
- sqlite.RegisterScalarFunction registers a scalar function that processes SQL query arguments and returns the evaluated result
- SQL queries executed on in-memory SQLite connections successfully invoke the registered custom functions and return expected values
파일
- PROMPT.md
- contract_test.go
- csx.json
- go.mod
- go.sum
- spec.json
소스
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/github.com/glebarez/go-sqlite@v1.21.2
Kind: HOW
Use EXACTLY these public packages and versions:
- pkg:golang/github.com/glebarez/go-sqlite@v1.21.2
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.
package sample
import (
"database/sql"
"database/sql/driver"
"fmt"
"testing"
"github.com/glebarez/go-sqlite"
)
func TestRegisterDeterministicScalarFunction(t *testing.T) {
err := sqlite.RegisterDeterministicScalarFunction("custom_reverse", 1, func(ctx *sqlite.FunctionContext, args []driver.Value) (driver.Value, error) {
if len(args) == 0 || args[0] == nil {
return nil, nil
}
s, ok := args[0].(string)
if !ok {
return nil, fmt.Errorf("expected string argument, got %T", args[0])
}
runes := []rune(s)
for i, j := 0, len(runes)-1; i < j; i, j = i+1, j-1 {
runes[i], runes[j] = runes[j], runes[i]
}
return string(runes), nil
})
if err != nil {
t.Fatalf("RegisterDeterministicScalarFunction failed: %v", err)
}
db, err := sql.Open("sqlite", ":memory:")
if err != nil {
t.Fatalf("sql.Open failed: %v", err)
}
defer db.Close()
var result string
err = db.QueryRow("SELECT custom_reverse('Hello CodeSampleX')").Scan(&result)
if err != nil {
t.Fatalf("QueryRow failed: %v", err)
}
expected := "XelpmaSedoC olleH"
if result != expected {
t.Fatalf("expected %q, got %q", expected, result)
}
}
func TestRegisterScalarFunction(t *testing.T) {
err := sqlite.RegisterScalarFunction("custom_add_suffix", 2, func(ctx *sqlite.FunctionContext, args []driver.Value) (driver.Value, error) {
if len(args) < 2 || args[0] == nil || args[1] == nil {
return nil, nil
}
base, ok1 := args[0].(string)
suffix, ok2 := args[1].(string)
if !ok1 || !ok2 {
return nil, fmt.Errorf("expected string arguments")
}
return base + "-" + suffix, nil
})
if err != nil {
t.Fatalf("RegisterScalarFunction failed: %v", err)
}
db, err := sql.Open("sqlite", ":memory:")
if err != nil {
t.Fatalf("sql.Open failed: %v", err)
}
defer db.Close()
var result string
err = db.QueryRow("SELECT custom_add_suffix('item', '123')").Scan(&result)
if err != nil {
t.Fatalf("QueryRow failed: %v", err)
}
expected := "item-123"
if result != expected {
t.Fatalf("expected %q, got %q", expected, result)
}
}
{"case":{"caseId":"case:sha256:2c194744e850b766d67cd8a8b08fc4f9f8f59925f70742804e84e61278739344","contract":["sqlite.RegisterDeterministicScalarFunction registers a deterministic scalar function callable within SQL queries","sqlite.RegisterScalarFunction registers a scalar function that processes SQL query arguments and returns the evaluated result","SQL queries executed on in-memory SQLite connections successfully invoke the registered custom functions and return expected values"],"goal":"verify pkg:golang/github.com/glebarez/go-sqlite@v1.21.2","kind":"HOW","packages":["pkg:golang/github.com/glebarez/go-sqlite@v1.21.2"],"schemaVersion":1,"symbols":["RegisterDeterministicScalarFunction","RegisterScalarFunction"]},"contractCommand":["go","test","-v","./..."],"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/glebarez/go-sqlite@v1.21.2"],"schemaVersion":1,"verifierAdapter":"golang@1"}
module sample
go 1.22
require github.com/glebarez/go-sqlite v1.21.2
require (
github.com/dustin/go-humanize v1.0.1 // indirect
github.com/google/uuid v1.3.0 // indirect
github.com/mattn/go-isatty v0.0.17 // indirect
github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec // indirect
golang.org/x/sys v0.7.0 // indirect
modernc.org/libc v1.22.5 // indirect
modernc.org/mathutil v1.5.0 // indirect
modernc.org/memory v1.5.0 // indirect
modernc.org/sqlite v1.23.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/glebarez/go-sqlite v1.21.2 h1:3a6LFC4sKahUunAmynQKLZceZCOzUthkRkEAl9gAXWo=
github.com/glebarez/go-sqlite v1.21.2/go.mod h1:sfxdZyhQjTM2Wry3gVYWaW072Ri1WMdWJi0k6+3382k=
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/mattn/go-isatty v0.0.17 h1:BTarxUcIeDqL27Mc+vyvdWYSL28zpIhv3RoTdsLMPng=
github.com/mattn/go-isatty v0.0.17/go.mod h1:kYGgaQfpe5nmfYZH+SKPsOc2e4SrIfOl2e/yFXSvRLM=
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=
golang.org/x/sys v0.0.0-20220811171246-fbc7d0a398ab/go.mod h1:oPkhp1MJrh7nUepCBck5+mAzfO9JrbApNNgaTdGDITg=
golang.org/x/sys v0.7.0 h1:3jlCCIQZPdOYu1h8BkNvLz8Kgwtae2cagcG/VamtZRU=
golang.org/x/sys v0.7.0/go.mod h1:oPkhp1MJrh7nUepCBck5+mAzfO9JrbApNNgaTdGDITg=
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/sqlite v1.23.1 h1:nrSBg4aRQQwq59JpvGEQ15tNxoO5pX/kUjcRNwSAGQM=
modernc.org/sqlite v1.23.1/go.mod h1:OrDj17Mggn6MhE+iPbBNf7RGKODDE9NFT0f3EwDzJqk=
{
"schemaVersion": 1,
"goal": "verify pkg:golang/github.com/glebarez/go-sqlite@v1.21.2",
"kind": "HOW",
"packages": [
"pkg:golang/github.com/glebarez/go-sqlite@v1.21.2"
],
"constraints": {
"executionContext": "node"
},
"runtimeConditions": {
"ecosystem": "npm",
"language": "javascript",
"moduleSystem": "cjs",
"packageManager": "npm@10.9.8",
"runtime": "node@22.23.2"
}
}
오리진 시더
익명