S

Size: a a a
S

Н
Z
Z
НК
НК
Z
MIDDLEWARE = [
'django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'django.middleware.locale.LocaleMiddleware',
]
ᅠ
MIDDLEWARE = [
'django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'django.middleware.locale.LocaleMiddleware',
]
Z
Z
Z
Z
query = '''
SELECT
"st"::timestamptz,
round(AVG("core_tankdata"."volume")::numeric, 1) as "avg_volume",
round(AVG("core_tankdata"."density")::numeric, 4) as "avg_density",
round(AVG("core_tankdata"."mass")::numeric, 1) as "avg_mass",
round(AVG("core_tankdata"."level")::numeric, 1) as "avg_level",
round(AVG("core_tankdata"."temperature")::numeric, 1) as "avg_temperature",
round(AVG("core_tankdata"."water_level")::numeric, 1) as "avg_water_level"
FROM generate_series(%(st)s, %(ed)s, interval %(hourly_interval)s) as st, "core_tankdata"
WHERE ("core_tankdata"."record_time" >= st
AND "core_tankdata"."record_time" < st + %(hourly_interval)s
AND "core_tankdata"."tank_id" = %(pk)s)
GROUP BY st ORDER BY st ASC
'''
Z
SELECT "core_tankdata"."id", "core_tankdata"."package_id", "core_tankdata"."controller_id", "core_tankdata"."tank_id", "core_tankdata"."volume", "core_tankdata"."density", "core_tankdata"."mass", "core_tankdata"."level", "core_tankdata"."temperature", "core_tankdata"."water_level", "core_tankdata"."record_time", "core_tankdata"."timestamp" FROM "core_tankdata" WHERE (("core_tankdata"."record_time" AT TIME ZONE 'Asia/Almaty')::date = 2020-01-05 AND "core_tankdata"."tank_id" = 5) ORDER BY "core_tankdata"."record_time" DESCН
Z
Z
Z
Z

Z
Z