Mongo db $bucket Isomiddinov Shahriyor

Mongo DB

$bucket

Isomiddinov Shahriyor

Metodlari bilan tanishish

Ushbu elementlar uchun metodlar bilan tanishingiz mumkin
groupBy: "$key" - aynan qaysi element boyicha guruhlanishi yoziladi
boundaries: [value, value] – groupBy boyicha elementning qiymatlari yoziladi. valuestring bo’lmasligi kerak
default - _id sifatida nima berilish yoziladi
output: - filtrlangan malumot chiqadi
$facet bilan bir nechta qiymatlar boyicha ishlahs mumkin
{
$bucket: {
groupBy: ,
boundaries: [ , , ... ],
default: ,
output: {
: {<$accumulator expression> },
: {<$accumulator expression> },
: {<$accumulator expression> },
}
}
}
{ "last_name" : "Bernard", "first_name" : "Emil", "year_born" : 1868, "year_died" : 1941, "nationality" : "France" }
{ "last_name" : "Rippl-Ronai", "first_name" : "Joszef", "year_born" : 1861, "year_died" : 1927, "nationality" : "Hungary" }
{ "last_name" : "Ostroumova", "first_name" : "Anna", "year_born" : 1871, "year_died" : 1955, "nationality" : "Russia" }
{ "last_name" : "Van Gogh", "first_name" : "Vincent", "year_born" : 1853, "year_died" : 1890, "nationality" : "Holland" }
{ "last_name" : "Maurer", "first_name" : "Alfred", "year_born" : 1868, "year_died" : 1932, "nationality" : "USA" }
{ "last_name" : "Munch", "first_name" : "Edvard", "year_born" : 1863, "year_died" : 1944, "nationality" : "Norway" }
{ "last_name" : "Redon", "first_name" : "Odilon", "year_born" : 1840, "year_died" : 1916, "nationality" : "France" }
{ "last_name" : "Diriks", "first_name" : "Edvard", "year_born" : 1855, "year_died" : 1930, "nationality" : "Norway" }

Model sxema yaratib olamiz

const mongoose = require('mongoose')
const ModelSchema = mongoose.Schema({
last_name: { type: String },
first_name: { type: String },
nationality: { type: String },
year_born: { type: Number },
year_died: { type: Number },
}, {
timestamps: true
})
const Data = mongoose.model('bucket', ModelSchema)
module.exports = Data

1-usul

const express = require('express')
const router = express.Router()
const BUCKET = require('../../models/aggregate pipiline/$bucket')
router.get('/task1', async (req, res, next) => {
pipeline = [
{
$bucket: {
groupBy: "$year_born",
boundaries: [1840, 1850, 1860, 1870, 1880],
default: "Other",
output: {
"count": { $sum: 1 },
"artists":
{
$push: {
"name": { $concat: ["$first_name", " ", "$last_name"] },
"year_born": "$year_born"
}
}
}
}
},
]
const result = await BUCKET.aggregate(pipeline)
res.json(result)
})

Natija 1-usul

{
"_id": 1840,
"count": 1,
"artists": [
{
"name": "Odilon Redon",
"year_born": 1840
}
]
},
{
"_id": 1850,
"count": 2,
"artists": [
{
"name": "Vincent Van Gogh",
"year_born": 1853
},
{
"name": "Edvard Diriks",
"year_born": 1855
}
]
},
{
"_id": 1860,
"count": 4,
"artists": [
{
"name": "Emil Bernard",
"year_born": 1868
},
{
"name": "Joszef Rippl-Ronai",
"year_born": 1861
},
{
"name": "Alfred Maurer",
"year_born": 1868
},
{
"name": "Edvard Munch",
"year_born": 1863
}
]
},
{
"_id": 1870,
"count": 1,
"artists": [
{
"name": "Anna Ostroumova",
"year_born": 1871
}
]
}

2-usul

const express = require('express')
const router = express.Router()
const BUCKET = require('../../models/aggregate pipiline/$bucket')

Natija 2-usul

"tugilgani_boyicha": [
{
"_id": 1840,
"peoples": [
{
"ismi": "Odilon Redon",
"yili": 1840
}
]
},
{
"_id": 1850,
"peoples": [
{
"ismi": "Vincent Van Gogh",
"yili": 1853
},
{
"ismi": "Edvard Diriks",
"yili": 1855
}
]
},
{
"_id": 1860,
"peoples": [
{
"ismi": "Emil Bernard",
"yili": 1868
},
{
"ismi": "Joszef Rippl-Ronai",
"yili": 1861
},
{
"ismi": "Alfred Maurer",
"yili": 1868
},
{
"ismi": "Edvard Munch",
"yili": 1863
}
]
},
{
"_id": 1870,
"peoples": [
{
"ismi": "Anna Ostroumova",
"yili": 1871
}
]
}
]
"vafot_etgani_boyicha": [
{
"_id": 1910,
"peoples": [
{
"ismi": "Odilon Redon",
"yili": 1916
}
]
},
{
"_id": 1920,
"peoples": [
{
"ismi": "Joszef Rippl-Ronai",
"yili": 1927
}
]
},
{
"_id": 1930,
"peoples": [
{
"ismi": "Alfred Maurer",
"yili": 1932
},
{
"ismi": "Edvard Diriks",
"yili": 1930
}
]
},
{
"_id": "default",
"peoples": [
{
"ismi": "Emil Bernard",
"yili": 1941
},
{
"ismi": "Anna Ostroumova",
"yili": 1955
},
{
"ismi": "Vincent Van Gogh",
"yili": 1890
},
{
"ismi": "Edvard Munch",
"yili": 1944
}
]
}
]