How to group by name of key name in object and sum its value in php
I have some data in mongoDB and i want to group and sum it in object key - value: { '_id': '1', 'value': { A: 1, B: 2, C: 3 } }, { '_id': '2', 'value': { B: 2, C:…
MongoDB if statement in a parameter
I am trying to not make my code redundant and I would like to know, if in a .updateOne method, when Im passing data to change, if its possible to implement if statement to choose from the data. Here is…
Failing to connect mongodb atlas with nodejs
I am creating a simple application on Nodejs as a beginner. I am failing to connect nodejs with mongodb atlas. Kindly help me. I have provided the username, password and clustername respectively. const express = require("express"); const app = express();…
Mongodb – How to get categories and sub-categories in single API response
I have two collections Categories and Subcategories inside a Categories collection. I have an array that is storing the ids of subcategories that are stored in Subcategories collection. Below is my document structure: Categories collection { id:65, title:"Automotive", active:true, subcategories:[35,28,30]…
deployment/auth-mongo-depl: container auth-mongo is waiting to start: mongo can't be pulled – Docker
This is my auth-depl.yaml file: apiVersion: apps/v1 kind: Deployment metadata: name: auth-depl spec: replicas: 1 selector: matchLabels: app: auth template: metadata: labels: app: auth spec: containers: - name: auth image: tester/auth env: - name: MONGO_URI value: 'mongodb://auth-mongo-srv:27017/auth' - name: JWT_KEY…
Import data in gzip archive to mongodb
I have data stored in gzip archive folders, every archive contains a big file that includes json in the following format: {key:value, key:value} {key:value, key:value} {key:value, key:value} I need to import the data to MongoDB. What is the best way…
Mongodb – How to join two Mongo DB Collections together, with one being an Array of Objects inside the Other
I have two collections, one being Companies and the others being Projects. I am trying to write an aggregation function that first grabs all Companies with the status of "Client", then from there write a pipeline that will return all…
How do I get the full hour before the latest in MongoDB?
I'm trying to get the second latest full hour. So if the time is 15:30 now, I'm trying to get 14:00, so I basically need to truncate the current minutes and then furthermore truncate an hour.. I'm trying to project…
Mongodb – MongoClient.connect not working in node.js
var MongoClient = require('mongodb').MongoClient; var url = 'mongodb://localhost:27017/mydb' MongoClient.connect(url, function(err,db) { if (err) { console.log("err") } else { console.log("Database Connected") } }) .connect is striked off in VS Code err is displayed in the VS Code terminal Node.js node-v18.12.0-x64 Mongodb…
MongoDB: Aggregation/Grouping for poll votes
Am trying to create a poll results aggregation I have two collections poll - here is one document { "_id": { "$oid": "636027704f7a15587ef74f26" }, "question": "question 1", "ended": false, "options": [ { "id": "1", "option": "option 1" }, { "id":…