Files
api_user/scripts/diff_legacy_vs_new.js
lik 946160f3f4 feat: 用户多应用成员关系与微信扫码登录
- 新增 user_app / user_identity 模型、应用注册表与成员关系服务,启动时校验配置覆盖

- 新增微信开放平台扫码登录:二维码地址、回调与 ticket 换取 token

- 管理端接口改为路由层声明 appIds + 角色鉴权,新增批量用户信息、锁定、授权与个人配置

- 删除账号同步清理成员关系与外部身份,避免关系被新账号复用

- 补充多应用、应用配置、注册表测试与迁移/建号脚本
2026-11-06 19:47:51 +08:00

120 lines
3.3 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
"use strict";
/**
* 切读前全量 diff(R3)
*
* 用法:node scripts/diff_legacy_vs_new.js
*
* 逐用户 / 逐 appId / 逐 openid 比对旧 app 字段与新表:
* - 旧 app 的每个 key 必须能在 user_app 命中
* - 旧 app 的每个 wxopenid 必须能在 user_identity 命中且 userId 一致
* - source=migrated 的成员关系必须有对应的旧 app 条目
*
* 输出 0 差异才允许发布;有差异时退出码为 1。
*/
import { DBModel } from "../models/index.js";
import { APP_REGISTRY } from "../models/app_registry.js";
import { normalizeString } from "../models/user_membership.js";
async function main() {
DBModel.init();
await DBModel.dbConnection.asPromise();
const diffs = [];
const stats = { users: 0, apps: 0, openids: 0, migrated: 0 };
try {
const userCursor = DBModel.User.find({ app: { $type: "object" } })
.batchSize(100)
.lean()
.cursor();
for await (const user of userCursor) {
stats.users++;
for (const [appId, entry] of Object.entries(user.app || {})) {
stats.apps++;
const membership = await DBModel.UserApp.findOne({
userId: user._id,
appId,
}).lean();
if (!membership) {
diffs.push({ type: "missing_membership", userId: String(user._id), appId });
continue;
}
const openid = normalizeString(entry?.wxopenid);
if (!openid) continue;
stats.openids++;
const meta = APP_REGISTRY[appId] || { provider: "weixin-mini" };
const identity = await DBModel.UserIdentity.findOne({
appId,
provider: meta.provider,
openid,
}).lean();
if (!identity) {
diffs.push({ type: "missing_identity", userId: String(user._id), appId, openid });
continue;
}
if (String(identity.userId) !== String(user._id)) {
diffs.push({
type: "identity_user_mismatch",
userId: String(user._id),
appId,
openid,
actualUserId: String(identity.userId),
});
}
}
}
// 迁移来源的成员关系不能凭空多出来
const migratedCursor = DBModel.UserApp.find({ source: "migrated" })
.batchSize(100)
.lean()
.cursor();
for await (const membership of migratedCursor) {
stats.migrated++;
const user = await DBModel.User.findById(membership.userId)
.select("app")
.lean();
if (!user?.app?.[membership.appId]) {
diffs.push({
type: "extra_migrated_membership",
userId: String(membership.userId),
appId: membership.appId,
});
}
}
console.log("---------------------------------------------");
console.log(
`[diff] 用户 ${stats.users},旧 app 条目 ${stats.apps},openid ${stats.openids},迁移成员 ${stats.migrated}`
);
console.log(`[diff] 差异 ${diffs.length}`);
diffs.slice(0, 50).forEach((item) => console.error(" 差异:", JSON.stringify(item)));
if (diffs.length) {
process.exitCode = 1;
} else {
console.log("[diff] 0 差异,可以切读");
}
} finally {
await DBModel.dbConnection.close();
}
}
main().catch((err) => {
console.error("[diff] 失败:", err.message);
process.exitCode = 1;
});