From d065a79f147341f2bc3a9cf2c96a4e8c94b98b6a Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Sat, 25 Mar 2017 21:25:12 +0100
Subject: rewrite to update data explicitely

---
 templates/index.html | 24 ++++++++++++------------
 1 file changed, 12 insertions(+), 12 deletions(-)

(limited to 'templates')

diff --git a/templates/index.html b/templates/index.html
index e6b6ee1..4b96767 100644
--- a/templates/index.html
+++ b/templates/index.html
@@ -68,7 +68,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/></b></h4>
+                            <h4>{{ data.turrets_rebuilt }}<b class="currency"><br/></b></h4>
                         </div>
                         <p class="description">rebuilt by workers every day</p>      
                     </div> 
@@ -83,7 +83,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE NOT winner AND created_at > NOW() - '1 day'::INTERVAL") }} <b class="currency"><br/>out of {{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}<br/></b></h4>
+                            <h4>{{ data.minions_for_nothing }} <b class="currency"><br/>out of {{ data.minions_total }}<br/></b></h4>
                         </div>
                         <p class="description">died for nothing</p>      
                     </div> 
@@ -98,7 +98,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT COUNT((item_grants->>'*1045_Item_FountainOfRenewal*')::INT)-COUNT((item_uses->>'*1045_Item_FountainOfRenewal*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+                            <h4>{{ data.fountains_wasted }}</h4>
                         </div>
                         <p class="description">bought for the looks</p>      
                     </div> 
@@ -113,7 +113,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM(participant.crystal_mine_captures) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+                            <h4>{{ data.crystal_sentries }}</h4>
                         </div>
                         <p class="description">slaughtered</p>      
                     </div> 
@@ -128,7 +128,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM((participant.item_sells->>'*1038_Item_Flare*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+                            <h4>{{ data.flares_sold }}</h4>
                         </div>
                         <p class="description">thrown in trash</p>      
                     </div> 
@@ -143,7 +143,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT (SUM(match.duration)/60*5) / SUM(roster.kraken_captures) FROM match JOIN roster ON roster.match_api_id=match.api_id WHERE match.created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+                            <h4>{{ data.minions_per_kraken }}</h4>
                         </div>
                         <p class="description">are needed to unleash a Kraken</p>      
                     </div> 
@@ -158,7 +158,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM((item_uses->>'*1041_Item_MinionCandy*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+                            <h4>{{ data.minion_candies }}</h4>
                         </div>
                         <p class="description">Minion parties</p>      
                     </div> 
@@ -173,7 +173,7 @@
                     <div class="content">
                         <div class="price">
                             <h6>every</h6>
-                            <h4>{{ sql_val("SELECT SUM(match.duration)/60 / (SUM((participant.item_uses->>'*1052_Item_WeaponInfusion*')::INT) + SUM((participant.item_uses->>'*1053_Item_CrystalInfusion*')::INT)) FROM participant JOIN roster ON participant.roster_api_id=roster.api_id JOIN match ON roster.match_api_id=match.api_id WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/>minutes</b></h4>
+                            <h4>{{ data.infusions_min }}<b class="currency"><br/>minutes</b></h4>
                         </div>
                         <p class="description">a hero gets high</p>      
                     </div> 
@@ -189,7 +189,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM((item_uses->>'*1054_Item_ScoutTrap*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/></b></h4>
+                            <h4>{{ data.scout_traps }}<b class="currency"><br/></b></h4>
                         </div>
                         <p class="description">made the Fold a Dangerous Place</p>      
                     </div> 
@@ -205,7 +205,7 @@
                     <div class="content">
                         <div class="price">
                             <h6></h6>
-                            <h4>{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE hero='*SAW*' AND created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/></b></h4>
+                            <h4>{{ data.saw_turrets }}<b class="currency"><br/></b></h4>
                         </div>
                         <p class="description">were pushed by SAW in the last 24h</p>      
                     </div> 
@@ -222,7 +222,7 @@
                         <p class="description">
                             Based on Vainsocial users' data from the past 24 hours that by no means is representative to the whole player base of Vainglory.
                         </p>
-			<!-- {{ sql_val("SELECT COUNT(*) FROM match WHERE created_at > NOW() - '1 day'::INTERVAL") }} matches are taken into account for the calculations. -->
+                        <!-- {{ data.matches }} matches are taken into account for the calculations. -->
                     </div>
                     <div class="filter"></div>
                 </div>
@@ -261,7 +261,7 @@
     
 
     <script type="text/javascript">
-        var minions_per_second = {{ sql_val("SELECT SUM(minion_kills)/(24*60*60)::FLOAT FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }};
+        var minions_per_second = {{ data.minions_min }};
         var minions = 0;
         // sum(minions killed) / (seconds per day)
         setInterval(() => {
-- 
cgit v1.3.1