Skip to content

Instantly share code, notes, and snippets.

@biingxiing
biingxiing / loomi-phase1-early-renewal-supplement.csv
Created May 22, 2026 12:25
Phase 1 名单补充 — 早续模型扫描发现的 5 个调整 (3 新增 / 1 修正 / 1 移除)
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 9 columns, instead of 5 in line 5.
category,user_id,action,observed_tier,observed_expires_at,expected_tier,expected_expires_at,delta_days,order_chain
8_early_renewal_drift,408906bc-5051-481a-94dc-83a1fdc4b62f,UPDATE_VALUE,free,,max,2026-06-14T10:24:43.241288+00:00,+27,"2026-04-15 pro -> 2026-04-18 max [早续]"
8_early_renewal_drift,d9e37cc2-ceae-48b6-baf9-8f7237db31ce,ADD,pro,2026-05-27T02:39:31+00:00,max,2026-06-17T06:02:08.130913+00:00,+21,"2026-01-18 pro -> 2026-01-28 max [早续] -> 2026-03-03 pro [早续保 max] -> 2026-03-16 max [早续] -> 2026-04-20 pro [早续保 max]"
1_zombie_early_renewal,4d686c65-8ee1-4faf-b19c-a0c7148357f7,ADD,free,,max,2026-06-04T12:30:05.049422+00:00,+13,"2026-03-06 pro -> 2026-03-18 max [早续] -> 2026-04-21 pro [早续保 max]"
8_early_renewal_drift,b6c4e91f-9298-4c05-a806-402cb4fd8008,ADD,pro,2026-05-24T06:53:56.316710+00:00,max,2026-06-03T10:15:23.762870+00:00,+10,"2026-01-30 pro -> 2026-03-05 pro -> 2026-03-19 max [早续升档] -> 2026-04-24 pro [早续保 max]"
self_fixed,af14f09a-bedc-4109-baf5-551489afc9ec,REMOVE,max,2026-06-21T09:12:38.207851+00:
@biingxiing
biingxiing / loomi-phase2-bucket-fix-list.csv
Last active May 22, 2026 02:57
Loomi Phase 2 修复名单 — credit_allocations 桶修复清单(基于 Phase 1 user_credits 修正后推算,2026-05-22 审计快照)
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 14 columns, instead of 2 in line 4.
category,user_id,action,skip_reason,note,effective_tier,effective_expires_at,fix_op,target_alloc_ids,new_original_amount,new_remaining,new_expires_at,suggest_tier_to_free,rationale
ZOMBIE_ALLOC,e9c27dd2-c093-4078-8301-cbc9a6ffc2e7,FIX,,低风险 retire(含 NOW 守卫),pro,2026-05-21T21:09:39.724676+00:00,RETIRE_ALLOC,"[""fdc6de60-3e59-43c6-85cc-33aaf5315069""]",,,,,订阅已失效(tier=free 或 zombie),retire 防 cron 啃 balance
NO_ACTIVE_ALLOC,067fc947-b2e1-4c78-b1d2-4c05b3a46c27,FIX,,直接 INSERT,不调 _create_allocation,pro,2026-05-31T18:12:37.840194+00:00,ISSUE_NEW_ALLOC,"[""edc6ee22-a963-433f-8759-77b2cea59e87""]",19200,19200,2026-05-31T18:12:37.840194+00:00,,tier=pro 标准额度=19200; retire 1 旧 depleted
NO_ACTIVE_ALLOC,4cba09fd-e831-4403-9973-8479140f710e,FIX,,直接 INSERT,不调 _create_allocation,pro,2026-06-18T20:53:00.562100+00:00,ISSUE_NEW_ALLOC,"[""a9896615-2e13-46f4-9269-1fb81f7c9e2c"", ""2f5d71f5-2539-49c9-a027-a3f88c6224e4""]",19200,19200,2026-06-18T20:53:00.562100+00:00,,tier=pro 标准额度=19200; retire 2 旧 depleted
NO_ACTIVE_ALLOC,7b7517