mongodb import and querys

MOngodb

./mongoimport --db dbname --collection coll --type csv --headerline --file path/restaurantsa9126b3.csv


Aggregate 

await Restaurants

      .aggregate([

        {
          $lookup: {
            from: "restaurantsAdd", // collection name in db
            localField: "Restaurant ID",
            foreignField: "Restaurant ID",
            as: "restaurantsAdd"
          }
        },
        

        { $match: { "Restaurant Name": { $regex: Res_Name, $options: 'i' } } },
        { $match: { "Cuisines": { $regex: Cuisines, $options: 'i' } } },
        { $sort: { [sort]: sortOrder } }
      


      ])
      .skip(skip)
      .limit(10)
      .exec();