From fc95ef5dfbeb5607df2f222db50a017a2f522bea Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Sat, 18 Mar 2017 20:48:54 +0100
Subject: add skill tier filtering

---
 api.py | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'api.py')

diff --git a/api.py b/api.py
index f82cba1..11efabb 100644
--- a/api.py
+++ b/api.py
@@ -77,6 +77,8 @@ class Cruncher(joblib.worker.Worker):
                 filter_query = "WHERE match.patch_version='" + value + "'"
             if field == "recent_matches":
                 filter_query = "WHERE match.api_id IN (SELECT api_id FROM match ORDER BY created_at DESC LIMIT " + value + ")"
+            if field == "skill_tier":
+                filter_query = "WHERE participant.skill_tier=" + value
 
             stats = await self._con.fetch("""
             SELECT
-- 
cgit v1.3.1