Files
persionalBrand/apps/api/scripts/migrate-food-template-content.ts

158 lines
6.8 KiB
TypeScript

/** 开发餐饮品牌的幂等内容迁移。保留旧记录为草稿,历史快照和提交不变。 */
import "reflect-metadata";
import fs from "node:fs";
import type { Prisma } from "@prisma/client";
import { PrismaClient } from "@prisma/client";
import { getTemplatePackageManifestForVisualKey } from "@personal-brand/config";
import { BrandReleaseService } from "../src/brand-release.service.js";
import { BrandReleaseApiService } from "../src/brand-release-api.service.js";
import type { PrismaService } from "../src/prisma.service.js";
const prisma = new PrismaClient();
const note = "餐饮模板结构化内容迁移 v3";
try {
const brand = await prisma.brandProfile.findUniqueOrThrow({ where: { slug: "default-brand" } });
if (
brand.templateKey !== "food" ||
(brand.config as Record<string, unknown>)?.visualTemplateKey !== "acheng-campus-food"
)
throw new Error("Migration is restricted to the development food brand");
const previous = await prisma.brandRelease.findFirst({
where: { brandId: brand.id },
orderBy: { version: "desc" },
});
if (previous?.note === note) {
console.log("Already migrated; no changes");
} else {
const trust = await prisma.trustContent.findMany({
where: { brandId: brand.id },
orderBy: { updatedAt: "desc" },
});
const forms = await prisma.inquiryForm.findMany({ where: { brandId: brand.id } });
const backup = `/tmp/food-template-content-backup-${Date.now()}.json`;
fs.writeFileSync(backup, JSON.stringify({ brand, trust, forms, previous }, null, 2), {
mode: 0o600,
});
console.log(`Backup: ${backup}`);
if (!process.argv.includes("--apply")) {
console.log("Dry run; pass --apply to migrate and publish");
} else {
const sample =
getTemplatePackageManifestForVisualKey("acheng-campus-food")!.sampleContent!.food!;
const releaseService = new BrandReleaseService(prisma as PrismaService);
const publisher = new BrandReleaseApiService(prisma as PrismaService, releaseService);
await prisma.$transaction(async (tx) => {
for (const type of ["schedule", "coverage", "process"]) {
const candidates = trust.filter((item) => item.type === type);
const structured = candidates.find(
(item) => item.config && Object.keys(item.config as object).length,
);
const current = structured ?? candidates[0];
const defaults = sample.trustContent.find((item) => item.type === type)!;
const config = {
...defaults.config,
...((structured?.config as Record<string, unknown>) ?? {}),
};
// 已有的结构化配置保留。旧配送记录中的用户地点保留在自取说明中。
if (type === "coverage") {
const custom = candidates.find(
(item) =>
item.title !== defaults.title && item.content !== "示例内容,待品牌主理人完善。",
);
if (custom && !structured)
config.pickupDetail = `${custom.content}。${String(config.pickupDetail)}`;
}
if (type === "schedule") {
if (config.weekdayDetail === "二号校门外小吃商业街 #07 号铺位 · 17:00 - 22:30")
config.weekdayDetail = defaults.config!.weekdayDetail;
if (config.weekendDetail === "白天承接团体单;晚间 18:00 - 23:00 体育馆南侧流动出摊")
config.weekendDetail = defaults.config!.weekendDetail;
const custom = candidates.find((item) => !item.config && item.summary && item.content);
if (custom) {
config.weekdayHours = custom.summary!.replace(/^周一(?:到|至)周五\s*/, "");
config.weekendHours = custom.content.replace(/^周六(?:到|至)周(?:天|日)\s*/, "");
}
}
if (current)
await tx.trustContent.update({
where: { id: current.id },
data: {
title: defaults.title,
content: "",
summary: null,
config: config as Prisma.InputJsonValue,
isPublished: true,
},
});
else
await tx.trustContent.create({
data: {
brandId: brand.id,
type,
title: defaults.title,
content: "",
config: config as Prisma.InputJsonValue,
isPublished: true,
},
});
await tx.trustContent.updateMany({
where: {
brandId: brand.id,
type,
id: {
in: candidates.filter((item) => item.id !== current?.id).map((item) => item.id),
},
},
data: { isPublished: false },
});
}
const supportedTypes = getTemplatePackageManifestForVisualKey(
"acheng-campus-food",
)!.trustContentTypes!.map((item) => item.type);
await tx.trustContent.updateMany({
where: { brandId: brand.id, type: { notIn: supportedTypes } },
data: { isPublished: false },
});
const form = forms.find((item) => item.targetType === "brand" && item.isEnabled);
if (!form) throw new Error("Expected existing brand inquiry form");
const oldFields = form.fieldsSnapshot as Array<Record<string, unknown>>;
const keys = new Set(sample.fields.map((field) => field.key));
const fields = [
...sample.fields.map((field) => ({
...field,
...oldFields.find((old) => old.key === field.key),
})),
...oldFields.filter((field) => !keys.has(String(field.key))),
];
await tx.inquiryForm.update({
where: { id: form.id },
data: {
name: sample.inquiryFormName,
fieldsSnapshot: fields as Prisma.InputJsonValue,
version: { increment: 1 },
},
});
const readiness = await publisher.readiness(brand.id, tx);
if (!readiness.ready)
throw new Error(JSON.stringify(readiness.checks.filter((check) => !check.passed)));
const snapshot = await releaseService.buildSnapshot(brand.id, tx);
await tx.brandRelease.updateMany({
where: { brandId: brand.id, status: "published" },
data: { status: "superseded" },
});
await tx.brandRelease.create({
data: {
brandId: brand.id,
version: (previous?.version ?? 0) + 1,
actorId: previous?.actorId ?? "content-migration",
note,
snapshot: snapshot as unknown as Prisma.InputJsonValue,
},
});
});
console.log("Migrated and published development food brand; old content retained as drafts");
}
}
} finally {
await prisma.$disconnect();
}