CODEWITHSUNDEEP
node.jsmongodbmongoosecollections
ravi
ravi

Reputation: 1609

Mongoose -- Force collection name

I am trying to use mongoose to create a database and a collection in it. My code is:

var mongoose = require('mongoose');
var db = mongoose.connect('mongodb://localhost/testdb');
var Schema = mongoose.Schema;

var UserInfo = new Schema({
  username : String,
  password : String 
});

mongoose.model('UserInfo', UserInfo);

var user = db.model('UserInfo');

var admin = new user();
admin.username = "sss";
admin.password = "ee";
admin.save();

When I run this code, mongoose created collection named UserInfo instead of userinfo. How to force collection name in mongoose?

Upvotes: 160

Views: 102763

Answers (9)

Topher Chapman
Topher Chapman

Reputation: 81

Passing a third argument on module.exports = mongoose.model('name', schema, 'collection') overrides the automatic collection name based on model name, which has already been answered.. but there are 2 other ways,

per mongoose.model doco link: https://mongoosejs.com/docs/api.html#mongoose_Mongoose-model

there are 3 methods to manually enter a collection name:

var schema = new Schema({ name: String }, { collection: 'actor' });

// or

schema.set('collection', 'actor');

// or

var collectionName = 'actor'
var M = mongoose.model('Actor', schema, collectionName)

Upvotes: 8

vijay kumar
vijay kumar

Reputation: 1055

Mongoose will add 's' to collection name by default. If you want to avoid that, just pass as third argument the name of the collection:

var mongoose = require('mongoose');
var db = mongoose.connect('mongodb://localhost/testdb');
var Schema = mongoose.Schema;

var UserInfo = new Schema({
    username: String,
    password: String 
});

mongoose.model('UserInfo', UserInfo, 'UserInfo')

tan = new user();
admin.username = 'sss';
admin.password = 'ee';
admin.save();

Upvotes: 38

Thomas Blobaum
Thomas Blobaum

Reputation: 3730

This should do it

var UserInfo = new Schema({
  username : String,
  password : String 
}, { collection: 'userinfo' });

See this link from the Mongoose documentation for more information.

Upvotes: 261

Bijay Pal
Bijay Pal

Reputation: 251

Answer:

mongoose.model('UserInfo', UserInfo, 'userinfo'); //3rd parameter 'userinfo': as collection name

Better explanation with syntax:

Mongoose.model(name, [schema], [collection], [skipInit])

Parameters Explanation:

  • 1st parameter - name model name
  • 2nd parameter [schema] schema name
  • 3rd parameter [collection] collection name (optional, induced from model name)
  • 4th parameter [skipInit] whether to skip initialization (defaults to false)

Upvotes: 5

Shyam Kumar Nallaguntla
Shyam Kumar Nallaguntla

Reputation: 79

your model name : userInfo.js

in express route file or app.js

var mongoose = require('mongoose');
mongoose.connect('mongodb://localhost/testdb');

then in your userInfo.js

var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var UserInfo = new Schema({
 username : String,
 password : String 
});
module.exports = mongoose.model('UserInfo', UserInfo);

Upvotes: 0

vkarpov15
vkarpov15

Reputation: 3872

Mongoose maintainer here. We recommend doing mongoose.model('UserInfo', UserInfo, 'UserInfo');, third arg to mongoose.model() is the collection name. Here's the relevant docs.

Upvotes: 9

Simran
Simran

Reputation: 2810

API structure of mongoose.model is this:

Mongoose#model(name, [schema], [collection], [skipInit])

What mongoose do is that, When no collection argument is passed, Mongoose produces a collection name by pluralizing the model name. If you don't like this behavior, either pass a collection name or set your schemas collection name option.

Example:

var schema = new Schema({ name: String }, { collection: 'actor' });

or

schema.set('collection', 'actor');

or

var collectionName = 'actor'
var M = mongoose.model('Actor', schema, collectionName);

Upvotes: 17

James Freund
James Freund

Reputation: 483

You need to set the collection name in your schema.

new Schema({...},{collection: 'userInfo'});

Upvotes: 11

Bilal Husain
Bilal Husain

Reputation: 1760

If you are using mongoose 2.0.0, pass the collectionName as the third argument

mongoose.model('UserInfo', UserInfo, 'UserInfo');

Upvotes: 107

Related Questions