From 8d61f30b9b3743a6244da2dac31b5ba4eb84d6b3 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Sat, 30 Jan 2016 14:53:53 -0500
Subject: [PATCH] Add a script to refresh active servers.

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

diff --git a/scripts/refresh_active_servers_mv.sql b/scripts/refresh_active_servers_mv.sql
new file mode 100644
index 0000000..219a94d
--- /dev/null
+++ b/scripts/refresh_active_servers_mv.sql
@@ -0,0 +1,9 @@
+begin;
+    delete from active_servers_mv;
+
+    insert into active_servers_mv
+    select row_number() over(order by count(1) desc) sort_order, s.server_id, s.name, count(1) games
+    from servers s join games g on s.server_id = g.server_id
+    where g.create_dt >= now() at time zone 'UTC' - interval '1 week'
+    group by 2, 3;
+end;
-- 
2.39.2