Mercurial > lbo > hg > analyrics
changeset 66:26c69030419d
cargo fmt
author | Lewin Bormann <lbo@spheniscida.de> |
---|---|
date | Mon, 25 Jul 2022 15:33:48 -0700 |
parents | 2715ed801bb1 |
children | 8b0e474ba90a |
files | src/logsdb.rs |
diffstat | 1 files changed, 4 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/src/logsdb.rs Mon Jul 25 15:33:42 2022 -0700 +++ b/src/logsdb.rs Mon Jul 25 15:33:48 2022 -0700 @@ -384,7 +384,8 @@ let include_bots = if ctx.include_bots { 1 } else { 0 }; // Check later if this query possibly has bad scaling behavior due to no restrictions on // requesttags query. - let result = sqlx::query(r#" + let result = sqlx::query( + r#" SELECT Sessions.start AS start, Sessions.last-Sessions.start AS duration, COUNT(RequestLog.id) AS count, @@ -404,7 +405,8 @@ WHERE atime+? >= ? AND atime+? <= ? AND Sessions.is_bot <= ? GROUP BY Sessions.id ORDER BY Sessions.start DESC, RequestLog.atime DESC -LIMIT 10;"#) +LIMIT 10;"#, + ) .bind(tz_offset) .bind(ctx.from.unix_timestamp()) .bind(tz_offset)