sqlite-web 0.7.2
gitea.db
package_version
Create
Query
access
access_token
action
action_artifact
action_run
action_run_index
action_run_job
action_runner
action_runner_token
action_schedule
action_schedule_spec
action_task
action_task_output
action_task_step
action_tasks_version
action_variable
app_state
attachment
auth_token
badge
branch
collaboration
comment
commit_status
commit_status_index
commit_status_summary
commit_sync_log
commit_sync_status
dbfs_data
dbfs_meta
deploy_key
email_address
email_hash
external_login_user
follow
gpg_key
gpg_key_import
hook_task
issue
issue_assignees
issue_content_history
issue_dependency
issue_index
issue_label
issue_pin
issue_user
issue_watch
label
language_stat
lfs_lock
lfs_meta_object
login_source
milestone
mirror
notice
notification
oauth2_application
oauth2_authorization_code
oauth2_grant
org_user
package
package_blob
package_blob_upload
package_cleanup_rule
package_file
package_property
package_version
project
project_board
project_issue
protected_branch
protected_tag
public_key
pull_auto_merge
pull_request
push_mirror
reaction
release
renamed_branch
repo_archiver
repo_hidden_file
repo_indexer_status
repo_license
repo_redirect
repo_topic
repo_transfer
repo_unit
repository
review
review_state
secret
session
sqlite_sequence
star
stopwatch
system_setting
task
team
team_invite
team_repo
team_unit
team_user
topic
tracked_time
two_factor
upload
user
user_badge
user_blocking
user_open_id
user_redirect
user_setting
version
watch
webauthn_credential
webhook
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 8 in package_version
id
Primary key.
INTEGER NOT NULL
package_id
INTEGER NOT NULL
creator_id
INTEGER NOT NULL (default 0
version
1.0.0-rc.0
TEXT NOT NULL
lower_version
1.0.0-rc.0
TEXT NOT NULL
created_unix
INTEGER NOT NULL
is_internal
INTEGER NOT NULL (default 0
metadata_json
{"scope":"@juhai","name":"governance","description":"基础设施层跨仓门禁(设计方案 §9):check:pins(exact pin 消费规则)、check:fixtures(契约正反例夹具)、verify:candidate(候选可晋级核验)、release:manifest(已知事实清单)、CI 模板;零依赖 CLI,供上层仓 exact pin 后在 CI 运行。","license":"UNLICENSED","bin":{"juhai-governance":"bin/cli.mjs"},"readme":"# @juhai/governance — 基础设施跨仓门禁\n\n设计方案 §4.2 / §9 定义的 `governance/` 交付:一组**零依赖**的构建期检查,随基础设施仓同一 Release 版本号发布到 Gitea npm registry(DEC-031),供上层仓 **exact pin** 后在 CI 运行(`check:pins` 为必需检查,DEC-031 附带条款 4)。\n\n## 命令(`juhai-governance \u003ccommand\u003e [--root \u003cdir\u003e]`)\n\n| 命令 | 用途 | 报告 | 退出码 |\n|---|---|---|---|\n| `check:pins [--require \u003cpkg\u003e]…` | `@juhai/*` 依赖只允许 `x.y.z` 或 `workspace:*`;`--require` 要求该包至少一处 exact pin(证明消费者已接入) | 无(stdout) | 1 = 有违规 |\n| `check:fixtures --suite \u003csuite.json\u003e…` | 契约正反例夹具套件:ACCEPT 须零原因、REJECT 须有原因且含声明前缀;`format: dec-039` 复用既有检查器;`workspaceRelative` 套件在独立克隆里报告 unavailable | `reports/fixtures.latest.json` | 1 = 任一用例不符 |\n| `verify:candidate --candidate \u003cdir\u003e --sha \u003csha\u003e …` | 候选可晋级核验(Q12-C / X12):逐份 required 报告核 sourceSha / dirty / 状态 / 地板 / digest,缺失即不合格 | `\u003cdir\u003e/release-candidate.json` 或 `--out` | 1 = 不合格 |\n| `release:manifest` | 已知事实清单,**逐项按磁盘判定**:`governance/package.json`、`runtime/clients/\u003cm\u003e/package.json`(name 须为 `@juhai/client-\u003cm\u003e`)、`reports/image-digest.json`(`sha256:` 且 `sourceSha` = HEAD)、compose 镜像是否 `@sha256:` 锁定、`reports/sbom.spdx.json`、`reports/signature.json`;任一缺失即 `status=partial` 并写明缺什么,不判定晋级 | `reports/release-manifest.latest.json` | 0 |\n| `ci:template [--out \u003cfile\u003e]` | 输出消费者最小 CI 模板(私包认证 + check:pins + 可选夹具) | — | 0 |\n| `check:modules` / `check:module-imports` / `check:catalog` / `catalog:drift` | 基础设施仓内部门禁(依赖 `runtime/modules.json` 与 `contracts/catalogs`) | `reports/*.latest.json` | 1 = 违规(drift 默认 0) |\n| `check:migration-decs` | 仓纪律 3:`runtime/modules/*/prisma/migrations` 与 `identity/apps/*/prisma/migrations` 的 `migration.sql` 前 10 行须有 `-- decision: DEC-NNN` 且该 DEC 已批准;`state=shape` 模块不得有迁移;例外只能逐个迁移登记在 `migration-decs.exceptions.json`(条件失效判 `EXCEPTION_STALE`) | `reports/migration-decs.latest.json` | 1 = 违规 |\n| `check:facts [--candidates \u003cdir\u003e] [--report-only]` | §6.4:`modules.json` 声明的 Fact ⊆ `contracts/catalogs/facts.json` ∪ CHG-004 候选(候选须 `status: pending-dec` + `blocked_by`);候选目录不可用时报 `UNRESOLVED`(fail-closed)。**接入根 `pnpm check` 前置 CT-2 材料落地** | `reports/facts.latest.json` | 1 = 违规 / unresolved |\n| `check:caddy` | §5 / §7:`modules.json` 的 HTTP 契约经 `caddy-routes.json` 映射前缀后必须被 `stack/caddy/Caddyfile` 的 path 匹配器覆盖;`/healthz`、`X-Request-Id` 注入、`{$PLATFORM_API_UPSTREAM}` 必备;本机有 `caddy` 则 `caddy validate`,否则报告 `validate: skipped`(`CHECK_CADDY_DOCKER=1` 走 docker) | `reports/caddy.latest.json` | 1 = 违规 / 语法失败 |\n\n所有报告带 `provenance`(`gitSha` / `worktreeDirty` / `runner` 原值 / `runnerNormalized` / `runId`);`worktreeDirty` 忽略 latest 报告本身。\n\n`verify:candidate` 在候选源码工作树的根目录运行:从 `runtime/reports/baseline.json` 与 `identity/reports/baseline.json` 读取最低测试数量,不能用 artifact 自报的较低地板代替。报告须为对象,验收计数与地板须为正整数,治理报告须含固定必需指标且为零;缺失、`null`、数组、标量和显式 `PARTIAL` 状态均不合格。旧治理报告没有 `status` 字段时仍按必需指标核验。指定 `--run-id` 或运行于 GitHub Actions 时要求每份报告为 CI runner;本地诊断保留 local 来源,不代表远端验收。独立调用纯函数 `evaluateCandidate` 时须显式传入 `{ baselines, requireCi }`;CLI 自动读取源码基线。\n\n## 消费方接入\n\n```bash\npnpm add -D @juhai/governance@1.0.0-rc.0 # exact pin;.npmrc 配 @juhai 作用域到 Gitea registry\npnpm exec juhai-governance ci:template --out .github/workflows/platform-governance.yml\npnpm exec juhai-governance check:pins --require @juhai/contracts\n```\n\n夹具套件格式见 `check-fixtures.mjs` 头注;示例 `fixtures/contracts.suite.json`(正例取 `@juhai/contracts` 的 examples,反例故意破坏必填 / 类型 / 血缘字段)。\n\n## 本仓内\n\n`pnpm check`(仓根)已串联:`check:pins` → `check:modules` → `check:module-imports` → `check:catalog` → `catalog:drift` → `check:fixtures` → `check:migration-decs` → `check:caddy` → governance 测试 → contracts → runtime 静态门禁(`check:facts` 有脚本与测试,待 CHG-004 候选材料落地后入链)。`.github/CODEOWNERS` 按设计 §23 登记路径 → 角色占位,`test/codeowners.test.mjs` 断言覆盖面。`pnpm --dir governance test` 跑本包测试;`pnpm --dir governance pack` 产出可安装的 tgz(发布走 DEC-031 通道,需平台负责人确认)。\n","repository":{"type":"","url":""}}
TEXT
download_count
INTEGER NOT NULL (default 0
Update
Cancel