模板介绍

模板说明

获取Mongo数据表数据，输出到另一个mongo数据表

流程图

依赖表结构

// ----------------------------
// Collection structure for P_UserLoginHistory
// ----------------------------
db.getCollection("P_UserLoginHistory").drop();
db.createCollection("P_UserLoginHistory");

// ----------------------------
// Documents of P_UserLoginHistory
// ----------------------------
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("6453668f8375667fa694d311"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("1"),
    ip: "127.0.0.1",
    resultMsg: "登录验证成功",
    loginTime: "2023-05-04 16:02:23",
    id: "ba23ad66882248849c3f0049b64260a1"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("64536c958375667fa694da56"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("1"),
    ip: "127.0.0.1",
    resultMsg: "登录验证成功",
    loginTime: "2023-05-04 16:28:05",
    id: "a7f385570d3d42ad828189c4eb14d5b2"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("6453703f8375667fa694df5f"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("1"),
    ip: "127.0.0.1",
    resultMsg: "登录验证成功",
    loginTime: "2023-05-04 16:43:43",
    id: "53ae150d8ded4459b0a2738c91cfa25f"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371608375667fa694e12f"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("1"),
    ip: "127.0.0.1",
    resultMsg: "登录验证成功",
    loginTime: "2023-05-04 16:48:32",
    id: "47e65d6ad589451f8eb6a91a98b4e047"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("6453718a8375667fa694e189"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("1"),
    ip: "127.0.0.1",
    resultMsg: "登录验证成功",
    loginTime: "2023-05-04 16:49:14",
    id: "1457b2b0ce414384a3c8ffd8ab87bce2"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371a98375667fa694e1f4"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("0"),
    ip: "127.0.0.1",
    resultMsg: "登录验证失败",
    loginTime: "2023-05-04 16:49:45",
    id: "40ec8ca455664f25803951540c39af17"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371b48375667fa694e1f9"),
    userId: "root",
    userName: "root",
    result: NumberInt("0"),
    ip: "127.0.0.1",
    resultMsg: "登录验证失败",
    loginTime: "2023-05-04 16:49:56",
    id: "d465c703b51a469e8a5afed4ea81cd11"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371e08375667fa694e227"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("0"),
    ip: "127.0.0.1",
    resultMsg: "登录验证失败",
    loginTime: "2023-05-04 16:50:40",
    id: "09c4c3f5316247efab7f8d9a3b9afb22"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371e08375667fa694e22a"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("0"),
    ip: "127.0.0.1",
    resultMsg: "登录验证失败",
    loginTime: "2023-05-04 16:50:40",
    id: "2567e1993216496b90f1d8c54f1ae799"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371e18375667fa694e22d"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("0"),
    ip: "127.0.0.1",
    resultMsg: "登录验证失败",
    loginTime: "2023-05-04 16:50:41",
    id: "d755676597be47c4b0d538dabde10c82"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645371e18375667fa694e230"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("0"),
    ip: "127.0.0.1",
    resultMsg: "登录验证失败",
    loginTime: "2023-05-04 16:50:41",
    id: "f265a940f89746a58c0b50069390addf"
} ]);
db.getCollection("P_UserLoginHistory").insert([ {
    _id: ObjectId("645372278375667fa694e262"),
    userId: "admin",
    userName: "admin",
    result: NumberInt("1"),
    ip: "127.0.0.1",
    resultMsg: "登录验证成功",
    loginTime: "2023-05-04 16:51:51",
    id: "20867ac757c148129d040570d6377b3d"
} ]);

使用评价