python - Why having empty result in Pymongo

Question

Recently I'm using Pymongo and I'm new to it so right now I have a problem on it .

'''
removes keys from  product collection to save space
'''
##

import os
import sys
import requests
import time
from datetime import datetime, timedelta
import pymongo
import bson
import numpy as np
from dotenv import load_dotenv
from bson.objectid import ObjectId

load_dotenv()

##

isProduction = False
# isProduction = sys.argv[1] == 'prod' if len(sys.argv) >=2 else False

client = pymongo.MongoClient(os.getenv('MONGOURI'))
db = client.prod if isProduction else client.dev

keywordsCollection = db.keywords

##
duplicates = keywordsCollection.aggregate([
    {"$group" : { "_id": "$keyword", "count": { "$sum": 1 } } },
    {"$match": {"_id" :{ "$ne" : None } , "count" : {"$gt": 1} } },
    {"$project": {"keyword" : "$_id", "_id" : 0} }
]);

print(list(duplicates))

I've done the Python script but when I run the result, its showing m an empty array but when I checked my MongoDB it should have duplicates keys.I've checked the connection by doing print(db.name) and it was ok.Am i missing anything?Thanks in advance.

question from:https://stackoverflow.com/questions/66046369/why-having-empty-result-in-pymongo

Answer 1

Waitting for answers