From 28c71a792b244bb87b5dc83263e3c3d0a0310676 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sun, 19 Mar 2017 11:01:10 +0100 Subject: hero stats: add pick_rate --- api.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'api.py') diff --git a/api.py b/api.py index 11efabb..6c291a2 100644 --- a/api.py +++ b/api.py @@ -84,6 +84,7 @@ class Cruncher(joblib.worker.Worker): SELECT heros.id, SUM(participant.winner::INT)/COUNT(participant.winner)::FLOAT AS win_rate, + COUNT(participant.hero)/(SELECT COUNT(hero) FROM participant)::FLOAT AS pick_rate, SUM(60*participant.minion_kills/match.duration::FLOAT)/COUNT(participant.farm)::FLOAT AS cs_per_min, 0 AS gold_per_min FROM participant @@ -101,10 +102,10 @@ class Cruncher(joblib.worker.Worker): for stat in stats: stat_id = await self._con.fetchrow(""" - INSERT INTO stats(win_rate, cs_per_min, gold_per_min) + INSERT INTO stats(win_rate, pick_rate, cs_per_min, gold_per_min) VALUES($1, $2, $3) RETURNING stats.id - """, stat["win_rate"], stat["cs_per_min"], + """, stat["win_rate"], stat["pick_rate"], stat["cs_per_min"], stat["gold_per_min"]) await self._con.fetch(""" INSERT INTO hero_stats(hero_id, dimension_id, stats_id, computed_on) -- cgit v1.3.1