Sample
Compile queries offline without a database by placing SHA-256 hashed schema metadata in .sqlx
sha256:5976b9a300ee8ce8a12b27e320be8dd0d3282421e285e71dec4661e76e3a24ce
PUBLISHED
L3_CONTRACT_PASS
MIT-0
Case
- Goal
- Compile queries offline without a database by placing SHA-256 hashed schema metadata in .sqlx HOW
- Packages
- sqlx 0.8.6
- Environment
- rust
- Created
- 2026-08-16T09:25:32Z
Contract
- assert sqlx query! compiles offline without network or DATABASE_URL when .sqlx/query-<sha256>.json exists
- assert SQLite INTEGER column maps statically to i64 and non-Option type when schema nullable is false
- assert query_as! maps offline-verified columns directly into user struct fields
- assert query metadata filename and hash field strictly equal SHA-256 hex digest of the SQL string
- assert mismatch between macro SQL and cached query field triggers hash collision compiler error
Files
- .sqlx/query-32eb28a813af42275021a27efe961c138e41bfa4b4a496fa7f54ba5e42565a9a.json
- .sqlx/query-34bccfa23ca19bad28998f77786fd0246fe803a0c9d37d64188683efb3c7d4c0.json
- Cargo.lock
- Cargo.toml
- NOTES.md
- csx.json
- src/lib.rs
Download the verified artifact (tar.gz) — the exact bytes the contract ran against
Origin Seeder
Verification receipts
- rust 1 · CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · cargo@1 · 2026-08-16 · ed25519:d91480838ac982c9