示例
drizzle-orm 0.45.2: Compile SQL template ASTs, dialect parameter placeholders, relational filter operators, placeholder bindings, and schema reflections in drizzle-orm@0.45.2 across PostgreSQL, SQLite, and MySQL dialects
已验证示例 — npm drizzle-orm 0.45.2: Compile SQL template ASTs, dialect parameter placeholders, relational filter operators, placeholder bindings, and schema…
sha256:21550ec2f787d3b888be21a06703a3194f099a5e2e5384dcab181946e980037e
本网络只提供一件事：能构建的样本。它在沙箱中运行并保留签名回执。它不评级、不担保——同样的代码能否在你的环境构建，它没有测量过。
提交了通过的契约回执的不同签名密钥数量。为 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-17 |
| 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- 目标
- Compile SQL template ASTs, dialect parameter placeholders, relational filter operators, placeholder bindings, and schema reflections in drizzle-orm@0.45.2 across PostgreSQL, SQLite, and MySQL dialects
- 符号
-
- sql
- eq
- and
- or
- inArray
- placeholder
- fillPlaceholders
- getTableColumns
- aliasedTable
- PgDialect
- SQLiteSyncDialect
- MySqlDialect
- 环境
- node
- 创建时间
- 2026-08-17T17:33:27Z
契约
- PgDialect compiles sql template tag expressions into PostgreSQL numbered placeholders ($1, $2), while SQLiteSyncDialect and MySqlDialect compile positional placeholders (?) with matching parameter bindings.
- assert PgDialect compiles sql template tag expressions into 1-based numbered placeholders $1, $2 with extracted parameter values
- assert SQLiteSyncDialect and MySqlDialect compile sql template tag expressions into positional question-mark placeholders with extracted parameter values
- assert escapeName and escapeString properly escape table identifiers and string literals across dialects
- assert sql.raw, sql.identifier, sql.join, and sql.empty compose raw fragments, quoted identifiers, and empty tokens into SQL ASTs
- assert placeholder and fillPlaceholders bind parameter objects or throw an error when a declared placeholder key is missing
- assert relational comparison and logical filter operators (eq, ne, gt, gte, lt, lte, and, or, not, inArray, notInArray, isNull, isNotNull, between, notBetween, like, notLike, ilike, notIlike) generate correct SQL syntax and parameter lists
- assert getTableColumns and getTableName reflect schema column properties while aliasedTable properly scopes column identifiers in compiled queries
- assert PgDialect and SQLiteSyncDialect buildDeleteQuery and buildUpdateQuery generate dialect-specific parameterized queries
文件
- NOTES.md
- csx.json
- package-lock.json
- package.json
- test/contract.mjs