sqlite-web 0.7.2
gitea.db
action
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 1113 from action
id
1113
user_id
5
op_type
5
act_user_id
5
repo_id
6
comment_id
0
is_deleted
0
ref_name
refs/heads/feat/audit-outbox-tx-bound
is_private
0
content
{"Commits":[{"Sha1":"8a95110c2
{"Commits":[{"Sha1":"8a95110c2f089d5e800363910dee9bd22993258c","Message":"feat(audit): outbox-atomicity 新增 V2 判据 TX-BOUND-WRITE / ARRAY-TXN-WITH-EVENT\n\n对应 RFC-0001（BaseService 真正原子化）的审计脚本升级。在保留原有\nA/B/C/D 四分类判据不变的前提下，新增两类 WARNING 级判据暴露 Sprint 1 手工\n盘点中发现的两类系统性假绿：\n\n1. TX-BOUND-WRITE（模式 A · BaseService 架构级）\n - 扫描任一含 publishEvent/publishLifecycleEvent 调用的 service 文件\n - 对所有 this.model.\u003cwrite\u003e / prisma.\u003cmodel\u003e.\u003cwrite\u003e 出现位置，若其不在\n 任何 $transaction 回调 / tx-helper 函数范围内，记为 TX-BOUND-WRITE\n - 语义：data write 在默认 prisma client 上执行（未绑定 tx），publishEvent\n 失败或 tx 回滚时数据与事件会分裂\n\n2. ARRAY-TXN-WITH-EVENT（模式 B · 数组事务 + 事务外事件）\n - 扫描 prisma.$transaction([...]) / txn([...]) 数组形式事务\n - 若其所在方法体内（数组事务结束行之后）还有事务外的 publishEvent /\n publishLifecycleEvent 调用，则判 ARRAY-TXN-WITH-EVENT\n - 语义：数组事务无法传递 tx 客户端，后续事件必然独立事务\n\n输出设计：\n- V2 判据默认输出为 WARNING 级（不阻塞 CI），summary 新增\n v2TxBoundWrite / v2ArrayTxnWithEvent 两个计数\n- JSON 报告新增 v2Findings 数组记录 {ruleId, severity, file, line, code, hint}\n- 控制台输出前 15 条 finding，其余存档 JSON\n- 新增 --strict-v2 flag（B+C 为 0 时才触发），Sprint 2 完成迁移后可启用为\n 硬门禁\n\n首次运行结果（main HEAD）：\n- A=1633 / B=0 / C=0 / D=43 / 原子化率 100%（未退化）\n- TX-BOUND-WRITE: 297 命中（顶部文件 groupbuy-influencers=20 /\n supply-chain-platform=19 / geo-keywords=10 / price-books=10 /\n finance-credits=9）\n- ARRAY-TXN-WITH-EVENT: 5 命中（finance-credits 4 处 + 新发现\n price-books 1 处）\n\nARRAY-TXN-WITH-EVENT 5 处 100% 对应 Sprint 1 手工盘点（finance-credits 4 处\n+ 1 处 price-books 新发现），印证规则精度高。TX-BOUND-WRITE 297 处为 Sprint 2\n架构级迁移的全量攻击清单。\n\ntsc --noEmit 无新增错误。\n\n关联：Q2 Sprint 1 · Backend Architect RFC-0001 预研\n前序：#36 D-class 首轮盘点 / #37 D-class 深挖 + RFC-0001\n\nCo-Authored-By: Claude Opus 4.7 (1M context) \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"mluo@MluodeMacBook-Air.local","AuthorName":"Mluo","CommitterEmail":"mluo@MluodeMacBook-Air.local","CommitterName":"Mluo","Timestamp":"2026-04-17T13:14:22+08:00"}],"HeadCommit":{"Sha1":"8a95110c2f089d5e800363910dee9bd22993258c","Message":"feat(audit): outbox-atomicity 新增 V2 判据 TX-BOUND-WRITE / ARRAY-TXN-WITH-EVENT\n\n对应 RFC-0001（BaseService 真正原子化）的审计脚本升级。在保留原有\nA/B/C/D 四分类判据不变的前提下，新增两类 WARNING 级判据暴露 Sprint 1 手工\n盘点中发现的两类系统性假绿：\n\n1. TX-BOUND-WRITE（模式 A · BaseService 架构级）\n - 扫描任一含 publishEvent/publishLifecycleEvent 调用的 service 文件\n - 对所有 this.model.\u003cwrite\u003e / prisma.\u003cmodel\u003e.\u003cwrite\u003e 出现位置，若其不在\n 任何 $transaction 回调 / tx-helper 函数范围内，记为 TX-BOUND-WRITE\n - 语义：data write 在默认 prisma client 上执行（未绑定 tx），publishEvent\n 失败或 tx 回滚时数据与事件会分裂\n\n2. ARRAY-TXN-WITH-EVENT（模式 B · 数组事务 + 事务外事件）\n - 扫描 prisma.$transaction([...]) / txn([...]) 数组形式事务\n - 若其所在方法体内（数组事务结束行之后）还有事务外的 publishEvent /\n publishLifecycleEvent 调用，则判 ARRAY-TXN-WITH-EVENT\n - 语义：数组事务无法传递 tx 客户端，后续事件必然独立事务\n\n输出设计：\n- V2 判据默认输出为 WARNING 级（不阻塞 CI），summary 新增\n v2TxBoundWrite / v2ArrayTxnWithEvent 两个计数\n- JSON 报告新增 v2Findings 数组记录 {ruleId, severity, file, line, code, hint}\n- 控制台输出前 15 条 finding，其余存档 JSON\n- 新增 --strict-v2 flag（B+C 为 0 时才触发），Sprint 2 完成迁移后可启用为\n 硬门禁\n\n首次运行结果（main HEAD）：\n- A=1633 / B=0 / C=0 / D=43 / 原子化率 100%（未退化）\n- TX-BOUND-WRITE: 297 命中（顶部文件 groupbuy-influencers=20 /\n supply-chain-platform=19 / geo-keywords=10 / price-books=10 /\n finance-credits=9）\n- ARRAY-TXN-WITH-EVENT: 5 命中（finance-credits 4 处 + 新发现\n price-books 1 处）\n\nARRAY-TXN-WITH-EVENT 5 处 100% 对应 Sprint 1 手工盘点（finance-credits 4 处\n+ 1 处 price-books 新发现），印证规则精度高。TX-BOUND-WRITE 297 处为 Sprint 2\n架构级迁移的全量攻击清单。\n\ntsc --noEmit 无新增错误。\n\n关联：Q2 Sprint 1 · Backend Architect RFC-0001 预研\n前序：#36 D-class 首轮盘点 / #37 D-class 深挖 + RFC-0001\n\nCo-Authored-By: Claude Opus 4.7 (1M context) \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"mluo@MluodeMacBook-Air.local","AuthorName":"Mluo","CommitterEmail":"mluo@MluodeMacBook-Air.local","CommitterName":"Mluo","Timestamp":"2026-04-17T13:14:22+08:00"},"CompareURL":"luoanwu/juhi-omni-knowledge-hub/compare/7b47df3186db279cfc071517a6c034aa213d926d...8a95110c2f089d5e800363910dee9bd22993258c","Len":1}
...
created_unix
1776402871
Delete
Cancel