Querying a mongodb raises stop iteration error

Question

Using the following code, I am trying to extract two dates from an object in mongodb and then calculate the difference in time between the two dates -- if both year are in/past 2016. My current code raises the following error:

DeprecationWarning: generator 'QuerySet._iter_results' raised StopIteration from ipykernel import kernelapp as app

My code: raw_data = Document.objects()

data = []
for i in raw_data[:10]:
    scored = i.date_scored
    scored_date =  pd.to_datetime(scored, format='%Y-%m-%d %H:%M')
    if scored_date == "NoneType":
        print("none")
    elif scored_date.year >= 2016:
        extracted = i.date_extracted
        extracted_date =  pd.to_datetime(extracted, format='%Y-%m-%d 
        %H:%M')
        bank = i.bank.name
        diff = scored_date - extracted_date
        print(diff)
        datum = [str(bank), str(extracted), str(scored), str(diff)]
        data.append(datum)
    else:
        pass

Any help would be appreciated, thank you!

`StopIteration` is raised by a generator when it runs out of things to `yield`. You might want to check how Document.objects() is implemented. — Bishwas Mishra, Jun 16 '17 at 18:31
Does it also get raised when the calculation gets too long?? — Graham Streich, Jun 16 '17 at 18:50
No. The generators are considered a beauty because they never stop. Raising `StopIteration` is the only way to stop a generator. — Bishwas Mishra, Jun 16 '17 at 19:01
So why is it getting raised in my code and how do I fix it? Thanks! — Graham Streich, Jun 16 '17 at 19:13
Check the file where `QuerySet._iter_results` is present. In terminal do `grep -r 'QuerySet._iter_results'` to find that file. — Bishwas Mishra, Jun 16 '17 at 19:22
Thanks, I am working in jupyter notebook -- will this still work? — Graham Streich, Jun 16 '17 at 19:23

Querying a mongodb raises stop iteration error

0 Answers0