Need to use multiple database in node mongodb/mongoose

Question

Well, i am stuck in little technical stuff let me explain.

i have one database with name of Company and in this i have two columns name and DBname and i have multiple Companies databases now i want to call company data based on Company DB.

i already have connected company databse like this in my main index.js

  const connect = mongoose.connect( 'mongodb://localhost/Company',
  {
    useNewUrlParser: true, useUnifiedTopology: true,
    useCreateIndex: true, useFindAndModify: false
  })
  .then(() => console.log('MongoDB Connected...'))
  .catch(err => console.log(err));

but i have to change this connecting when user is logged in based on user company database

for this i am using a DB middleware like this

const mongoose = require("mongoose");

let DB = (req, res, next) => {
    const connect = mongoose.createConnection( 'mongodb://localhost/company_ABC',
      {
        useNewUrlParser: true, useUnifiedTopology: true,
        useCreateIndex: true, useFindAndModify: false
      })
      .then(() => console.log('MongoDB Connected...'))
      .catch(err => console.log(err));
      next();
};

module.exports = { DB };

like this and it's not working please help me to resolve this issue and thanks in advance

Is the Company's DB and company_ABC's DB under the same connection string? — Jackal
– Jackal, Commented Nov 25, 2020 at 2:02

Jackal · Accepted Answer · 2020-11-25 02:17:53Z

2

Remove the DB name after the connection string.

  const connect = mongoose.connect( 'mongodb://localhost/',
  {
    useNewUrlParser: true, useUnifiedTopology: true,
    useCreateIndex: true, useFindAndModify: false
  })
  .then(() => console.log('MongoDB Connected...'))
  .catch(err => console.log(err));

Select the database in your schema file instead and export it

const mongoose = require('mongoose')
const db = mongoose.connection.useDb("company")
const collection = db.model('collectionName', collectionSchema);
module.exports = { collection };

const { collection } = require('path-to-schema');

const files = await collection.find({})......

edited Nov 25, 2020 at 2:17

answered Nov 25, 2020 at 2:09

Jackal

5431 gold badge6 silver badges16 bronze badges

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

1 Comment

Aliraza Over a year ago

as i said i have to get database name from company database and then i have to get data in this case how i will get database name from company based on userID?

Collectives™ on Stack Overflow

Need to use multiple database in node mongodb/mongoose

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