sqlite-web 0.7.2
gitea.db
action_run
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 26621 in action_run
id
Primary key.
INTEGER NOT NULL
title
chore(evidence): record SRV-F8 gates on 39a905c
TEXT
repo_id
INTEGER
owner_id
INTEGER
workflow_id
governance.yml
TEXT
index
INTEGER
trigger_user_id
INTEGER
schedule_id
INTEGER
ref
refs/heads/main
TEXT
commit_sha
f78ca058510888b4b9049f8ba06d373f8b553636
TEXT
is_fork_pull_request
INTEGER
need_approval
INTEGER
approved_by
INTEGER
event
push
TEXT
event_payload
{"ref":"refs/heads/main","before":"f29f666abff0abbc473b0601069a043579679c68","after":"f78ca058510888b4b9049f8ba06d373f8b553636","compare_url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/compare/f29f666abff0abbc473b0601069a043579679c68...f78ca058510888b4b9049f8ba06d373f8b553636","commits":[{"id":"f78ca058510888b4b9049f8ba06d373f8b553636","message":"chore(evidence): record SRV-F8 gates on 39a905c\n\nNative latest reports from clean 39a905c (worktreeHash\nsha256:7b4a5701b7823eacd916dcf8e95f63808a5b3e1139b66ea2286505505029473b):\npnpm check exit 0 (ownTests 32, ownTestCases 193); check:runtime exit 0\n(169 passed, floor 143, RLS enforce, DB device_cloud_sr1028rt / Redis db1;\nturbo test tasks contracts, api-nestjs and web all successful);\nUI_MATRIX=1 check:ui exit 0 (nestjs/ws 9, nestjs/sse 9, ports 45730/45731;\nrerun because check:evidence binds the UI report to the current source);\ncheck:evidence exit 0. CLAUDE.md progress rows now name clean 39a905c\n(acceptance-successor scope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/commit/f78ca058510888b4b9049f8ba06d373f8b553636","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-28T08:08:06-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/ci-evidence.latest.json","reports/conformance-matrix.latest.json","reports/contract-consumers.latest.json","reports/device-boundaries.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/evidence-current.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance-rules.latest.json","reports/governance-status.latest.json","reports/governance.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json"]},{"id":"39a905cd8f2e98fa1a8c7dd0d6d06368f9e07ffc","message":"test(web): guard the late-probe drop in the SSE auth probe (SRV-F8)\n\nNew connector case: the auth probe times out, the connector reconnects\nand the new EventSource opens, then the stale probe resolves 401; the\nstatus must stay open with no timer left. With the `if (settled) return`\nguard removed the case is red on host Node 22 (pnpm test) and in\nnode:20-bookworm-slim (compiled output), 20 pass / 1 fail each; 21/21\nwith the guard. Test-only change; docs/CLAUDE.md test counts 20 -\u003e 21.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/commit/39a905cd8f2e98fa1a8c7dd0d6d06368f9e07ffc","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-28T08:05:27-07:00","added":[],"removed":[],"modified":["CLAUDE.md","apps/web/src/lib/realtime-connector.test.ts","docs/realtime-session-expiry.md"]},{"id":"756106504755ffc1fa3b88359b5a2f5ad6d6d6cc","message":"chore(evidence): record SRV-F5..F7 round-3 gates on 0b128f7\n\nNative latest reports from clean 0b128f7 (worktreeHash\nsha256:a4b332f6872313562caaf87988cdcfa38120f8b60cf2fea5a6e51d2dc9a8e816):\npnpm check exit 0 (ownTests 32, ownTestCases 192; test:scripts 113/113);\ncheck:device-boundaries exit 0; check:runtime exit 0 (169 passed, floor 143,\nRLS enforce, DB device_cloud_sr1028rt / Redis db1; turbo test tasks\ncontracts, api-nestjs and web all successful); UI_MATRIX=1 check:ui exit 0\n(nestjs/ws 9, nestjs/sse 9, ports 45730/45731); check:evidence exit 0;\ntest:s3:rules 46/46. Containers thing-sr-1028-*. CLAUDE.md progress rows\nnow name clean 0b128f7 (acceptance-successor scope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/commit/756106504755ffc1fa3b88359b5a2f5ad6d6d6cc","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-28T07:52:18-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/ci-evidence.latest.json","reports/conformance-matrix.latest.json","reports/contract-consumers.latest.json","reports/device-boundaries.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/evidence-current.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance-rules.latest.json","reports/governance-status.latest.json","reports/governance.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json"]},{"id":"0b128f7af10a4ef336e734f961f18aba2a522cee","message":"fix(web): bound the SSE auth probe and run connector tests on Node 20 (SRV-F5..F7)\n\n- SRV-F6: the closed-before-open SSE auth probe now has a 5 s limit\n measured by the connector (late results are dropped, timeout falls back\n to the backoff reconnect); the hook also aborts the fetch with\n AbortSignal.timeout(5000). New case: a probe that never answers leads\n to a reconnect; red on the 9199444 connector. Docs state that the local\n exp check depends on the client clock.\n- SRV-F5: 6e360ae was not a pure extraction: the timer callback clearing\n the reconnect handle fixes the old hook's double connection when\n \"online\" arrives while the backoff reconnect is CONNECTING. Documented,\n and locked by two new cases (WS/SSE), red on a mutant that keeps the\n handle (the old hook's behaviour).\n- SRV-F7: the web test script no longer relies on native type stripping\n or --test globs: it compiles the connector and its test to CommonJS with\n the existing tsc (tsconfig.unit.json, output under the ignored\n node_modules/.cache) and runs the file with node. 20/20 on host Node 22\n and in node:20-bookworm-slim (a failing mutant exits 1 there too), so\n it fits the root engines \"node \u003e=20\"; no dependency or lockfile change.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/commit/0b128f7af10a4ef336e734f961f18aba2a522cee","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-28T07:49:12-07:00","added":["apps/web/tsconfig.unit.json"],"removed":[],"modified":["CLAUDE.md","apps/web/package.json","apps/web/src/hooks/useRealtime.ts","apps/web/src/lib/realtime-connector.test.ts","apps/web/src/lib/realtime-connector.ts","docs/realtime-session-expiry.md"]},{"id":"ce5e8f61c1eb29fad098e5f1dcf3e2eedf6742b2","message":"chore(evidence): record SRV-F1..F4 round-2 gates on 9199444\n\nNative latest reports from clean 9199444 (worktreeHash\nsha256:cf80b74c6ecd2ab0142c0737a8b9c1d5df33903afd86d560f0f3f5a0bff224b0):\npnpm check exit 0 (ownTests 32, ownTestCases 190; test:scripts 113/113);\ncheck:device-boundaries exit 0; check:runtime run 1 exit 0 (169 passed,\nfloor 143, RLS enforce, DB device_cloud_sr1028rt / Redis db1; web\nnode --test 17/17 inside turbo test) and run 2 exit 0 (169 passed, DB\ndevice_cloud_sr1028rtb / Redis db3; the committed runtime report is run 2);\nUI_MATRIX=1 check:ui exit 0 (nestjs/ws 9, nestjs/sse 9, ports 45730/45731);\ncheck:evidence exit 0; test:s3:rules 46/46. Containers thing-sr-1028-*.\nCLAUDE.md progress rows now name clean 9199444 (acceptance-successor\nscope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/commit/ce5e8f61c1eb29fad098e5f1dcf3e2eedf6742b2","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-28T07:32:09-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/ci-evidence.latest.json","reports/conformance-matrix.latest.json","reports/contract-consumers.latest.json","reports/device-boundaries.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/evidence-current.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance-rules.latest.json","reports/governance-status.latest.json","reports/governance.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json"]}],"total_commits":0,"head_commit":{"id":"f78ca058510888b4b9049f8ba06d373f8b553636","message":"chore(evidence): record SRV-F8 gates on 39a905c\n\nNative latest reports from clean 39a905c (worktreeHash\nsha256:7b4a5701b7823eacd916dcf8e95f63808a5b3e1139b66ea2286505505029473b):\npnpm check exit 0 (ownTests 32, ownTestCases 193); check:runtime exit 0\n(169 passed, floor 143, RLS enforce, DB device_cloud_sr1028rt / Redis db1;\nturbo test tasks contracts, api-nestjs and web all successful);\nUI_MATRIX=1 check:ui exit 0 (nestjs/ws 9, nestjs/sse 9, ports 45730/45731;\nrerun because check:evidence binds the UI report to the current source);\ncheck:evidence exit 0. CLAUDE.md progress rows now name clean 39a905c\n(acceptance-successor scope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud/commit/f78ca058510888b4b9049f8ba06d373f8b553636","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-28T08:08:06-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/ci-evidence.latest.json","reports/conformance-matrix.latest.json","reports/contract-consumers.latest.json","reports/device-boundaries.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/evidence-current.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance-rules.latest.json","reports/governance-status.latest.json","reports/governance.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json"]},"repository":{"id":135,"owner":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"law@g-hi.com","avatar_url":"https://gitea.g-hi.com/avatar/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"},"name":"juhai-thing-cloud","full_name":"luoanwu/juhai-thing-cloud","description":"物云:02「物」域应用,自设备云 juhai-device-cloud 4652ce0 分叉","empty":false,"private":false,"fork":false,"template":false,"mirror":false,"size":4991,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhai-thing-cloud/languages","html_url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhai-thing-cloud","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/juhai-thing-cloud.git","clone_url":"https://gitea.g-hi.com/luoanwu/juhai-thing-cloud.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":2,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-10-12T21:14:44+08:00","updated_at":"2026-10-28T15:20:11+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_code":true,"has_issues":true,"internal_tracker":{"enable_time_tracker":true,"allow_only_contributors_to_track_time":true,"enable_issue_dependencies":true},"has_wiki":true,"has_pull_requests":true,"has_projects":true,"projects_mode":"all","has_releases":true,"has_packages":true,"has_actions":true,"ignore_whitespace_conflicts":false,"allow_merge_commits":true,"allow_rebase":true,"allow_rebase_explicit":true,"allow_squash_merge":true,"allow_fast_forward_only_merge":true,"allow_rebase_update":true,"allow_manual_merge":false,"autodetect_manual_merge":false,"default_delete_branch_after_merge":false,"default_merge_style":"merge","default_allow_maintainer_edit":true,"avatar_url":"","internal":false,"mirror_interval":"","object_format_name":"sha1","mirror_updated":"0001-01-01T00:00:00Z","topics":[],"licenses":[]},"pusher":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"},"sender":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"}}
TEXT
trigger_event
push
TEXT
status
INTEGER
version
INTEGER (default 0
started
INTEGER
stopped
INTEGER
previous_duration
INTEGER
created
INTEGER
updated
INTEGER
raw_concurrency
group: governance-${{ github.workflow }}-${{ github.ref }} cancel-in-progress: ${{ github.event_name == 'pull_request' }}
TEXT
concurrency_group
governance-governance.yml-refs/heads/main
TEXT NOT NULL (default ''
concurrency_cancel
INTEGER NOT NULL (default FALSE
Update
Cancel