- 新增 user_app / user_identity 模型、应用注册表与成员关系服务,启动时校验配置覆盖 - 新增微信开放平台扫码登录:二维码地址、回调与 ticket 换取 token - 管理端接口改为路由层声明 appIds + 角色鉴权,新增批量用户信息、锁定、授权与个人配置 - 删除账号同步清理成员关系与外部身份,避免关系被新账号复用 - 补充多应用、应用配置、注册表测试与迁移/建号脚本
120 lines
3.3 KiB
JavaScript
120 lines
3.3 KiB
JavaScript
"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;
|
||
});
|