示例
drizzle-orm 0.45.2: Escape embedded quotes in SQL identifiers and aliases across dialects in drizzle-orm to prevent syntax errors and injection breakout
已验证示例 — npm drizzle-orm 0.45.2: Escape embedded quotes in SQL identifiers and aliases across dialects in drizzle-orm to prevent syntax errors and injection…
sha256:57a6e36e26613c9d14c388a78043dcbcf145549d1919e796bc8c418b19542a17
本网络只提供一件事：能构建的样本。它在沙箱中运行并保留签名回执。它不评级、不担保——同样的代码能否在你的环境构建，它没有测量过。
提交了通过的契约回执的不同签名密钥数量。为 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- 目标
- Escape embedded quotes in SQL identifiers and aliases across dialects in drizzle-orm to prevent syntax errors and injection breakout
- 符号
-
- SQLiteSyncDialect.escapeName
- PgDialect.escapeName
- MySqlDialect.escapeName
- SingleStoreDialect.escapeName
- sql.identifier
- node:sqlite.DatabaseSync
- sqliteTable
- 环境
- node
- 创建时间
- 2026-08-16T06:23:42Z
契约
- assert drizzle-orm version is 0.45.2
- assert SQLiteSyncDialect.escapeName doubles embedded double-quotes as "" instead of leaving raw quotes unescaped
- assert PgDialect.escapeName doubles embedded double-quotes as "" instead of leaving raw quotes unescaped
- assert MySqlDialect.escapeName doubles embedded backticks as `` instead of leaving raw backticks unescaped
- assert SingleStoreDialect.escapeName doubles embedded backticks as `` instead of leaving raw backticks unescaped
- assert compiling sql.identifier with embedded quotes through SQLiteSyncDialect and PgDialect escapes quotes as ""
- assert compiling an aliased selection with embedded quotes via .as() routes through escapeName and produces doubled quotes
- assert executing a query with an escaped double-quoted identifier against in-memory node:sqlite succeeds and yields the exact unescaped column key
- assert an injection breakout payload inside sql.identifier remains safely enclosed in a single identifier without creating injected columns
文件
- NOTES.md
- csx.json
- package-lock.json
- package.json
- test/contract.mjs