|
MongoDB ma'lumotlar bazasidagi elementlar bilan ishlash uchun maxsus dastur - Compassdan
|
| bet | 2/4 | | Sana | 01.01.2024 | | Hajmi | 1,65 Mb. | | #129383 |
Bog'liq 2 Mustaqil ish (Latipov J) MongoDBMongoDB ma'lumotlar bazasidagi elementlar bilan ishlash uchun maxsus dastur - Compassdan foydalanish mumkin. Ushbu dastur ma'lumotlar bazalari, to'plamlar va ulardagi yozuvlar bilan ishlash uchun vizual muharrirdir.
Dasturning o'zi bilan ishlash juda oddiy, shuning uchun unga e'tibor qaratiladi. Dastur o'rniga biz faqat maxsus buyruqlar yordamida MongoDB orqali ma'lumotlar bazasi bilan ishlashga imkon beradigan buyruqlar yoziladi.
To'plam - bu turli ob'ektlar va ma'lumotlarni o'z ichiga olgan guruh (masalan: foydalanuvchilar guruhi, mahsulotlar guruhi, narxlar guruhi va x.k).
Yaratilgan ma'lumotlar bazasida tahrir qilish uchun avvalo unga ulanish lozim so‘ngra quyidagi sintaksisdan foydalaniladi:
1-rasm. MongoDB-da ma’lumotlar bazasiga ulanish.
Ma’lumotlarni ism, id, yosh, narx kabi parametrlar orqali qidirish (find).
db.users.find({
$or: [ { name: "Alice" },
{ _id: ObjectId("659142affdfb1694971475a2") },
{ age: { $gte: 18, $lte: 30 } },
{ price: 100 }
]
})
{
_id: ObjectId('659142affdfb1694971475a2'),
name: 'Alice',
age: 25,
email: 'alice@example.com',
gender: 'female'
}
{
_id: ObjectId('659142affdfb1694971475a3'),
name: 'Bob',
age: 30,
email: 'bob@example.com',
gender: 'male'
}
{
_id: ObjectId('659142affdfb1694971475a4'),
name: 'Tom',
age: 30,
email: 'tom@example.com',
gender: 'male'
}
{
_id: ObjectId('659142affdfb1694971475a6'),
name: 'Candy',
age: 30,
email: 'candy@example.com',
gender: 'female'
}
{
_id: ObjectId('659142affdfb1694971475a6'),
name: 'Candy',
age: 30,
email: 'candy@example.com',
gender: 'female'
}
2-rasm. MongoDB Shell sintaksislar yonasi, parametrlar orqali qidirish.
Foreach metodidan foydalanish.
db.reviews.find().forEach(function(doc) {
printjson(doc);
})
{
_id: ObjectId('65915675fdfb1694971475d3'),
product_id: ObjectId('65915031fdfb1694971475b7'),
user_id: ObjectId('659142affdfb1694971475a2'),
rating: 4,
comment: ' Yaxshi sifatli jinsi shimlar!'
}
{
_id: ObjectId('65915675fdfb1694971475d4'),
product_id: ObjectId('65915031fdfb1694971475b6'),
user_id: ObjectId('659142affdfb1694971475a2'),
rating: 5,
comment: ' Yaxshi sifatli futbolkalar!'
}
{
_id: ObjectId('65915675fdfb1694971475d5'),
product_id: ObjectId('65915031fdfb1694971475b8'),
user_id: ObjectId('659142affdfb1694971475a3'),
rating: 8,
comment: ' Yaxshi sifatli krosofkalar!'
}
{
_id: ObjectId('65915675fdfb1694971475d6'),
product_id: ObjectId('65915031fdfb1694971475b9'),
user_id: ObjectId('659142affdfb1694971475a4'),
rating: 9,
comment: ' Yaxshi sifatli mokasinlar!'
}
{
_id: ObjectId('65915675fdfb1694971475d7'),
product_id: ObjectId('65915031fdfb1694971475ba'),
user_id: ObjectId('659142affdfb1694971475a5'),
rating: 10,
comment: ' Yaxshi sifatli tuflilar!'
}
{
_id: ObjectId('65915675fdfb1694971475d8'),
product_id: ObjectId('65915031fdfb1694971475bb'),
user_id: ObjectId('659142affdfb1694971475a6'),
rating: 7,
comment: ' Yaxshi sifatli kurtkalar!'
}
2-rasm. MongoDB Shell sintaksislar yonasi, foreach metodidan foydalanish.
Ma’lumotlarni ism, id, yosh, narx kabi parametrlar orqali saralash (sort).
db.products.find().sort({ price: 1 })
{
_id: ObjectId('65915031fdfb1694971475b9'),
name: 'Mokasinlar',
category: 'Oyoq kiyim',
price: 10,
color: 'kulrang'
}
{
_id: ObjectId('65915031fdfb1694971475ba'),
name: 'Tuflilar',
category: 'Oyoq kiyim',
price: 15,
color: 'ora'
}
{
_id: ObjectId('65915031fdfb1694971475bc'),
name: 'Mayka',
category: 'Ichki kiyimlar ',
price: 15,
color: 'oq'
}
{
_id: ObjectId('65915031fdfb1694971475bd'),
name: 'Qo’lqop',
category: 'Bosh kiyimlar',
price: 18,
color: 'qora'
}
{
_id: ObjectId('65915031fdfb1694971475b6'),
name: 'Futbolka',
category: 'Kiyimlar',
price: 25,
color: 'oq'
}
{
_id: ObjectId('65915031fdfb1694971475be'),
name: 'Ko’ylak erkaklar',
category: 'Kiyimlar',
price: 30,
color: 'oq'
}
{
_id: ObjectId('65915031fdfb1694971475bf'),
name: 'Ko’ylak ayollar',
category: 'Kiyimlar',
price: 35,
color: 'sariq'
}
{
_id: ObjectId('65915031fdfb1694971475b8'),
name: 'Krosofkalar',
category: 'Oyoq kiyim',
price: 40,
color: 'qizil'
}
{
_id: ObjectId('65915031fdfb1694971475b7'),
name: 'Jinsilar',
category: 'Shimlar',
price: 50,
color: 'ko’k'
}
3-rasm. MongoDB Shell sintaksislar yonasi, parametrlar orqali saralash (sort).
|
| |
