diff options
Diffstat (limited to 'playoff/sql.py')
| -rw-r--r-- | playoff/sql.py | 34 |
1 files changed, 0 insertions, 34 deletions
diff --git a/playoff/sql.py b/playoff/sql.py deleted file mode 100644 index 76ea728..0000000 --- a/playoff/sql.py +++ /dev/null @@ -1,34 +0,0 @@ -MATCH_RESULTS = ''' -SELECT t1.fullname, t2.fullname, matches.carry, matches.vph, matches.vpv, matches.corrh, matches.corrv -FROM #db#.matches matches -JOIN #db#.teams t1 - ON t1.id = #db#.matches.homet -JOIN #db#.teams t2 - ON t2.id = #db#.matches.visit -WHERE matches.tabl = %s AND matches.rnd = %s -''' - -BOARD_COUNT = ''' -SELECT segmentsperround*boardspersegment, SUM(sc1.contract IS NOT NULL AND sc2.contract IS NOT NULL) -FROM #db#.scores sc1 -JOIN #db#.scores sc2 - ON sc1.rnd = sc2.rnd - AND sc1.segment = sc2.segment - AND sc1.tabl = sc2.tabl - AND sc1.board = sc2.board - AND sc1.room = 1 - AND sc2.room = 2 -JOIN #db#.admin -WHERE sc1.tabl = %s AND sc1.rnd = %s -''' - -TOWEL_COUNT = ''' -SELECT #db#.admin.boardspersegment * SUM(#db#.segments.towel > 0) -FROM #db#.segments -JOIN #db#.admin -WHERE #db#.segments.tabl = %s AND #db#.segments.rnd = %s -''' - -PREFIX = ''' -SELECT shortname FROM #db#.admin -''' |