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
Delete row 43 from package_version
id
43
package_id
17
creator_id
5
version
1.0.0-rc.7
lower_version
1.0.0-rc.7
created_unix
1791622787
is_internal
0
metadata_json
{"scope":"@juhai","name":&
{"scope":"@juhai","name":"client-notification-webhook","description":"通知与 Webhook 中心远程客户端:把 notification-delivery-api.v1 的六个操作实现为对平台端点的调用;未配置即失败关闭(DEC-040 升格后由副作用半边改写而来)","license":"UNLICENSED","development_dependencies":{"@types/node":"22.19.20","typescript":"5.9.3","vitest":"2.1.9"},"readme":"# `@juhai/client-notification-webhook`(远程客户端)\n\nDEC-040 将路由、签名、重放防护和投递副作用迁入 `runtime/modules/notification-webhook`。本包调用 `notification-delivery-api.v1`,消费者只提交业务意图,不持有外发端点、主机白名单或签名密钥。\n\n未配置 `baseUrl`、传输失败、远端非 2xx、响应形状不合法或平台拒绝时均失败关闭。\n\n## 六个操作\n\n| 导出 | 作用 |\n|---|---|\n| `classifyEffect` | 判定重复投递、重放授权和尝试次数上限 |\n| `classifyProviderOutcome` | 将供应商结果分类为送达、重试、死信或永久失败 |\n| `planDelivery` | 从已批准策略取得路由计划 |\n| `refreshPolicy` | 提交策略快照换版 |\n| `deliver` | 幂等受理业务投递意图并由平台立即执行一次真实外发 |\n| `deliveryStatus` | 按当前租户读取安全裁剪后的投递状态与回执 |\n\n判定规则位于 `contracts/src/domain/notification-webhook/`,真实外发与 v2 HMAC 协议位于 `runtime/modules/notification-webhook/src/delivery/`。本客户端不实现内核端口,也不包含本地外发后备路径。\n\n## 当前交付状态\n\n- Catalog 仍为 `candidate_e0 / E0`,模块等级没有因本次验收自动提升。\n- 2026-09-23 已完成工单、巨嗨智服与巨嗨报价三个消费者的真实跨仓验收:实际通知任务调用平台 HTTP,平台按权限和已批准路由取测试凭据,完成 HTTPS v2 HMAC 外发、回执和双方账本状态回写。\n- 三消费者门槛当前为 3/3;生产启用仍等待 OpenBao、服务身份和目标策略。\n- 生产 `DeliveryCredentialResolver` 仍等待 OpenBao。测试凭据只在 `NODE_ENV=test` 下显式启用,不能作为生产后备路径。\n- 客户端包已登记但尚未进入发布列车。三个消费者使用各自仓内适配器调用同一平台契约,未依赖未发布包。\n\n## Webhook 签名协议\n\n当前协议为 v2:对 `JSON.stringify([\"v2\", timestamp, nonce, tenantId, idempotencyKey, body])` 做 HMAC-SHA256,把租户、幂等键、nonce、时间和原始正文一起绑定。v1 请求失败关闭;验签成功后才原子消费 nonce。\n\n## 后续缺口\n\n- 用 OpenBao / ServiceCredential 实现生产凭据解析并激活 `delivery-retry`。\n- 将客户端加入发布列车。\n- 邮件、短信等非 Webhook Provider 仍未覆盖。\n","repository":{"type":"","url":""}}
...
download_count
1
Delete
Cancel