Create dynamic collection in MongoDB using Sails.js

Question

I am working with SailsJs+MongoDB API. I have to create New colletion in mongoDB .Name of colletion will be in request Parameter.

example:

Suppose I want to create 'Users' collection in 'mongoDbDatabase' database by following request.

 {
    "collectionName" : "Users",
    "dbName"    :"mongoDbDatabase"
    }

Now is there any way to create dynamic collection in mongoDB using req.param('collectionName) variable ?

arbuthnott · Accepted Answer · 2018-03-29 11:37:59Z

1

To use all the tools that Sails provides, you have to add code (before you start your app) for each Model / Collection you are planning to interact with. As a result, creating a collection dynamically will mean you can't take advantage of the whole data - framework sails provides.

Are you sure you need a dynamic collection? Why not a defined collection differentiated by attributes?

If you really need to do this from Sails, it looks like you can get access to the underlying raw mongo database:

var db = AnyModel.getDatastore().manager; // the database will be as defined in config/models.js or config/connections.js

var collectionName = 'Widgets';
db.createCollection(collectionName);

// note, even if this works, something like 'Widgets.find' will not.

answered Mar 29, 2018 at 11:37

arbuthnott

3,8192 gold badges10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Devang Mistry Over a year ago

Thanks for your answer , and you are right . That I will not able to use queries of collection provided by sails for dynamic created tables. as per your suggestions , I'll try to make changes in DB Design and will try to work out with attribute differentiation. Thanks

Collectives™ on Stack Overflow

Create dynamic collection in MongoDB using Sails.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related