示例
drizzle-orm 0.45.2: Configure drizzle-orm with snake_case column casing across sqlite-proxy without losing casing in the dialect or dropping the relational query schema
已验证示例 — npm drizzle-orm 0.45.2: Configure drizzle-orm with snake_case column casing across sqlite-proxy without losing casing in the dialect or dropping the…
sha256:17faf4155357c9de9c0915953f971d73c724b4521f091bae8eba314358067c37
本网络只提供一件事：能构建的样本。它在沙箱中运行并保留签名回执。它不评级、不担保——同样的代码能否在你的环境构建，它没有测量过。
提交了通过的契约回执的不同签名密钥数量。为 1 表示只有作者；大于 1 表示还有其他人构建过。密钥是自行生成的，背后没有注册身份，因此计的是密钥而非人。
MIT-0
执行证据
声明的环境与签名的运行分开呈现，你可以看到这个样本究竟运行了什么、在哪里运行。
- 证据依据
- 签名契约通过
- 验证回执
- 2
- 构建过它的签名密钥
- 2
声明的环境
node linux x64 node node npm
验证运行环境
| 环境 | 契约 | 阶段 | 运行日期 |
|---|---|---|---|
| node 22 · linux alpine/x64 · docker ed25519:d91480838ac982c9 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · node-typescript@1 |
2026-08-16 |
| node 22 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · node-typescript@1 |
2026-08-18 |
案例
HOW- 目标
- Configure drizzle-orm with snake_case column casing across sqlite-proxy without losing casing in the dialect or dropping the relational query schema
- 符号
-
- drizzle
- drizzle-orm/sqlite-proxy
- sqliteTable
- text
- integer
- eq
- CasingCache
- toSnakeCase
- 环境
- node
- 创建时间
- 2026-08-16T06:23:38Z
契约
- assert column definitions without explicit names have keyAsName true while explicit names have keyAsName false
- assert CasingCache converts keyAsName column keys to snake_case but leaves explicit column names unchanged
- assert passing config in the 2nd argument to drizzle(proxy, config) matching TypeScript types silently drops casing because dialect instantiates from argument 3 before config normalization
- assert queries generated by the 2-argument drizzle instance emit raw JavaScript property names and fail at runtime against snake_case SQLite columns
- assert passing config as the 3rd argument with undefined batch callback activates dialect casing but leaves db.query empty because config normalization requires a truthy batch argument
- assert passing a batch callback function with config in the 3rd argument activates both dialect casing and relational query schema
- assert insert and select queries with snake_case casing generate SQL with snake_case columns and return rows mapped back to JavaScript camelCase property names
- assert relational queries execute successfully with snake_case column mapping and return typed schema records
文件
- NOTES.md
- csx.json
- package-lock.json
- package.json
- src/db.mjs
- test/contract.mjs