I spend couple hours trying to figure the right ORM Algorithms but I find your article so clean however I followed step by step my code doesn't work the way I expected it to work, the COUNT return result and SUM return None type it does seems like it doesn't getting a value of JSON keys can you please assist ? and what version of Django are you using for this article ?
Here is my example code that I used to create some example data:
importdatetimeasdt# don't care about timezones right now
expected={"energy":90.78559770167864,"irradiation":30.085498370965905}observed={"energy":10.78559770167864,"irradiation":20.085498370965905}today=dt.date.today()# Just create some identical objects, I don't think that this matters right now
DataPoint.objects.create(datetime=today,expected=expected,observed=observed)DataPoint.objects.create(datetime=today,expected=expected,observed=observed)DataPoint.objects.create(datetime=today,expected=expected,observed=observed)DataPoint.objects.create(datetime=today,expected=expected,observed=observed)date_from=today-dt.timedelta(days=4)date_to=today+dt.timedelta(days=3)object_data=DataPoint.objects.counts_and_sums(date_from,date_to)print(object_data)<QuerySet[{'day':datetime.datetime(2019,9,10,0,0,tzinfo=<DstTzInfo'Europe/Berlin'CEST+2:00:00DST>),'count':4,'observed_irradiation_total':80.3419934838636,'observed_energy_total':43.1423908067146,'expected_irradiation_total':120.341993483864,'expected_energy_total':363.142390806715}]>
And just for the records, my version, taken from the same shell:
I spend couple hours trying to figure the right ORM Algorithms but I find your article so clean however I followed step by step my code doesn't work the way I expected it to work, the COUNT return result and SUM return None type it does seems like it doesn't getting a value of JSON keys can you please assist ? and what version of Django are you using for this article ?
I am using Django in its most recent version which is 2.2.5.
Can you describe your data structure in more detail in order for me to understand your problem better?
Perhaps you could also provide some example json data?
Here are my code and I used Django 2.2.2, when I query data JSON value does come as None type and the count does bring value
query
my response
and my object looks like this when I query it with normal DataPoint.objects.all()
Unfortunately, all I can say is, it works for me.
Here is my example code that I used to create some example data:
And just for the records, my version, taken from the same shell:
The only thing I changed in your code, is that I removed the
plant_id
ForeignKey