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 1117 from action
id
1117
user_id
5
op_type
5
act_user_id
5
repo_id
6
comment_id
0
is_deleted
0
ref_name
refs/heads/feat/base-service-v2-poc
is_private
0
content
{"Commits":[{"Sha1":"c438f31da
{"Commits":[{"Sha1":"c438f31dae2fd15bc8ae3fd5419a19394c7191cc","Message":"feat(shared): BaseServiceV2 PoC（RFC-0001 方案 B 类型签名验证）\n\nSprint 2 样本 PoC：验证 RFC-0001 方案 B 的 TypeScript 泛型约束\n(TModelKey extends keyof Prisma.TransactionClient) 在 Prisma 5.22 下可\n编译，且能让子类在编译期被强制声明真实的 Prisma model key。\n\n核心设计（对应 RFC-0001 方案 B）：\n\n1. backend/src/shared/services/base-service-v2.ts（226 行）\n - abstract class BaseServiceV2\u003cTEntity, TCreate, TUpdate, TModelKey\u003e\n - TModelKey 泛型约束：extends keyof Prisma.TransactionClient\n - 子类通过 protected abstract readonly modelKey: TModelKey 声明\n - create/update/delete 内部 prisma.$transaction(async tx =\u003e ...)：\n * 数据写入走 tx[this.modelKey]（绑定到 tx 客户端）\n * 事件发布走 publishEventInTransaction(tx, ...)（同事务）\n * 共享同一 $transaction → 彻底消除模式 A \"data write 绕 tx\" 假绿\n - 30s 事务超时默认值\n\n2. backend/src/shared/services/__examples__/base-service-v2-samples.ts（144 行）\n - 3 个样本子类演示 modelKey 泛型锁定：\n * ReconciliationServiceV2Sample（modelKey='auto_match_rules'）\n * RenewalsServiceV2Sample（modelKey='renewals'）\n * CourseServiceV2Sample（modelKey='hr_courses'）\n - 含反例注释：bogus_table 会触发 TypeScript 编译错误\n \"Type '\\\"not_a_real_table\\\"' does not satisfy the constraint\n 'keyof TransactionClient'\"，证明编译期约束有效\n\n验证：\n- tsc --noEmit 对新增文件零错误（全工作区其他错误均来自预存在的\n journey-orchestration 模块 Prisma schema 不同步问题，与本 PR 无关）\n- 本 PoC 不在生产路径上使用，不导入任何生产 controller/routes/main.ts\n- 纯技术可行性验证，供技术委员会评审 RFC-0001 方案 B\n\nSprint 2 正式迁移路线（RFC-0001 W5-W6）：\n1. 合并本 PoC 后，Backend Architect 基于 BaseServiceV2 产出 PR\n2. 按优先级顺序迁移：22 真 D → 6 A-override → 8 良性 override → 4 微竞态\n3. 用 V2 审计判据（PR #38）作为 gate，迁移完成后启用 --strict-v2\n\n关联：Q2 Sprint 2 预研 · RFC-0001 方案 B 技术可行性验证\n前序：#36 D-class 盘点 / #37 RFC-0001 / #38 V2 审计升级 / #39 Sprint 1 复盘\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-17T14:15:21+08:00"}],"HeadCommit":{"Sha1":"c438f31dae2fd15bc8ae3fd5419a19394c7191cc","Message":"feat(shared): BaseServiceV2 PoC（RFC-0001 方案 B 类型签名验证）\n\nSprint 2 样本 PoC：验证 RFC-0001 方案 B 的 TypeScript 泛型约束\n(TModelKey extends keyof Prisma.TransactionClient) 在 Prisma 5.22 下可\n编译，且能让子类在编译期被强制声明真实的 Prisma model key。\n\n核心设计（对应 RFC-0001 方案 B）：\n\n1. backend/src/shared/services/base-service-v2.ts（226 行）\n - abstract class BaseServiceV2\u003cTEntity, TCreate, TUpdate, TModelKey\u003e\n - TModelKey 泛型约束：extends keyof Prisma.TransactionClient\n - 子类通过 protected abstract readonly modelKey: TModelKey 声明\n - create/update/delete 内部 prisma.$transaction(async tx =\u003e ...)：\n * 数据写入走 tx[this.modelKey]（绑定到 tx 客户端）\n * 事件发布走 publishEventInTransaction(tx, ...)（同事务）\n * 共享同一 $transaction → 彻底消除模式 A \"data write 绕 tx\" 假绿\n - 30s 事务超时默认值\n\n2. backend/src/shared/services/__examples__/base-service-v2-samples.ts（144 行）\n - 3 个样本子类演示 modelKey 泛型锁定：\n * ReconciliationServiceV2Sample（modelKey='auto_match_rules'）\n * RenewalsServiceV2Sample（modelKey='renewals'）\n * CourseServiceV2Sample（modelKey='hr_courses'）\n - 含反例注释：bogus_table 会触发 TypeScript 编译错误\n \"Type '\\\"not_a_real_table\\\"' does not satisfy the constraint\n 'keyof TransactionClient'\"，证明编译期约束有效\n\n验证：\n- tsc --noEmit 对新增文件零错误（全工作区其他错误均来自预存在的\n journey-orchestration 模块 Prisma schema 不同步问题，与本 PR 无关）\n- 本 PoC 不在生产路径上使用，不导入任何生产 controller/routes/main.ts\n- 纯技术可行性验证，供技术委员会评审 RFC-0001 方案 B\n\nSprint 2 正式迁移路线（RFC-0001 W5-W6）：\n1. 合并本 PoC 后，Backend Architect 基于 BaseServiceV2 产出 PR\n2. 按优先级顺序迁移：22 真 D → 6 A-override → 8 良性 override → 4 微竞态\n3. 用 V2 审计判据（PR #38）作为 gate，迁移完成后启用 --strict-v2\n\n关联：Q2 Sprint 2 预研 · RFC-0001 方案 B 技术可行性验证\n前序：#36 D-class 盘点 / #37 RFC-0001 / #38 V2 审计升级 / #39 Sprint 1 复盘\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-17T14:15:21+08:00"},"CompareURL":"luoanwu/juhi-omni-knowledge-hub/compare/7b47df3186db279cfc071517a6c034aa213d926d...c438f31dae2fd15bc8ae3fd5419a19394c7191cc","Len":1}
...
created_unix
1776406533
Delete
Cancel