diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2016-03-06 21:48:19 +0100 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2016-03-06 21:48:19 +0100 |
commit | 681cd42eda3b1099f13eefa585673a06f12de405 (patch) | |
tree | e26f7674d6a9e7a027462d960b6e2917a2f2b4fe /src/DillerDao.js | |
parent | 45267e41368fbb9fb318fb455981110e83c97953 (diff) | |
download | diller-server-681cd42eda3b1099f13eefa585673a06f12de405.tar.gz diller-server-681cd42eda3b1099f13eefa585673a06f12de405.tar.bz2 diller-server-681cd42eda3b1099f13eefa585673a06f12de405.tar.xz diller-server-681cd42eda3b1099f13eefa585673a06f12de405.zip |
core:
o Supporting aggregate levels of 'minute' and 'day' in addition to the existing 'hour'.
Diffstat (limited to 'src/DillerDao.js')
-rw-r--r-- | src/DillerDao.js | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/DillerDao.js b/src/DillerDao.js index 7620541..a59adb8 100644 --- a/src/DillerDao.js +++ b/src/DillerDao.js @@ -192,13 +192,13 @@ function DillerDao(tx, as) { function aggregateValuesByPropertyId(propertyId, level, from, to) { var sql, args = [level, as.date(from), as.date(to), propertyId]; - if (level == 'hour') { + if (level == 'hour' || level == 'minute' || level == 'day') { // TODO: use correct table instead of querying raw table } else { throw 'Unsupported level: ' + level; } - sql = 'with g as (select * from generate_series($2::timestamp, $3::timestamp, (\'1 \' || $1)::interval) as times(ts)),\n' + + sql = 'with g as (select date_trunc($1, ts) as ts from generate_series($2::timestamp, $3::timestamp, (\'1 \' || $1)::interval) as times(ts)),\n' + 'v as (select\n' + ' date_trunc($1, timestamp) as ts,\n' + ' count(timestamp)::real as count,\n' + |