How to resolve MissingSchemaError in mongodb using mongoose

Question

I am creating a schema model dynamically. So I am not able to use this model for other events like a record save, update, remove, etc. If I use that I am getting this error:

Error: MissingSchemaError: Schema hasn't been registered for model "XYZ". Use mongoose.model(name, schema)

I do not know why it is coming to this error. I have tried many times but not working. Please help to resolve this issue?

schemamodel.js:

    /* model.js */
 'use strict';
 var mongoose = require('mongoose'),
     Schema = mongoose.Schema;

 function dynamicModel(suffix) {
     var collsName = suffix.charAt(0).toUpperCase() + suffix.slice(1);
     var newSchema = new Schema({
         product_name: {
             type: String
         }
     }, {
         versionKey: false
     });
     try {
         if (mongoose.model(collsName)) return mongoose.model(collsName);
     } catch (e) {
         if (e.name === 'MissingSchemaError') {
             return mongoose.model(collsName, newSchema, suffix);
         }
     }
 }
 module.exports = dynamicModel;

data.controller.js:

module.exports.newCollection = (req, res, next) => {
    var collectionName = req.query.collectionName;
    var NewModel;
    mongoose.connection.db.listCollections().toArray(function(err, names) {
        if (err) {
            console.log(err);
        } else {
            names.forEach(function(e, i, a) {
                if (e.name == collectionName.toLowerCase()) {
                    console.log("The collection already exists");
                } else {
                    console.log("The collection not exists");
                    NewModel = require(path.resolve('./models/schemamodel.js'))(collectionName);
                    NewModel.create({}, function(err, doc) {});
                }
            });
        }
    });
}
//get data collection from collection 
module.exports.getCollectionData = (req, res, next) => {
    let collection = req.query.collection;
    let data = mongoose.model(collection); // here getting MissingSchemaError
    data.find({}, function(err, docs) {
        if (err) {
            console.log('ss' + err);
            return;
        } else {
            console.log("Successful loaded");
        }
    });
}

api call:

http://localhost:3000/api/getCollectionData?collection=Apply

bill.gates · Accepted Answer · 2020-05-30T14:18:34.427

1

Instead of mongoose.model(...) you need the DB connection db.model(...)

 /* model.js */
 'use strict';
 var mongoose = require('mongoose'),
     Schema = mongoose.Schema;
 const db = mongoose.createConnection(
      "mongodb://localhost:27017/datadetails",
      {
        useNewUrlParser: true,
        useUnifiedTopology: true
      }
  );
 function dynamicModel(suffix) {
     var collsName = suffix.charAt(0).toUpperCase() + suffix.slice(1);
     var newSchema = new Schema({
         product_name: {
             type: String
         }
     }, {
         versionKey: false
     });
     try {
         if (db.model(collsName)) return db.model(collsName);
     } catch (e) {
         if (e.name === 'MissingSchemaError') {
             return db.model(collsName, newSchema, suffix);
         }
     }
 }
 module.exports = dynamicModel;

edited May 30 '20 at 14:18

answered May 30 '20 at 13:24

bill.gates

14,145
3
19
47

@PappaS where is your mongodb installed? is it a cluster or does it run locally? – bill.gates May 30 '20 at 14:07
Mongodb run locally – Pappa S May 30 '20 at 14:08
@PappaS it should look something like this `mongodb://localhost:27017/myapp` – bill.gates May 30 '20 at 14:08
@PappaS where `myapp` is your database name – bill.gates May 30 '20 at 14:09
This is my DB url : mongodb://localhost:27017/datadetails – Pappa S May 30 '20 at 14:11
@PappaS try it like that – bill.gates May 30 '20 at 14:18
If i use your code two collection is creating like apple and apples – Pappa S May 30 '20 at 14:19
@PappaS if you define your collection as `apple` it creates an collection `apples`, it always adds an `s` to the end of the collection name. so everybody knows its plular – bill.gates May 30 '20 at 14:20
Ya..I know.Anyway is there to avoid s ? – Pappa S May 30 '20 at 14:24
@PappaS check it out https://stackoverflow.com/questions/10547118/why-does-mongoose-always-add-an-s-to-the-end-of-my-collection-name – bill.gates May 30 '20 at 14:26
Same method i have used..see model(collsName, newSchema, suffix) – Pappa S May 30 '20 at 14:28
@PappaS i see, but i cant help you either here – bill.gates May 30 '20 at 14:31
Please help me..Becuase i tried too long time to resolve this issue also i am new in mongoose – Pappa S May 30 '20 at 14:34
@PappaS you still have the missingSchemaError? – bill.gates May 30 '20 at 14:35
Yes Some time getting this error: Schema hasn't been registered for model "xyz" – Pappa S May 30 '20 at 14:46
Till now i am getting this error: Schema hasn't been registered for model "xyz" – Pappa S May 30 '20 at 15:46
Please..Give me the solution – Pappa S May 30 '20 at 15:47
@PappaS i am sorry but i cant help you either with a distance diagnostic – bill.gates May 30 '20 at 15:48
Can you answer for sixtwo25969nine ? – Pappa S Jun 08 '20 at 14:37

How to resolve MissingSchemaError in mongodb using mongoose

1 Answers1