Size: a a a
B
AI
IK
TB
TB
class ModelA(models.Model):
date_update = models.DateTimeField()
class ModelB(models.Model):
date_update = models.DateTimeField()
class ModelC(models.Model):
date_update = models.DateTimeField()
AG
class ModelA(models.Model):
date_update = models.DateTimeField()
class ModelB(models.Model):
date_update = models.DateTimeField()
class ModelC(models.Model):
date_update = models.DateTimeField()
.values_list(..., flat=True), с аннотированным названием моделейTB
.values_list(..., flat=True), с аннотированным названием моделейAG
TB
AG
values_list() будет быстрееlist.extends()
"долго" будет подсчет общего кол-ва на больших данныхAG
T
Order -> Many Steps -> Many Jobs (with many2may and one2many) + many2many
И все с манипуляциями в DOM (show / hide)AG
AG
DT
Z
Z
Z
SELECT DATE_TRUNC('hour', "core_tankdata"."record_time" AT TIME ZONE 'Asia/Almaty') AS "hour",
COUNT(DATE_TRUNC('hour', "core_tankdata"."record_time" AT TIME ZONE 'Asia/Almaty')) AS "experiments",
round(AVG("core_tankdata"."volume")) as "avg_volume",
round(cast(AVG("core_tankdata"."density") as float)) as "avg_density",
AVG("core_tankdata"."mass") as "avg_mass",
AVG("core_tankdata"."level") as "avg_level"
FROM "core_tankdata" WHERE ("core_tankdata"."record_time" >= '2020-01-01 00:00:00+06:00'
AND "core_tankdata"."record_time" <= '2020-04-23 23:59:59+06:00')
GROUP BY DATE_TRUNC('hour', "record_time" AT TIME ZONE 'Asia/Almaty') ORDER BY "hour" ASCК👨
🎈