MongoDB Mongoose Use Lookup Guide

-

In This Blog We Will See Complete Guide For Using Joins With Lookup in Mongoose


Mongoose - Education Funda
MongoDB Mongoose - Education Funda


Simply in MongoDB Mongoose we can use Aggregate Query with $lookup to get data basis upon JOINS. such as below:

await MainModel.aggregate([
{
$match:
{ "COLUMN_NAME": value }
},

{
$lookup:
{
from: 'relation_collection_name',
localField: 'relation_collection_primary_key',
foreignField: 'this_table_foreign_key',
as: 'ALIASING'
}
}
]);

With above query new column added with ALIASING in which relation collection data will also come.

To get data in Object format instead of Array we can use $unwind like below:

await MainModel.aggregate([
{
$match:
{ "COLUMN_NAME": value }
},

{
$lookup:
{
from: 'relation_collection_name',
localField: 'relation_collection_primary_key',
foreignField: 'this_table_foreign_key',
as: 'ALIASING'
}
},

{
$unwind: '$ALIASING'
},
]);

With. above query via using $unwind the data coming in object format now instead of array.

Now, if you want data if no data available in relation table so we can use preserveNullAndEmptyArrays like below:

await MainModel.aggregate([
{
$match:
{ "COLUMN_NAME": value }
},

{
$lookup:
{
from: 'relation_collection_name',
localField: 'relation_collection_primary_key',
foreignField: 'this_table_foreign_key',
as: 'ALIASING'
}
},

{
$unwind: {
path: "$ALIASING",
preserveNullAndEmptyArrays: true
}
},
]);


Now, if you want to use multiple lookup so you can use very simple like below:

await MainModel.aggregate([
{
$match:
{ "COLUMN_NAME": value }
},

{
$lookup:
{
from: 'relation_collection_name',
localField: 'relation_collection_primary_key',
foreignField: 'this_table_foreign_key',
as: 'ALIASING'
}
},

{
$unwind: {
path: "$ALIASING",
preserveNullAndEmptyArrays: true
}
},

{
$lookup:
{
from: 'relation_collection_name_another',
localField: 'relation_collection_primary_key',
foreignField: 'this_table_foreign_key',
as: 'ALIASING_1'
}
},

{
$unwind: {
path: "$ALIASING_1",
preserveNullAndEmptyArrays: true
}
},
]);


Thanks for reading this blog, I hope it will help you to understand Mongoose $Lookup.

Happy Coding !!

Follow Me Here.


Location: India

Comments

Post a Comment

Popular posts from this blog

JavaScript Logical Output Based Interview Questions

-
Image
You mostly seen in JavaScript interviews there interviewers must asks output based questions in which candidate stuck mostly so here in this blog I'm telling you most commonly asked output based JavaScript interview questions. By Education Funda Most Commonly Asked JavaScript Output Based Questions Question: 1 function sum(){      let a = 8;      const b=2;      var c=a+b; } console.log(a) // Reference error: a is not defined console.log(b) // Reference error: a is not defined console.log(c) // Reference error: a is not defined sum() console.log(a) // Reference error: a is not defined console.log(b) // Reference error: b is not defined console.log(c) //Output: undefined ---------------------------------------------------------------------------- Question: 2 let arr=[1,2,3,4,5]; console.log(arr[2], arr.length); //Output: 3 5 arr.length=0; console.log(arr[2], arr.length); //Output: undefined 0 Note:  As we can see in above code 1st ques...
Read more

Deploy Angular Build With Express JS Project

-
Image
Deploy Angular Build in Node JS (Express JS) Server Mean Stack - Education Funda Firstly Create Angular Production Ready Build: ~ ng build (run in command line when directory is projectFolder). ~ Compress using Brotli compression the resources using the following command for i in dist/*/*; do brotli $i; done Deployment Check Angular Build: You can get a preview of your application using the ng serve --prod command that starts a local HTTP server such that the application with production files is accessible using http://localhost:4200. This is not safe to use for production usage. For a production usage, you have to deploy all the files from the dist folder in the HTTP server of your choice. Node JS/Express JS Server File Changes: //enabling CORS app . use ( cors ()); app . use ( express . static ( path . resolve ( './public' ))); //api v1 base route set app . use ( '/api/v1' , router ); //angular front site app . use ( express . static ( path . resolve ( './public/a...
Read more

Postman Collection APIs to Swagger Docs

-
Image
Being an back-end developer we generally works with APIs, for storing the APIs mostly developers are using the Postman, So in this blog will discuss how to covert postman collection APIs to swagger APIs documentation. Express Js Project Convert Postman Collection APIs to Swagger Docs Step 1: You should have proper APIs postman collection for your project. Step 2: Install swagger ui in your node project via ~ npm i swagger-ui-express . Step 3: Put below code in your Routes index file OR app.js wherever you maintained your express routes as per your requirements: Here you also need to create 1 json file for storing the details of your APIs docs just like we create swagger-output.json . import express from "express" ; import swaggerUi from "swagger-ui-express" ; const swaggerDocument = JSON . parse ( await readFile ( new URL ( "../../../../swagger-output.json" , import .meta. url )) ); const router = express . Router (); // adding swagger docs...
Read more