Retrieving data from mongodb using node express

Question

In my mongodb database there are 4 collections.I can retrive data using each collection on by one.Now How can retrieve data from different collections in same code using key word like findone,getAll ?My model.js given below.DB ->mongodb backend ->nodeexpress

model1.js


const Schema=mongoose.Schema;
const customerSchema = new Schema({

    shop:{
        type : String,
        required : true,
    },
    name:{
        type : String,
        required : true,
    },

    area:{
        type : String,
        required : true,
    },
       {
    timestamps : true
    }
);
const Customer = mongoose.model('customers',customerSchema);
module.exports = Customer;

model2.js

const mongoose = require('mongoose');

const Schema=mongoose.Schema;
const distributorSchema = new Schema({


    fullName:{
        type : String,
        required : true,
    },
    warehouse:{
        type : String,
        required : true,
    },
   phoneNo:{
        type : String,
        required : true,
    },

    password:{
        type : String,
        required : true
    }
},
    {
    timestamps : true
    }
);
const Distributor = mongoose.model('distributors',distributorSchema);
module.exports = Distributor;

Do you want to retreive all data from all collections in the db? — Fahad Hassan
– Fahad Hassan, Commented Jan 15, 2020 at 10:23

Fahad Hassan · Accepted Answer · 2020-01-15 10:30:55Z

1

You can make function in your controller.js like this

export async function getDataFromTwoCollections(){

  let allData = {modelOneData : [], modelTwoData : []};
  let modelOneData = await Customer.find({}).exec();
  let modelTwoData = await Distributor.find({}).exec();
  allData.modelOneData = modelOneData 
  allData.modelTwoData  = modelOneData
  return allData
}

answered Jan 15, 2020 at 10:30

Fahad Hassan

8212 gold badges11 silver badges22 bronze badges

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

1 Comment

Shalitha Jayamal Over a year ago

Fahad Hassan answer was very useful..Js file worked

Collectives™ on Stack Overflow

Retrieving data from mongodb using node express

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