Mongoose和mongoDB - 重复键错误-Java 学习之路

我正在尝试使用MongoDB和mongoose作为我的小对话应用程序，其中每个用户都拥有自己的集合，但是在保存新对话时我收到错误：

ERROR: MongoError: insertDocument :: caused by :: 11000 E11000 duplicate key error index: chat.privatemessages.$id dup key: { : ObjectId('54f1a39ff467833f7e794636') }

我的架构：

var chatPrivateMessagesSchema = mongoose.Schema({
    user: String,
    with:[{
        conversation_with: String,
        messages:[{
            text:String,
            created: {type: Date, default: Date.now}
        }]
    }]
});

var PrivateMessages = mongoose.model('PrivateMessages', chatPrivateMessagesSchema);

保存新会话的方法：

socket.on ('chat', function (from, to, message, callback) {
    PrivateMessages.find ({}, function (err, users) {
        if (err) throw err;
        for (var i = 0; i < users.length; i++) {
            if (users[i].user == from) {
                var newPrivateMsg = new PrivateMessages ({_id: users[i]._id}, {
                    with: [{
                        conversation_with: to, //if conversation with "to" user does not exist create a new entry
                        messages: [{
                            text: message, //append a new message 
                            created: {type: Date, default: Date.now}
                        }]
                    }]
                });
                newPrivateMsg.save (function (err) {
                    if (err) throw err;
                });
            }
        }
    });
});

所以基本上我正在寻找的输出应该是这样的？

{
    "_id": "some id",
    "user": "John",
    "with": [{
        "conversation_with": "Maria",
        "_id": "some id",
        "messages": [{
            "text": "Hellomyfisrtmessage",
            "created": "somedate"
        }, {
            "text": "Secondmessage ",
            "created": "somedate"
        }, {
            "text": "Thirdmessage",
            "created": "somedate"
        }, ]
    }, {
        "conversation_with": "Peter",
        "_id": "some id",
        "messages": [{
                "text": "Hellomyfisrtmessage",
                "created": "somedate"
            }, {
                "text": "Secondmessage ",
                "created": "somedate"
            }, {
                "text": "Third message",
                "created": "some date"
            },

        ]
    }],

}

我真的在努力学习如何插入一个新条目:(任何人都可以帮忙吗？

1 回答

问题是你要将每个PrivateMessage _id设置为用户的_id，不要这样做！

编辑：

socket.on ('chat', function (from, to, message, callback) {
    PrivateMessages.find ({}, function (err, users) {
        if (err) throw err;
        for (var i = 0; i < users.length; i++) {
            if (users[i].user == from) {
                users[i].with.forEach(function(with){
                    if (with.conversation_with === to ){

                        // append new message
                        with.messages.push({
                            text: message,
                            created: { type: Date, default: Date.now }
                        })
                    }
                })

                users[i].save (function (err) {
                    if (err) throw err;
                });

            }
        }
    });
});

回复于 2024-05-11T04:54:23+08:00

Mongoose和mongoDB - 重复键错误

1 回答

相关问题