summaryrefslogtreecommitdiff
path: root/playoff/sql.py
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-02-25 18:44:50 +0100
committeremkael <emkael@tlen.pl>2017-02-25 18:44:50 +0100
commit6762fb4bd2b02048a5657b0f2c68b279fdd48176 (patch)
tree9d7ec94e29c61845635af3d8eccc20715d9116c6 /playoff/sql.py
parente0fed55e7bf5b00a85fa0aa4949ba589cf1804d3 (diff)
Towel support
Diffstat (limited to 'playoff/sql.py')
-rw-r--r--playoff/sql.py7
1 files changed, 7 insertions, 0 deletions
diff --git a/playoff/sql.py b/playoff/sql.py
index d5c28cd..69cd423 100644
--- a/playoff/sql.py
+++ b/playoff/sql.py
@@ -22,6 +22,13 @@ JOIN #db#.admin
WHERE sc1.tabl = %s AND sc1.rnd = %s
'''
+TOWEL_COUNT = '''
+SELECT #db#.admin.boardspersegment * SUM(#db#.segments.towel)
+FROM #db#.segments
+JOIN #db#.admin
+WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s
+'''
+
PREFIX = '''
SELECT shortname FROM #db#.admin
'''