I followed the description of how to install MongoDB to Debian 11 that can be found in severall places. Since all describe the same, I selected one of them. Every input works as expected. Even the attempt to start the…
I have mongodb collection like: [{ "name": "a", "price": 130 }, { "name": "b", "price": 90 }, { "name": "c", "price": 150 }, { "name": "e", "price": 170 }, { "name": "g", "price": 135 }] I need a query to…
I have this document : [ { "_id": "626c5fd2aa0fc0e4eef45c94", "productos": [ { "_id": "626d50b621180e291a330333", "nombre": "ciruelas", "descripcion": "marca lala", "codigo": 33, "foto": "https://cdn3.iconfinder.com/data/icons/fruits-52/150/icon_fruit_morango-256.png", "precio": 15, "stock": 30, "timestamp": "2022-04-30T15:06:45.128Z", "__v": 0 } ], "timestamp": "2022-04-29T21:59:35.301Z", "__v": 0 }, { "_id":…
How do I fetch only the first element from the "topicsName" array? Data I have input: { "_id" : ObjectId("606b7046a0ccf72222c00c2f"), "groupId" : ObjectId("5f06cca74e51ba15f5167b86"), "insertedAt" : "2021-04-05T20:17:10.144521Z", "isActive" : true, "staffId" : [ "606b6c34a0ccf72222c5a4df", "606b6c48a0ccf722228aa035" ], "subjectName" : "Maths", "teamId" :…
I have an existing document and I wish to add a unique Object Id to each of the transaction Array Objects. { _id: ObjectId(6086d7e7e39add6a5220d0a5), firstName: "John" lastName: "Doe" transactions: [ { date: 2022-04-12T09:00:00.000+00:00 amount: 286.56 type: "deposit" method: "Bank transfer"…
im trying to create microservices with Spring Boot, so i prefered to use mongodb as a database for one of my microservices using docker compose : here is my docker-compose.yml file content : version: "3.8" services: postgres: image: postgres container_name:…
I have two tables that i want to join. Tables : users, rooms. use myDB; create table users( userId char(12), pseudo varchar(24) ); create table rooms ( roomId char(24), userIdFrom char(12), userIdTo char(12) ); insert into users values('000000000001','A'); insert into…
Hi I tried every thing like mongoose.connect('mongodb://localhost/blog') but I am not able to connect mongoose to node here is my code.... const express = require('express') const mongoose = require('mongoose') const articleRouter = require('./routes/articles') const app = express() mongoose.connect('mongodb://localhost:27017/blog') app.set('view engine','ejs')…
I am trying to add a pictire to the MongoDB via Multer and NodeJS. The Multer storage is created. The middleware based on Multer called upload is inserted into the POST request. But when I carry out POST request, req.file…
I have two collections: Car Drive Histories and Car Geolocations. For the purpose of analyzing drive patterns I have to aggregate driving histories and link them to car geolocations. I've used $match and $project aggregation stages to get drive history…