From 6133b6357ce5bcb03e4f47121f72f89ddb835f38 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Sat, 30 Jan 2016 14:48:17 -0500
Subject: [PATCH] Add script to refresh the active players MV.

---
 scripts/refresh_active_players_mv.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 scripts/refresh_active_players_mv.sql

diff --git a/scripts/refresh_active_players_mv.sql b/scripts/refresh_active_players_mv.sql
new file mode 100644
index 0000000..c3064d9
--- /dev/null
+++ b/scripts/refresh_active_players_mv.sql
@@ -0,0 +1,11 @@
+begin;
+	delete from active_players_mv;
+
+	insert into active_players_mv
+	select row_number() over(order by sum(pgs.alivetime) desc) sort_order, p.player_id, p.nick, sum(pgs.alivetime) alivetime
+	from players p join player_game_stats pgs on p.player_id = pgs.player_id
+	where pgs.create_dt >= (now() at time zone 'UTC' - interval '1 week')
+	and p.active_ind = true
+	and p.player_id > 2
+	group by 2, 3;
+end;
-- 
2.39.2