SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

user_id

INTEGER

op_type

INTEGER

act_user_id

INTEGER

repo_id

INTEGER

comment_id

INTEGER

is_deleted

INTEGER NOT NULL (default 0

ref_name

TEXT

is_private

INTEGER NOT NULL (default 0

content

{"Commits":[{"Sha1":"f29f666abff0abbc473b0601069a043579679c68","Message":"chore(evidence): record U2 realtime round-2 gates on 390c6f4\n\nNative latest reports from clean 390c6f4 (worktreeHash\nsha256:eb00120b04cef3e735f19adef064ffa395e67f9b5d35b6c42a27b9a111bc0cc2):\npnpm check exit 0 (ownTests 30, ownTestCases 174; test:scripts 113/113);\ncheck:device-boundaries exit 0; check:runtime exit 0 (164 passed, floor 143,\nRLS enforce, dedicated container DB device_cloud_rt1027run2 / Redis db5 on\nthing-rt-1027-*); UI_MATRIX=1 check:ui exit 0 (nestjs/ws 9, nestjs/sse 9,\nports 45722/45723); check:evidence exit 0; test:s3:rules 46/46. CLAUDE.md\nprogress rows now name clean 390c6f4 (acceptance-successor scope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T00:05:08-07:00"},{"Sha1":"390c6f436aeca8ae1d397a3a23540edc31cc28bb","Message":"test(realtime): close U2 realtime verifier findings RTV-F1..F4\n\n- RTV-F1: new case \"replay window\" — envelopes published via Redis while a\n  WS replay is in flight (buffered path) are withheld from the revoked\n  tenant and flushed after the replay tail. Mutation Ma (buffer flush\n  sends directly) turns it red (2/2 runs).\n- RTV-F2: new case \"ordering under load\" — 90 interleaved tenant-owned and\n  projection-judged events; WS and SSE, live and replay, assert seq equals\n  the enqueue order (strictly increasing) and no duplicate envelope id.\n  Mutations Me (SSE concatMap -\u003e mergeMap) and Mf (WS without the delivery\n  chain) turn it red.\n- RTV-F3: docs/u2-realtime-scope.md states that live connections do not\n  re-check token expiry or session revocation after the handshake\n  (pre-existing behaviour); PM-A06 here only covers device events gated by\n  the current projection.\n- RTV-F4: governance.registry.json (strengthen only) registers\n  realtime.audience.test.ts, realtime.device-scope.acceptance.test.ts and\n  device-v1b.revocation-read.acceptance.test.ts under device-v1a\n  strip.files (v1a is stripped first; the fixtures call /api/device-v1a).\n  Full strip simulation residue 9 -\u003e 3 (start afce4b4: 5; the remaining 3\n  are pre-existing and unrelated).\n\nNo source change under apps/api-nestjs/src. Verified before commit:\nrealtime.device-scope 7/7, check:quick 14/14.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T00:02:37-07:00"},{"Sha1":"f559a293bba1d96430c1e3703670f8a3fb4a90ba","Message":"chore(evidence): record U2 realtime gates on ce2619a\n\nNative latest reports from clean ce2619a (worktreeHash\nsha256:5e054037958daef5a177c715fb73f207748f4d41fc06c1d3bed39df176325016):\npnpm check exit 0 (ownTests 30, ownTestCases 172; test:scripts 113/113);\ncheck:device-boundaries exit 0; check:runtime exit 0 (162 passed, floor 143,\nRLS enforce, dedicated container DB device_cloud_rt1027run / Redis db5 on\nthing-rt-1027-*); UI_MATRIX=1 check:ui exit 0 (nestjs/ws 9, nestjs/sse 9,\nports 45722/45723); check:evidence exit 0; test:s3:rules 46/46. CLAUDE.md\nprogress rows now name clean ce2619a (acceptance-successor scope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-27T23:37:46-07:00"},{"Sha1":"ce2619af08ac73bcc20ac304c29201742d3dacf9","Message":"fix(realtime): judge WS/SSE envelopes against the subscriber's current device projection (U2 realtime)\n\nU2 realtime slice (01 存量应用升级/物云.md \"U2 受权只读首片\" — U2 covered HTTP\nonly; 01 权限计划 PM-06 / PM-A05 / PM-A06):\n- New events/realtime-audience.ts: every contract event type is classified\n  (connection / tenant / authority / device-projection). Non-authority\n  subjects need a current TenantDeviceView for device-projection events\n  (topology additionally needs topology:read); control-plane device events\n  (lifecycle, activation, transfer, V1a, grant.revoked incl. reason) are\n  authority-only; unclassified types are refused for non-authority subjects;\n  lookup errors fail closed. Device rules sit inside the devices strip markers.\n- WS gateway: per-connection ordered delivery chain; replay, replay buffer\n  and live push all pass the same gate right before send.\n- SSE: concatMap gate after concat(replay, live), order preserved; refused\n  persisted events do not advance Last-Event-ID.\n- Tests: realtime.device-scope.acceptance.test.ts (5 cases, JWT, real\n  outbox/dispatcher/Redis/WS/SSE): revoked tenant replay (WS+SSE), revocation\n  during open connections incl. in-flight rows, cross-tenant misaddressed /\n  id-subscribed / replay, observer gets no control-class or unclassified\n  envelopes, transfer write chain; positives for granted tenant and authority.\n  realtime.audience.test.ts (7 pure cases): classification guard over\n  REALTIME_EVENT_TYPES and rule semantics.\n- Before fix on afce4b4: all 5 acceptance cases red on the delivery\n  assertions (guard test: module missing).\n\nNo write-chain, contract, Prisma or migration change; no new command or\ndevice action; candidate directory stays default-closed. Revoked-party\nminimal notice and device-history lower bound (Grant validFrom) remain\nbusiness decisions (docs/u2-realtime-scope.md).\n\nVerified before commit: nestjs vitest 140 passed / 6 skipped (tenant.rls\nneeds provisioned roles; full gates rerun on the committed tree),\ncheck:quick 14/14.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-27T23:32:12-07:00"}],"HeadCommit":{"Sha1":"f29f666abff0abbc473b0601069a043579679c68","Message":"chore(evidence): record U2 realtime round-2 gates on 390c6f4\n\nNative latest reports from clean 390c6f4 (worktreeHash\nsha256:eb00120b04cef3e735f19adef064ffa395e67f9b5d35b6c42a27b9a111bc0cc2):\npnpm check exit 0 (ownTests 30, ownTestCases 174; test:scripts 113/113);\ncheck:device-boundaries exit 0; check:runtime exit 0 (164 passed, floor 143,\nRLS enforce, dedicated container DB device_cloud_rt1027run2 / Redis db5 on\nthing-rt-1027-*); UI_MATRIX=1 check:ui exit 0 (nestjs/ws 9, nestjs/sse 9,\nports 45722/45723); check:evidence exit 0; test:s3:rules 46/46. CLAUDE.md\nprogress rows now name clean 390c6f4 (acceptance-successor scope only).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T00:05:08-07:00"},"CompareURL":"luoanwu/juhai-thing-cloud/compare/afce4b4aa5caf3aec9c43c3c42b78bc883fb4121...f29f666abff0abbc473b0601069a043579679c68","Len":4}

TEXT

created_unix

INTEGER

Update row 43267 in action