CODEWITHSUNDEEP
node.jsmongodbmongoose-schemamongoose-models
csean11
csean11

Reputation: 13

Node.js and Mongoose. Reading from one collection and writing to a different one

I am trying to read from one Mongo collection and then take all that data and save it to a new collection. I am using the same schema, but changing the collection name in two different models :

UserInfo.js :

const mongoose = require('mongoose')

const userSchema = mongoose.Schema({
    userID : String,
    userName : String
})

let userInfo = mongoose.model('UserInfo', userSchema)
let backUpUserInfo = mongoose.model('BackUpUserInfo', userSchema)

module.exports = {
    userInfo : userInfo,
    backUpUserInfo : backUpUserInfo
}

I inserted data into the userinfos collection and then I am trying to read that and insert into the backupuserinfos collection :

backup.js :

const UserInfo = require('../Schema/UserInfo').userInfo;
const BackUpUserInfo = require('../Schema/UserInfo').backUpUserInfo;

async function backUp(){ 
    UserInfo.find({}, async function(err1, userInfo){   
        if (err1) return console.log(err1) 
        for(let i in userInfo){
            try{
                let backUpUser = new BackUpUserInfo(userInfo[i])
                await backUpUser.save(function (err2, user) {
                    if (err2) return console.error(err2)
                    console.log("collection updated")
                })
            }
            catch(err){
                console.log(err)
            }
        }
    })
}

I am getting an error that seems to indicate that it is finding a duplicate when trying to save the information, even though the backup collection is empty. This makes me think it is trying to write to the user info collection instead of the back up one. I created the backUp model variable and that is what I run save on, which makes me think it should be specified to run to that collection. Am I doing something wrong here?

Here is the error :

VersionError: No matching document found for id

Upvotes: 0

Views: 695

Answers (1)

Ranjeet Eppakayala
Ranjeet Eppakayala

Reputation: 3048

Easiest way in mongoose would be

UserInfo.aggregate([ { $match: {} }, { $out: "BackupUserInfo" } ])

Else you can use mongodb query OR mongodb copyTo()

db.myoriginal.aggregate([ { $match: {} }, { $out: "mycopy" } ])

//OR

db.source.copyTo("target");

But copyTo() is deprecated since version 3.0.

Upvotes: 1

Related Questions