I was trying to use docker in a project I built a while back and I'm having trouble with MongoDB authentication when using Docker Compose. Here's my docker-compose.yml: services: web: build: . ports: - "${PORT}:${PORT}" environment: - PORT=${PORT} - CONNECTION_STRING=${CONNECTION_STRING}…
I have a Project entity (projects collection). Each Project belongs to an organization represented by Project.orgId and has an author Project.author taken from users collection. I want to query the projects that belong to an organization using Mongoose, and here's…
I have this below collection and I use MongoDB aggregation to acheive an output(where I aggregate all order line items for an order) and trying to merge into another collection(order). [ { "order_line_item_id": 1, "order_id": 100, "products": [ { "name":…
in connection.js const mongoClient=require('mongodb').MongoClient const state={ db:null } module.exports.connect=function (done){ const url='mongodb://localhost:27017/' const dbname='shopping' mongoClient.connect(url,(err,data)=>{ if(err) return done(err) state.db=data.db(dbname) }) done() } module.exports.get=()=>state.db in product-helpers var db=require('../config/connection') module.exports={ addProduct:(product,callback)=>{ console.log(product) db.get().collection('product').insertOne(product).then((data)=>{ console.log(data); callback(true) }) } } I am unable to…
I have one index created { v: 2, key: { xxxx: 1 }, name: 'xxxx', background: true }, But I have a lot of long queries with "sort": { "xxx": -1 }, Will creating an additional index with -1 help…
I was looking for a way to convert a positive integer into a binary array inside a mongoDB aggregation pipeline. There is $bit operation which can't be used inside an aggregation pipeline. This question is regarding mongoDB version 6.0 and…
I am building an api and I wanted to use the skip and limit methods in mongoose to handle pagination. I would like to get the total document size along with the pagination data. Initially, I made two queries: one…
I have a dataset in MongoDB that contains array data for each state, each of which has it's own inner array of zip codes. Here is a simplified example of the structure: [ { data: { name: 'Alabama', zip_codes: […
I needed to run a quick and (I thought) trivial query to update some incorrect data. I'm trying to update the very first entry of an array in a document. Note: My posted queries run against db instead of a…
I have a schema as follows: model Player { id String @id @default(auto()) @map("_id") @db.ObjectId steam_id String @unique name String level Int @default(1) elo Float @default(1500) games Game[] @relation(fields: [game_ids], references: [id]) game_ids String[] @db.ObjectId clients Client[] user User? @relation(fields:…