From 37df04c91788d023681c8a7015b9807764974a1d Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Tue, 3 Oct 2017 16:20:22 +0200
Subject: Ability to classify teams from specified position according to
 sepatare tournament results

---
 jfr_playoff/sql.py | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'jfr_playoff/sql.py')

diff --git a/jfr_playoff/sql.py b/jfr_playoff/sql.py
index b01bd08..afbfbfb 100644
--- a/jfr_playoff/sql.py
+++ b/jfr_playoff/sql.py
@@ -34,3 +34,19 @@ WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s
 PREFIX = '''
 SELECT shortname FROM #db#.admin
 '''
+
+SWISS_ENDED = '''
+SELECT (rnd = roundcnt) AND (segm = segmentsperround) FROM #db#.admin
+'''
+
+SWISS_RESULTS = '''
+SELECT #db#.teams.fullname,
+ SUM(IF(#db#.matches.homet = #db#.teams.id, vph+corrh, vpv+corrv))
+  + #db#.teams.score,
+ #db#.teams.grupa
+FROM #db#.teams
+LEFT JOIN #db#.matches
+ ON (#db#.teams.id = #db#.matches.homet OR #db#.teams.id = #db#.matches.visit)
+WHERE #db#.teams.bye = 0
+GROUP BY #db#.teams.id
+'''
-- 
cgit v1.2.3