-- 附加仓产物(FE / 以后的后端等)。交付仓仍是 tasks/features 上的 repo_key + mr_url, -- 释义固定为 android/ios 客户端仓;附加仓不得再占用那两列。 -- -- 存量:曾经把 tt_im_monorepo 或开发任务 URL 写进原字段的行,抬进本表并把原字段扳回 -- 交付仓释义。没有这类占用的行不插附加记录 —— 涉及集以之后各次运行的 repoList 为准。 CREATE TABLE IF NOT EXISTS "code_sidecars" ( "target_kind" text NOT NULL, "target_id" text NOT NULL, "repo_key" text NOT NULL, "branch_name" text, "channel" text NOT NULL, "url" text, "failure_reason" text, "updated_at" bigint NOT NULL, PRIMARY KEY ("target_kind", "target_id", "repo_key") ); CREATE INDEX IF NOT EXISTS code_sidecars_target_idx ON "code_sidecars" ("target_kind", "target_id"); INSERT INTO "code_sidecars" ( "target_kind", "target_id", "repo_key", "branch_name", "channel", "url", "failure_reason", "updated_at" ) SELECT 'bug', t.id, 'tt-im-monorepo', t.branch_name, 'bits-dev-task', CASE WHEN t.mr_url LIKE '%/develop/detail/%' OR t.mr_url LIKE '%devops_space_type=server_fe%' THEN t.mr_url ELSE NULL END, CASE WHEN t.failure_reason LIKE 'MR 提交%' AND (t.failure_reason LIKE '%开发任务%' OR t.failure_reason LIKE '%tt_im_monorepo%') THEN t.failure_reason ELSE NULL END, COALESCE(t.status_changed_at, t.created_at) FROM "tasks" t WHERE t.repo_key = 'tt-im-monorepo' OR COALESCE(t.mr_url, '') LIKE '%/develop/detail/%' OR COALESCE(t.mr_url, '') LIKE '%devops_space_type=server_fe%' ON CONFLICT DO NOTHING; INSERT INTO "code_sidecars" ( "target_kind", "target_id", "repo_key", "branch_name", "channel", "url", "failure_reason", "updated_at" ) SELECT 'feature', f.id, 'tt-im-monorepo', f.branch_name, 'bits-dev-task', CASE WHEN f.mr_url LIKE '%/develop/detail/%' OR f.mr_url LIKE '%devops_space_type=server_fe%' THEN f.mr_url ELSE NULL END, CASE WHEN f.failure_reason LIKE 'MR 提交%' AND (f.failure_reason LIKE '%开发任务%' OR f.failure_reason LIKE '%tt_im_monorepo%') THEN f.failure_reason ELSE NULL END, COALESCE(f.status_changed_at, f.created_at) FROM "features" f WHERE f.repo_key = 'tt-im-monorepo' OR COALESCE(f.mr_url, '') LIKE '%/develop/detail/%' OR COALESCE(f.mr_url, '') LIKE '%devops_space_type=server_fe%' ON CONFLICT DO NOTHING; -- 旧卫星 first-hit 写成 sidecar key,等价于交付仓没命中。写成 platform 默认仓会 -- 谎称分支在客户端仓上,自动建 MR 就会变成「source branch not found」。 UPDATE "tasks" SET "repo_key" = 'unpushed' WHERE "repo_key" = 'tt-im-monorepo'; UPDATE "features" SET "repo_key" = 'unpushed' WHERE "repo_key" = 'tt-im-monorepo'; UPDATE "tasks" SET "mr_url" = NULL, "mr_state" = NULL, "mr_merged_at" = NULL, "mr_synced_at" = NULL WHERE "mr_url" LIKE '%/develop/detail/%' OR "mr_url" LIKE '%devops_space_type=server_fe%'; UPDATE "features" SET "mr_url" = NULL WHERE "mr_url" LIKE '%/develop/detail/%' OR "mr_url" LIKE '%devops_space_type=server_fe%'; UPDATE "tasks" SET "failure_reason" = NULL WHERE "failure_reason" LIKE 'MR 提交%' AND ("failure_reason" LIKE '%开发任务%' OR "failure_reason" LIKE '%tt_im_monorepo%'); UPDATE "features" SET "failure_reason" = NULL WHERE "failure_reason" LIKE 'MR 提交%' AND ("failure_reason" LIKE '%开发任务%' OR "failure_reason" LIKE '%tt_im_monorepo%');