I am trying to access/query an existing collection in mongo via the following code but i get 0 count even though there are 33 documents in the collection!
from mongoengine import *
class TASK(DynamicDocument):
pass
connect("try", host="mongodb://x.x.x.x:27017/")
print(task.objects().count())
o/p is 0
TASK is a collection in try DB. Has 33 documents can be seen in mongo compass!
Any advice on what i am doing wrong?
TIA!
As mentioned in the comment, try forcing the collection name to "TASK" like this:
class TASK(DynamicDocument):
meta = {'collection': 'TASK'}
Otherwise the underlying collection is "t_a_s_k" and not "TASK" as you would expect. In fact this comes from the fact that usually models are CamelCased (e.g JediWarrior) and mongoengine snake_cases the model name to deduct the collection name (e.g jedi_warrior). See below for a demo of how is the collection named behind the scene in your example:
from mongoengine import *
connect("try", host="mongodb://x.x.x.x:27017/")
class TASK(DynamicDocument):
pass
collection = TASK._get_collection()
print(collection.name) # 't_a_s_k'
