I have python fastapi app with mongodb. Below I provided schema and code to create a document. I need to use decimal, because there're problems with floating point in float data type. However, there are problems with using condecimal with…
I am using mongodb for first time. I have below models class Legacy::User include Mongoid::Document has_many :customers field :username, type: String end class Legacy::Customer include Mongoid::Document belongs_to :user field :user_id, type: String end When I run below query it doesn't…
We have the use case that we’re storing deeply nested objects in MongoDB. Certain fields in this object can have different types. For instance let’s say an object can have a field that’s a collection of InterfaceType and there are…
I have a data like: [ { "grp": "A", "seq": 1, "score": 1, x: 0 }, { "grp": "A", "seq": 1, "score": 2, x: 0 }, { "grp": "A", "seq": 1, "score": 3, x: 0 }, { "grp": "A", "seq":…
How should i get the id of the matched object from a array? Currently i am getting all the ids from pricing array. While i just want the one that matched. Code - await Item.find( {_id: "663a4dbb97674691089c835a", pricing: {$elemMatch: {mrp:…
I made a user schema based on mongoose or mongodb, in which there is a invitation code and this code is always unique in the database. import randomize from 'randomatic'; const userSchema = new Schema<UserDataInterface>( { username: { type: String,…
I am currently working on a price search engine with NodeJS and Mongoose and have a question about the implementation of a price matrix. Each product has an icon, a type symbol, a width, a height and a price. For…
I'm using MongoDB and I have a document where I want to increment a count field. However, I need to ensure that this count does not go below zero. For example, if inc is -2 and the current count is…
This is my MongoDB aggregate result based on the below aggregate query. { "count": 1, "fields": { "accountCode": "17G00011", "accountName": "GST input Receivable" }, "amount": 94.5 } { "amount": -619.5, "count": 1, "fields": { "accountCode": "21C00005", "accountName": "Cyberview Technologies" }…
I'm creating a chatbot RAG using the content from my MongoDB and sending to create vectors on Pinecone. So my user can ask stuff to my chatbot about his reflections. Here is my code: import os from pymongo import MongoClient…